How to copy data from Salceforce to SQL SERVER tables

  • Hello Good Morning,

    I have about 8 tables in salceforce  i would like to copy/load them into sql server daily.

    (just truncate and reload) in sql server. but automated way not manual loading.

    please share any thoughts or ideas...

    Thank you

    Asita

  • Your into writing an application/powershell/ssis/c#/vb.net stuff to talk to salesforces soap apis and running some soql to csv files then pushing those into your database.

    If it was me would be SSIS but whatever skills you have available would make it work as long as you can query the api right your good.

  • I'd do what's suggested above, likely Python or PoSh for me. Schedule this to run, secure credentials somehow

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply