SQL server to SalesForce

[nvinay091]

Iam trying to create a recipe,
Requirement: If there is an update or New data created in SQL server tables it has to be updated in SF ,.

1. How to do data Mapping

2. As per requirement can u please write Recipe steps

[s-vanhemelen]

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