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.

CredentialDescription
Connection stringThis 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 IDThe 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.

CredentialDescription
ServerThe fully qualified domain name of your Azure Synapse Analytics SQL endpoint.
DatabaseThe name of the specific database within your Azure Synapse Analytics workspace.
TenantThe Azure Active Directory tenant ID associated with your Azure subscription.
Service principal IDThe client ID of an Azure Active Directory application.
Service principal keyThe client secret or password associated with the service principal.
Connection spec IDThe 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.