topic Re: Sync data in SQL to sf in Workato Pros Discussion Board

Sync data in SQL to sf

nvinay091 — Thu, 10 Feb 2022 18:02:26 GMT

Hi Team ,
This is an urgent requirement:
I have a SQL Table in which data gets on adding ( New rows are created )
I want to send that data to SalesForce object .
I don't want to check for any conditions , I just want to push the data to Sf.

Trigger should be : New row created in SQL server table
Action should be copy that to SalesForce to the Mapped fields.
I mean to create a row in SF.

Without checking any conditions ( is it present in sf previously or not .... No need to check )
Just send the data to sf ...

Please reply fast

Re: Sync data in SQL to sf

viswanathan-r — Thu, 10 Feb 2022 18:10:53 GMT

https://app.workato.com/recipes/822962-new-updated-row-in-a-table-in-sql-server-will-upsert-opportunity-in-salesforce?community=true

Re: Sync data in SQL to sf

viswanathan-r — Thu, 10 Feb 2022 18:12:29 GMT

https://app.workato.com/recipes/897589-sync-sql-server-records-to-sfdc-contacts?community=true

Re: Sync data in SQL to sf

vinay-narayana — Thu, 10 Feb 2022 18:18:40 GMT

Hi Viswanathan R

That has a condition .... If contact id is present

and there is no need to update for me, only insert no upsert

That community library recipe will not work

Re: Sync data in SQL to sf

max-knutsson — Thu, 10 Feb 2022 18:25:58 GMT

Instead of Upsert which requires a key, you can use "Create -YourObject- In Salesforce"

Re: Sync data in SQL to sf

viswanathan-r — Thu, 10 Feb 2022 18:26:36 GMT

https://app.workato.com/recipes/2212047?st=c4dde9

Re: Sync data in SQL to sf

max-knutsson — Thu, 10 Feb 2022 18:38:48 GMT

Another recipe idea to concider is to use Bulk Trigger => Bulk Create in Salesforce, this will make things a lot faster for many records (more than 100 or so)

Re: Sync data in SQL to sf

gwilkinson — Fri, 11 Feb 2022 21:42:17 GMT

Bulk is the way to go if volume can be large and your use case can handle it, which it sounds like it can. The challenges with bulk are what does the response to the bulk request contain, will it contain record level specific errors so appropriate action can be taken (and automated), is it all or nothing on commit, etc.? Most apps we integrate with in bulk, commit the transactions that pass validation and return record level responses for each record we send in the batch. Batch size is typically 1,000.