2022

Page tree

Versions Compared

Key

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

...

Follow these steps to configure your database credentials 

  • Select Database

Image RemovedImage Added

  • Select Azure Synapse Analytics as a destination.

Image RemovedImage Added



  • 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:

Image RemovedImage Added


Use with Azure Blob:

Image RemovedImage Added

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 

Image RemovedImage Added


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 Removed
Image Added

Step 3- Inside Storage accounts select the Desired storage you want to connect with 
Image Removed
Image Added
Step 4- Inside the selected storage click on access key from left hand panel 
Image Removed
Image Added
Step 5 - Copy the Key and connection string and paste them to the Given space on DBSync Database connection page
Image RemovedImage Added



DBSync Limitation(s) 

...