topic Re: SQL server to SalesForce in Workato Pros Discussion Board

SQL server to SalesForce

nvinay091 — Tue, 18 Jan 2022 18:41:36 GMT

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

Re: SQL server to SalesForce

nvinay091 — Tue, 18 Jan 2022 21:20:49 GMT

Can anyone reply

Re: SQL server to SalesForce

molly-masterso1 — Wed, 19 Jan 2022 01:39:29 GMT

Hi Dev Raj - I'll reach out internally to see if there are any resources available that might be able to help you out!

Re: SQL server to SalesForce

nvinay091 — Wed, 19 Jan 2022 17:04:22 GMT

Waiting for your response

Re: SQL server to SalesForce

gwilkinson — Wed, 19 Jan 2022 20:57:10 GMT

Hi Raj, I assume your question is not an issue with how to trigger your recipe from new/updated data in one or more SQL tables, correct?

It appears your question is how to map data from multiple SQL Server tables to SF. More information on your requirements is needed to understand your questions, both on the SQL Server end and the SF API end.

Examples of additional information required: How many SQL tables and what entities are involved? Does data from each SQL table represent an individual (independent) transaction or do you need to gather data from multiple SQL tables to construct a parent-child (one to many) nested data structure that then needs to be mapped to SF? Does the data from the various SQL tables map to a single SF API or are there multiple SF APIs required?