Page History

...

• DBSync Cloud Replication (Salesforce with Azure Synapse)

• Azure Synapse Database details in DBSync Replication Profile

  
  

  • Capacity limits for dedicated SQL pool in Azure Synapse Analytics
    
  • Known limitations

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.

...

• 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

...

• 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 

Image Modified

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 

Step 5 - Copy the Key and connection string and paste them to the Given space on DBSync Database connection page

...