2

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), SQL Server connectors/adapters, 3rd party connector platforms, anything. Thank you!

0

My understanding is that you will need to use the SOAP Bulk API to populate the Big Objects. This typically means having the data to upsert in CSV format and including the index.

See Populate a Custom Big Object.

In the Force.com-Toolkit-for-NET this should correspond to the BulkForceClient

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.