2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The DBSync for Database To Salesforce Integration is an easy to use solution to integrate Database data with Salesforce objects like accounts, contacts, products, opportunity & opportunity line items. The Database To Salesforce Integration solution is also useful to migrate historical Salesforce data into database. 


Panel

Data Flow

This tutorial serves as an illustration for reading various records from Database and writing to the respective mapped objects of Salesforce . The below table depicts the data flow between various tables of Database to chosen Salesforce objects. The data flow various for each implementation but serves only as reference. 

Panel

Process Map

The process map for Database To Salesforce solution is as shown in below image.

...

Tip

For the sake of understanding, I We have chosen MySQL database with tables as contacts, customers, items, oppheader, opplineitem in which data from Salesforce is dumped. You can download the sql script from download script link and import the table structures into your MySQL database if you have the same integration requirement which this tutorial explainsdetails out.

Panel

DBSync Project Setup

...