https://systematic.workato.com/t5/workato-pros-discussion-board/sql-server-to-salesforce/m-p/2096#M865 <P>Iam trying to create a recipe, <BR />Requirement: If there is an update or New data created in SQL server tables it has to be updated in SF ,. <BR /><BR />1. How to do data Mapping <BR /><BR />2. As per requirement can u please write Recipe steps </P> Tue, 18 Jan 2022 18:41:36 GMT nvinay091 2022-01-18T18:41:36Z https://systematic.workato.com/t5/workato-pros-discussion-board/sql-server-to-salesforce/m-p/2096#M865 <P>Iam trying to create a recipe, <BR />Requirement: If there is an update or New data created in SQL server tables it has to be updated in SF ,. <BR /><BR />1. How to do data Mapping <BR /><BR />2. As per requirement can u please write Recipe steps </P> Tue, 18 Jan 2022 18:41:36 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/sql-server-to-salesforce/m-p/2096#M865 nvinay091 2022-01-18T18:41:36Z https://systematic.workato.com/t5/workato-pros-discussion-board/sql-server-to-salesforce/m-p/2097#M866 <P>We make use of update/insert triggers on several tables and write it into A new table with A treated switch, tableid, recordid and timestamp field. The Recipe reads the records to be treated and according the tableid reads the inserted/updated records</P> Wed, 19 Jan 2022 03:20:18 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/sql-server-to-salesforce/m-p/2097#M866 s-vanhemelen 2022-01-19T03:20:18Z