How to copy data from Salceforce to SQL SERVER tables

Question

Hello Good Morning,

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

(just truncate and reload) in sql server.

other than SSIS any other ways? such as salceforce side or any automated ways that you aware of? please

please reffer me in any links

Thank you
Asita

Answer 1

Hi @milan i ,

You can using a third part tool Hevo Data , a fully managed and automated tool. Or you can also using a third part tool Skyvia . Skyvia allows you to set a schedule for a package to execute it automatically. This might be useful if you want to configure data loading operations to run periodically or if you want to delay an operation to a later time.

You can also Export Data from Salesforce to SQL Server using Export and Import Wizards, but you need to do this manually.

Refer to below blogs to get more detail information;

Moving Data from Salesforce to SQL Server : 2 Easy Methods
5 Ways to Connect Salesforce to SQL Server

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

Answer 2

Thank you. Cathyji-msft

please share any other thoughts as well

Answer 3

Any open ideas or alternative ideas we have only 10 tables that need be loaded to sql server as is from salce force daily night

Please

Thank you