Created by Chris Ward, SnapLogic
This pattern connects to an Azure SQL database to perform a query data and then Upserts the results to an object in Salesforce. Both error and successful records are written to a log file within SLDB. The pattern could be used to migrate customer data stored in a transactional Azure SQL table into Salesforce for Sales prospecting. Both Azure SQL & Salesforce accounts are required and the necessary mappings specified in the Mapper Snap.
Sources: Azure SQL Table
Targets: Any Salesforce Object
Snaps used: Azure SQL Execute, Mapper, Salesforce Upsert, JSON Formatter, File Writer
Azure SQL to Salesforce Upsert.slp (12.9 KB)