---
schema_version: "1"
id: d2edb785f89b5bd892f09ddfbe8cd246a823e68794ee67910e3d0a1e225c354e
title: Microsoft Azure Synapse Analytics Connection
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_microsoft_azure_sql_dw_settings.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_microsoft_azure_sql_dw_settings.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2fed721bbff373e177a783e8da01503e4bd1b5972f53b1a5486470a8802d3d61
description: Create a remote connection using the Microsoft Azure Synapse Analytics connector to sync data from Azure Synapse Analytics or dedicated SQL pool (formerly SQL DW) to CRM Analytics. To connect to SQL databases on Azure, add an Azure SQL Database Connection instead of this one.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Microsoft Azure Synapse Analytics Connection

Create a remote connection using the Microsoft Azure Synapse Analytics connector to sync data from Azure Synapse Analytics or dedicated SQL pool (formerly SQL DW) to CRM Analytics. To connect to SQL databases on Azure, add an Azure SQL Database Connection instead of this one.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note Azure SQL and Synapse connections support only SQL authentication with username and password. If Azure is configured to have Entra-only authentication, authentication for this connection fails. In the Azure settings, ensure **Support only Microsoft Entra authentication for this server** is disabled. For more information, see [Microsoft Azure help](https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-tutorial?view=azuresql&tabs=azure-portal).

## Create the Connection

1. On the Data Manager Connections tab, click **New Connection**.
2. Click the name of the connector, and click **Next**.
3. Enter the connector settings.
4. To validate your settings and attempt to connect to the source, click **Save & Test**. If the connection fails, CRM Analytics shows possible reasons.

All settings require a value, unless otherwise indicated.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d101795e85">Setting</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d101795e88">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Connection Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. Identifies the connections. Use a convention that lets you easily distinguish
              between different connections.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Developer Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. The API name for the connection. This name can’t include spaces. The API name is
              used in your recipes to reference data extracted through this connection. You can’t
              change the developer name after you create the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. A description for the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Azure DW JDBC URL</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">
              <p>Required. The URL
                schema for the database. Enter in the format: <kbd>&lt;host
                  name&gt;:&lt;port&gt;</kbd></p>
              <p>To form the host name, append
                <kbd>.sql.azuresynapse.net</kbd> or
                <kbd>.database.windows.net</kbd> to the server name. The server name
                is found by following <span class="doc_external_link"><a href="https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/connect-overview" target="_blank">Microsoft’s
                    documentation</a></span>. For example, if your server’s name is
                <em>Blue_server</em>, the host name is <em>Blue_server.sql.azuresynapse.net</em>.
                The default port is 1433.
              </p>
              <div>
                <p>Azure DW JDBC URL example:
                </p>
                <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>Blue_server.sql.azuresynapse.net:1433</code></pre>
              </div>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Database</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. The name of the Microsoft Azure Synapse Analytics database that you’re connecting
              to.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Azure DW JDBC Username</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. The user name to connect to the Microsoft Azure Synapse Analytics account.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Azure DW JDBC Password</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. The password to connect to the Microsoft Azure Synapse Analytics account.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Azure DW Schema Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. The name of the schema in Microsoft Azure Synapse Analytics.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Azure Blob Account Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. Then name of the Microsoft Azure Synapse Analytics Storage account to stage the
              files.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e85 ">Azure Blob Account Key</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d101795e88 ">Required. The Microsoft Azure Storage access key to stage the files.</td>

          </tr>

        </tbody>
      </table>

## Filter Data Synced to CRM Analytics

Exclude unnecessary or sensitive data from syncing to CRM Analytics with data sync filters. Filters run on the source object and speed up data sync by pulling only the data you need into CRM Analytics. If you plan to use excluded data in the future, use a recipe filter to limit the data written to a dataset instead of a data sync filter.

1. From Data Manager, click the **Connections** tab.
2. Select the connection associated with the object to filter.
3. Click the name of the object to filter.
4. Click **Data Sync Filter**.
5. Enter the filter.
6. Click **Save**.

For the Microsoft Azure Synapse Analytics connector, enter a filter in the syntax described in the [Azure SQL Database](https://docs.microsoft.com/en-us/azure/sql-database/) and [Dynamic SQL](https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql) documentation.

## Connector Considerations

Keep these behaviors in mind when working with an Azure Synapse Analytics connector.

- Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
- Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
- The connector can sync up to 20 million rows or 10 GB per object, whichever limit is reached first. When using the connector, Salesforce Government Cloud org data is protected in transit with advanced encryption and can sync up to 10 million rows or 5 GB for each connected object, whichever limit is reached first.

#### See Also

- [Microsoft Azure Synapse Analytics Connector Known Issues and Knowledge Articles](https://sfdc.co/msasqldwhconnsearch)
- [Add and Remove Remote Objects and Fields from Data Sync](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_replicate_connection.htm&release=264.0.0&type=5 "Update data sync for connected external data sources to keep up with your changing business by adding objects, removing objects, and managing which fields are synced. Synced data is stored in CRM Analytics as objects that can be used in recipes.")