2022
Table of Contents |
---|
Panel |
---|
Overview |
DBSync for Salesforce and Database Integration is an easy to use solution to integrate Salesforce objects like accounts, contacts, products, opportunity & opportunity line items. Salesforce to Database uni-directional Integration solution is also useful to migrate historical Salesforce data into database. DBSync DBSync provides uni-directional sync with pre-built field to field map along with flexibility for more complex and dynamic mapping capabilities. DBSync also has an automatic online update, enabling DBSync customers to enjoy all the product updates and features with every new release.
Panel |
---|
Data Flow |
This tutorial serves as an illustration for reading various records from Salesforce and writing to the configured tables of a database. The below table depicts the data flow between various objects of Salesforce objects to the chosen database tables.
Panel |
---|
Process Map |
The process map of the uni-directional solution between Salesforce and a and database is as shown in below image.
Panel |
---|
Prerequisites For Integration |
The prerequisites for this integration are as follows
The username and password configured for Database connector instance should have sufficient privilege to access the database which is required for integration requirement.
Panel |
---|
Configuring Source App |
The below are the steps to get started with your Salesforce instance and to configure the DBSync's Salesforce connector
...
Property | Description | Required |
---|---|---|
UserName | The username to log into salesforce account. | yes |
Password | The password to login to salesforce account | Yes |
End-point | yes | |
Sid | Session Id | optional |
Transport.compression | For compression | optional |
Proxy Host | If you use a proxy server then put <<proxy ip or host>> | optional |
Proxy Port | If you use a proxy server then put <<proxy port>> | optional |
Proxy Username | If you use a proxy server then put <<proxy username>> | optional |
Proxy Password | If you use a proxy server then put <<proxy password>> | optional |
Accept Gzip | As Applicable | optional |
Send Gzip | As Applicable | optional |
Panel |
---|
Configuring Target App |
The below are the steps to get started with a database and to configure the database connector.
...
Tip |
---|
For the sake of understanding, I have chosen MySQL database with tables as contacts, customers, items, oppheader, opplineitem in which data from Salesforce is dumped. In case if you do not have existing database in which you wish to dump the data to database, you can use autocreate functionality of database connector which would create the table structure and mapping basing on the source table. |
Panel |
---|
DBSync Project Setup |
Panel |
---|
Guide Lines For customization And Mapping |
Panel |
---|
Run Integrations |
Integration can be run using scheduler or Run Now button. Scheduler job are used to trigger process at scheduled time interval automatically while as manual trigger of the sync can be initiated by hitting the Run Now button from the process listing page / workflow page.
To create a scheduler job , one have to follow the below steps.
...
Panel |
---|
Related References |
...