function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sergei Wallace 11Sergei Wallace 11 

How can I setup a scheduled sync from a SQL Server database to Salesforce Big Objects?

What is the best way to have a daily scheduled insert/update of a SQL Table into Salesforce Big Objects? We currently have a C# adapter to update Salesforce standard object records with SQL database data, but I'm not sure if this same approach will work for Big Objects. 

If anyone could elaborate on the best way(s) to integrate a SQL database with Salesforce Big Objects, that would be super helpful. Open to C#/.Net implementations ([we use this currently][1]), SQL Server connectors/adapters, 3rd party connector platforms, anything. Thank you!


  [1]: https://github.com/developerforce/Force.com-Toolkit-for-NET
Boris FrankBoris Frank
Hello! You can use Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server) to integrate Salesforce and SQL Server without coding. You can set the frequency of data updates — for example, once a day.