[Ultimate]{class="badge positive"}

Create an Azure Synapse Analytics source connection in the UI

IMPORTANT
The Azure Synapse Analytics source is available in the sources catalog to users who have purchased Real-Time Customer Data Platform Ultimate.

Read this guide to learn how to connect your Azure Synapse Analytics account to Adobe Experience Platform using the sources workspace in the UI.

Get started

This tutorial requires a working understanding of the following components of Experience Platform:

If you already have a valid Azure Synapse Analytics connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.

Gather required credentials

Read the Azure Synapse Analytics overview for information on authentication.

In the Experience Platform UI, select Sources from the left navigation to access the Sources workspace. Choose a category or use the search bar to find your source.

To connect to Azure Synapse Analytics, go to the Databases category, select the Azure Synapse analytics source card, and then select Set up.

TIP
Sources in the sources catalog display the Set up option when a given source does not yet have an authenticated account. Once an authenticated account is created, this option changes to Add data.

The sources catalog with "Azure Synapse Analytics" selected.

Use an existing account existing

To use an existing account, select Existing account and then select the Azure Synapse Analytics account that you want to use.

The existing account interface of the sources workflow.

Create a new account new

To create a new account, select New account and then provide a name and optionally add a description for your account.

The new account interface of the sources workflow.

Connect to Experience Platform

You can connect your Azure Synapse Analytics account to Experience Platform using either account key authentication or service principal and key authentication.

Account key authentication

To use account key authentication, select Account key authentication, provide your connection string, and then select Connect to source.

The "create new account" step in the sources workflow with "account key authentication selected.

Service principal and key authentication

Alternatively, select Service principal and key authentication, provide values for your authentication credentials, and then select Connect to source.

The "create new account" step in the sources workflow with "service principal and key authentication" selected.

Create a dataflow for Azure Synapse Analytics data

Now that you have successfully connected your Azure Synapse Analytics database, you can now create a dataflow and ingest data from your database into Experience Platform.

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089