Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
1

Questions
0

Replies

Extracting Saleforce.com data to MS SQL Server

Hi,

Hopefully this is the right place to post data extraction questions.

My task is to be able to export the salesforce.com opportunity table to a MS SQL server (currently 2000)database table. Approximatly, we are talking about 150 K records in the opportunity table.

My requirements are:

- Process should be fully automated

- Process should be able to execute 4-5 a day

- On success or failure of extraction, some individuals should be notified

- Nice to have: only opportunities changed or added in the same day should be extracted (So if today is February 2nd, i would like to extract only opportunities that were changed or added on February 2nd)

I was wondering if you can recommend on tools to do this king of work. I heard about dbamp and was wondering whether it's a suitable one, smae goes for the data loader.

Your hints are more than appreciated,

Thanks,

Gili

giladw
February 02, 2007
Like
0