Page tree
Skip to end of metadata
Go to start of metadata


DBSync for Database To Salesforce Integration is an easy to use solution. It integrates Database with Salesforce objects like accounts, contacts, products, opportunity & opportunity line items. 

Data Flow

This tutorial shows how to read various records from Database and write to the respective mapped objects of Salesforce . The table below shows the data flow between tables from Database to Salesforce objects. The data flow may be different for each implementation. The following table is just one of the examples: 

Process Map

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

Prerequisites For Integration

The integration prerequisites are as follows:

  • Have valid licenses to DBSync Salesforce, Database Connector and Username and Password to connect with DBSync iPaaS platform.
  • Have Salesforce login and password to access their Web Services.
  • Setup security in Salesforce to connect to external integration.
  • Have a valid database Username, Password, host/IP address and Port on the hosted database.
  • The Username and Password configured for Database Connector instance should have sufficient privilege to access the database required for integration.

Configuring Source App

Follow the steps below to get started with a database and to configure the database connector.

  1. The table below gives the required, and optional, parameters to be set for establishing a connection of database and to write various tables as chosen in the relevant workflows.
  2. Click Save to save the parameter settings:
UsernameDatabase UsernameYes
PasswordDatabase PasswordYes
HostHost name or IP address of the database serverYes
PortThe port used to connect to database serverYes
DatabaseThe name of your databaseYes

JDBC Driver for the Databases mentioned in the URL section in the same order.

  • sqlserver
  • oracle
  • mysql
  • postgresssql
  • db2          
  • access
Database URL

JDBC connection string

  • SQLServer:
  • Oracle:
  • mySQL:
  • PostgresSQL:
  • DB2:
  • Access:

Configuring Target App

Follow the steps to configure the DBSync's Salesforce Connector: 

  1. Click Edit on the Salesforce connector to input Salesforce parameters.
  2. Click Save to save the settings.

The table below gives the required, and optional, parameters to be set for establishing a connection of Salesforce from which you can read the data and write to Salesforce.





The username to log into salesforce account.



The password to login to salesforce account






Session Id



For compression


Proxy Host

If you use a proxy server then put <<proxy ip or host>>


Proxy Port

If you use a proxy server then put <<proxy port>>


Proxy Username

If you use a proxy server then put <<proxy username>>


Proxy Password

If you use a proxy server then put <<proxy password>>


Accept Gzip

As Applicable


Send Gzip

As Applicable


For the sake of understanding, we have chosen MySQL database with tables like - Contacts, Customers, Items, Oppheader, Opplineitem. Data from the database is sent to configured Salesforce instance. You can download the sql script from download script link. Then, import the table structures into your MySQL database if you have the same integration requirement listed in the tutorial.

DBSync Project Setup

  1. Login into www.mydbsync.com. Click on Customer Login.
  2. Enter your DBSync Username and Password and click on Login.
  3. Once logged in, click on template library menu from the left side navigation.
  4. Search for template name Salesforce To Database: uni-directional template and, import to your workspace.
  5. You will be re-directed to Connector listing of the Salesforce To Database: uni-directional template.
  6. In the Connector listing page, you can see Salesforce and database Connector.
  7. Click Edit to configure Connectors respectively. Individual Connector configuration are explained in the subsequent sections.
  8. Navigate to the process listing page to view the pre-defined mappings.
  9. Various transformations can be applied to each field through the mapping section. Then, save the workflow 
  10. Click 'Run Now' button to initiate the integration of the selected workflow.
  11. The sync can be monitored through the log section in event of the error. You can also drill down to each event log to debug, and to fix, the error at its occurrence.

Run Integrations

Integration can be run using scheduler; or, by clicking on the 'Run Now' button. Scheduler job are used to trigger process at scheduled time interval automatically. On the other hand, manual trigger of the sync can be initiated by clicking on the 'Run Now' button from the process listing page/workflow page.


To create a scheduler job, follow the steps below.

  1. Inside a Project, navigate to the Scheduler page from the left side navigation.
  2. From the 'Add schedule section' create a schedule job. Select the process from the drop down then choose start on date , start on time and repeat frequency. Save the job.
  3. If repeat frequency is set to no repeat then, the scheduled job triggers syncs only once - as per scheduled date and time.
  4. If repeat frequency is set to either minutes, hourly or weekly then, the process is scheduled to run at the repeated set frequency.

Run Now 

To manually trigger the sync, click Run Now button:

  1. From the Process listing page.
  2. From the Workflow listing page.
  3. From the Trigger page.

Related References

Salesforce Connector

Database Connector


  • No labels