Azure Synapse

DBSync Cloud Replication (Salesforce with Azure Synapse)

Most of the features of DBSync Replication will work the same irrespective of the database.

The general process of Replicating Salesforce to Database and Database to Salesforce is explained in the below links.

Salesforce setup remains the same, to Start with the database setup tab, fill all the necessary details and follow the same procedure for testing and validating your database credentials.

Follow these steps to configure your database credentials

  • Select Database

  • Select Azure Synapse Analytics as a destination.

  • Enter the necessary connection properties. To connect to Azure Synapse, provide authentication properties (see below) and set the following properties to connect to a Azure Synapse database:

Use with Azure Blob:

To obtain optimal performance with replicating to Azure Synapse it is recommended for batch uploads using files, please refer to the link for more details

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool#group-insert-statements-into-batches

Steps to obtain Azure Synapse SQL pool connection details:

  • You can find login details by logging into the Azure portal and navigating to

  • Azure Synapse Analytics -> SQL Pool -> Select your database -> Select connection string

Steps to Get Access key and connection string for Using Azure Blob.

Step 1- Login to your Azure portal Step 2- On the home screen select the Storage account From Azure services

Step 3- Inside Storage accounts select the Desired storage you want to connect with

Step 4- Inside the selected storage click on access key from left hand panel

DBSync Limitation(s)

With Azure Synapse as the target database, following functionalities are not yet supported.

  1. Export

  2. Restore

  3. Metadata

  4. History tracking