• SF Engineers
  • 0 Points
  • Member since 2007

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1
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,
Many thanks,