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.
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.
The process map for Database To Salesforce solution is as shown in below image.
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.
DBSync Project Setup