Hopefully this is the right place to post data extraction questions?
My task is to be able to automate the export of salesforce.com object tables into a MS SQL Server (currently 2005) database tables for backups and adhoc local reporting. In addition, I need to automate the import process for a nightly sync between a few local information tables and salesforce.
My requirements are:
- Process should be fully automated
- Process should be able to execute daily (nice to have incremental rather than full copy for export)
- On success or failure of extraction, some individuals should be notified
Currently, I've been trying to use Data Loader version 7, which now has the functionality to connect to databases through a JDBC connector. However, the examples given are for connecting to Oricale, and I'm not sure what provider / connection string I need to use to connect to MS SQL Server?
For my requirements, I heard about dbAmp and was wondering whether it's a better fit for what I'm doing?
Your comments are more than appreciated,