2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DBSync Cloud Replication (Salesforce with Azure Synapse)

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

...

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 5 - Copy the Key and connection string and paste them to the Given space on DBSync Database connection page



DBSync Limitation(s) 

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

...