DBSync Cloud Replication (Salesforce with Azure Synapse)
Azure Synapse Database details in DBSync Replication Profile
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
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
With Azure Synapse as the target database, following functionalities are not yet supported.
Export
Restore
Metadata
History tracking
Step 5 - Copy the Key and connection string and paste them to the Given space on DBSync Database connection page
