# Azure Synapse

* 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](https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits)
  * [Known limitations](https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues)

### **DBSync Cloud Replication (Salesforce with Azure Synapse)** <a href="#azuresynapse-dbsynccloudreplication-salesforcewithazuresynapse" id="azuresynapse-dbsynccloudreplication-salesforcewithazuresynapse"></a>

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](https://docs.mydbsync.com/cloud-replication-main/source-setup/salesforce), 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&#x20;

* **Select Database**

![](https://help.mydbsync.com/docs/download/attachments/68878348/edit1.png?version=1\&modificationDate=1675345197000\&api=v2)

* **Select Azure Synapse Analytics as a destination.**

![](https://help.mydbsync.com/docs/download/attachments/68878348/2.png?version=1\&modificationDate=1675345269000\&api=v2)

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

![](https://lh4.googleusercontent.com/wfGux_OqUEzE-G1e9qxP6HoxX5vQX-qZtVo17uUtfqhTlXh5bZ2UxSg7C-wzgOSDhuHc7xbUmFpc-FmUxfPFslQGUkTy_dz3bPoao5FqMmXwAUn-cVf8vdMrsQg4IV3vL0guQKEZYPNo-fj-oXo64xw)

**Use with Azure Blob:**

![](https://lh6.googleusercontent.com/Kj_mFI0C2Np9kA-T8A0G2SD2upkthLu2e-IRJhbHnUmxGTuhLhJKWBwKOK7UBQYPjqiY7JMD9YcbsSnooBKVKE2Nqmd5RZ8SjN-Eda9nK3Mm4SwlA-xoI4MJT2qn1-ht6qTZPI9-z7ue_btaAPqH-gM)

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&#x20;
* Azure Synapse Analytics -> SQL Pool  -> Select your database -> Select connection string&#x20;

![](https://lh6.googleusercontent.com/Hxuzou_LXjlL8zDL2h8Q8iZ8I6ubvB_eWmJ4UqW6WWD2hAhUMlvFM5bsxmGFIxfncKljJapxkKEURhH_KKDuHgHKVNvi0iODLX2yosxq0VxCK_XyKgYXZt5JxAB83n7MxIhrSJCFFNC7BM84kCQATqE)

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

**Step 1- Login to your** [**Azure portal**<br>](https://login.microsoftonline.com/organizations/oauth2/v2.0/authorize?redirect_uri=https%3A%2F%2Fportal.azure.com%2Fsignin%2Findex%2F\&response_type=code%20id_token\&scope=https%3A%2F%2Fmanagement.core.windows.net%2F%2Fuser_impersonation%20openid%20email%20profile\&state=OpenIdConnect.AuthenticationProperties%3DQKAF7iE5hiUvzXXH_lVZu0ytKIsIuKOazTwX06t762bl7KCx3bSDw4RElkaJ-geBfgdrRD2wdrf_EtOSmuPX6vZIK1HhdRSEtUM_Yps2pk-z3QrnleGLWnxsDo11_c6zGNgct7YIAssWziJYe3AMN1O78JUb0040gXx162ucAyZHkIK6jldgy7Jdi_5VUVHt6gsLZywX7QwzTtN0FOFRzrDXQ7ui8Ap3sQatVHaHSLlNXH-9amZ3b3qvBQuX9R0DNSAG7OPQ-KZNYVaJD77jJkvJGmx3BGdpvyD9-6bnxnHGm6h6r5GHnIpc1oVr-MukZSCFjdntXtIl44QBSRJJqqCGU6KV6DdGlJMxC4p8KnzRtEpvAYyWxP3NeAtuDkwwIaijxD8whuZOeKxROLqqAHu5tOee01bzTSDbxF0DvxNJ7X1HIXhLfT_xNz4EEMv0xg0MEW2ZtKey7O6M13J6K0vsYYuN2Zq1zDdPuUtcQp4\&response_mode=form_post\&nonce=637998796405180311.YmQwOTM3ZTYtNjk4NS00MGNmLTk3MWEtNDRiZDc2MDcyYThlY2UwMjQzMmItZjhhNi00MTBmLTgwMTItMmU2MzlmYTM5ZWQw\&client_id=c44b4083-3bb0-49c1-b47d-974e53cbdf3c\&site_id=501430\&client-request-id=e546651e-772c-4c28-a231-b83a7765db72\&x-client-SKU=ID_NET472\&x-client-ver=6.16.0.0\&sso_reload=true)**Step 2- On the home screen select the Storage account From Azure services**&#x20;

![](https://help.mydbsync.com/docs/download/attachments/68878348/storage%20account.PNG?version=1\&modificationDate=1675345016000\&api=v2)

\
**Step 3- Inside Storage accounts select the Desired storage you want to connect with**&#x20;

![](https://lh3.googleusercontent.com/0_gElMUH2VePDMSXwFnYU9fnHBc0n5WOFJX9yPkRv_EXlFwKJircWV3NiawpRcRX_PIUt3YcxSNLjUmruTnHYPM80seSN3UFqESri9yVKTcndKwtIeVpbH3S2bUDuvwbl6CL7oJfcGdhWVqa-2MsG_8)

**Step 4- Inside the selected storage click on access key from left hand panel**&#x20;

![](https://lh4.googleusercontent.com/60cewetNKOK_DmQd19Ht0Ae-iHgs71QJW0N-7Ju6NvEIFiyEFvX_BTW_hPSGAUzG5G6LOLKsBPqh_JWEGinrI8cX3A6x8goIaIPySfbtrGHbKku1ArCM17DaFuhrGVY3s1iWX1d1e6dwKiMP-g4IQmE)

**Step 5 - Copy the Key and connection string and paste them to the Given space on DBSync Database connection page**\
![](https://lh3.googleusercontent.com/ZESkCMlBEf0WEWL30Bgh_cEgXpfxWEWiOhg8tycsXJGC0i475EEpv7OZevcD2DW5pqyPUk1eALiJRE5NscXpxPEf8GElr-ksYkYtaD_RbRQB-e4DvEIHHsYXvYgAPDn-VQgZMRVC5rW7wnGnVJ6eREw)

#### DBSync Limitation(s)  <a href="#azuresynapse-dbsynclimitation-s" id="azuresynapse-dbsynclimitation-s"></a>

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

1. Export
2. Restore&#x20;
3. Metadata&#x20;
4. History tracking