You are here:
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 Salesforce Data Pipelines. To connect to SQL databases on Azure, add an Azure SQL Database Connection instead of this one.
Create the Connection
- On the Data Manager Connections tab, click New Connection.
- Click the name of the connector, and click Next.
- Enter the connector settings.
- To validate your settings and attempt to connect to the source, click Save & Test. If the connection fails, Salesforce Data Pipelines shows possible reasons.
All settings require a value, unless otherwise indicated.
| Setting | Description |
|---|---|
| Connection Name | Required. Identifies the connections. Use a convention that lets you easily distinguish between different connections. |
| Developer Name | 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. |
| Description | Required. A description for the connection. |
| Azure DW JDBC URL | Required. The URL schema for the database. Enter in the format: <host name>:<port> To form the host name, append .sql.azuresynapse.net or .database.windows.net to the server name. The server name is found by following Microsoft’s documentation. For example, if your server’s name is Blue_server, the host name is Blue_server.sql.azuresynapse.net. The default port is 1433. Azure DW JDBC URL example: |
| Database | Required. The name of the Microsoft Azure Synapse Analytics database that you’re connecting to. |
| Azure DW JDBC Username | Required. The user name to connect to the Microsoft Azure Synapse Analytics account. |
| Azure DW JDBC Password | Required. The password to connect to the Microsoft Azure Synapse Analytics account. |
| Azure DW Schema Name | Required. The name of the schema in Microsoft Azure Synapse Analytics. |
| Azure Blob Account Name | Required. Then name of the Microsoft Azure Synapse Analytics Storage account to stage the files. |
| Azure Blob Account Key | Required. The Microsoft Azure Storage access key to stage the files. |
Filter Data Synced to Salesforce Data Pipelines
Exclude unnecessary or sensitive data from syncing to Salesforce Data Pipelines with data sync filters. Filters run on the source object and speed up data sync by pulling only the data you need into Salesforce Data Pipelines. 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.
- From Data Manager, click the Connections tab.
- Select the connection associated with the object to filter.
- Click the name of the object to filter.
- Click Data Sync Filter.
- Enter the filter.
- Click Save.
For the Microsoft Azure Synapse Analytics connector, enter a filter in the syntax described in the Azure SQL Database and 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.
