# 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/target-setup/azure-synapse.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.