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.
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 Microsfot Entra admin center and retrieve values for the following:
- App ID
- Display name
- Secret
- Tenant ID
Next, navigate to your Azure Synapse Analytics instance 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 “SELECT” as it is required for schema preview, similar to “COPY”. For instance, an example command can be:
GRANT SELECT ON SCHEMA::dbo TO {APP_ID};
Provide values for the following credentials to connect your Azure Synapse Analytics database to Experience Platform using service-principal key authentication.
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 Azure documentation on managing identities for Azure Synapse Analytics.