[Ultimate]{class="badge positive"}
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based analytics service that unifies big data and data warehousing. You can ingest, explore, prepare, and analyze data using SQL, Spark, or real-time tools鈥攁ll without moving your data.
You can use the Azure Synapse Analytics source to connect your account and bring your data to 蜜豆视频 Experience Platform.
Prerequisites prerequisites
Read the following sections to complete the prerequisite setup before you connect your Azure Synapse Analytics account to Experience Platform.
IP address allowlist
You must add region-specific IP addresses to your allowlist prior to connecting your sources to Experience Platform. For more information, read the guide on allowlisting IP addresses to connect to Experience Platform for more information.
Configure permissions
To connect your source account to Experience Platform, your account must have both of the following permissions enabled:
- View Sources
- Manage Sources
If you don鈥檛 have these permissions, contact your product administrator to request access. For more information, read the access control UI guide.
Authenticate to Experience Platform
You can use either account key authentication or service-principal key authentication to connect your Azure Synapse Analytics to Experience Platform.
Provide values for the following credentials to connect your Azure Synapse Analytics database to Experience Platform using account key authentication.
| table 0-row-2 1-row-2 2-row-2 | |
|---|---|
| Credential | Description |
| Connection string | This is the connection string used for authenticating with Azure Synapse Analytics. The standard format is: Server=tcp:{SERVER_NAME}.database.windows.net,1433;Database={DATABASE};User ID={USERNAME}@{SERVER_NAME};Password={PASSWORD};Trusted_Connection=False;Encrypt=True;Connection Timeout=30. You must replace the placeholders with your actual connection details. |
| Connection spec ID | The connection spec provides the connector properties of a data source. This includes details such as authentication specifications and requirements for creating both base and source connections. For Azure Synapse Analytics, the connection spec ID is: a49bcc7d-8038-43af-b1e4-5a7a089a7d79. Note: This credential is only necessary when connecting via APIs. |
To retrieve your credentials for service principal key authentication, navigate to the and retrieve values for the following:
- App ID
- Display name
- Secret
- Tenant ID
Next, navigate to your and then select the option to create a user from an external provider. From here, provide the appropriate permissions for the service principal on the schema. NOTE:: You must include 鈥淪ELECT鈥 as it is required for schema preview, similar to 鈥淐OPY鈥. For instance, an example command can be:
| code language-sql |
|---|
|
Provide values for the following credentials to connect your Azure Synapse Analytics database to Experience Platform using service-principal key authentication.
| table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 | |
|---|---|
| Credential | Description |
| Server | The fully qualified domain name of your Azure Synapse Analytics SQL endpoint. |
| Database | The name of the specific database within your Azure Synapse Analytics workspace. |
| Tenant | The Azure Active Directory tenant ID associated with your Azure subscription. |
| Service principal ID | The client ID of an Azure Active Directory application. |
| Service principal key | The client secret or password associated with the service principal. |
| Connection spec ID | The connection spec provides the connector properties of a data source. This includes details such as authentication specifications and requirements for creating both base and source connections. For Azure Synapse Analytics, the connection spec ID is: a49bcc7d-8038-43af-b1e4-5a7a089a7d79. Note: This credential is only necessary when connecting via APIs. |
For more information, read the .