Ultimate

Create an Azure Synapse Analytics source connection in the UI

Last update: 2023-06-15
  • Topics:
  • Sources
    View more on this topic
  • Created for:
  • Developer
    User
    Admin
    Leader
IMPORTANT

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

This tutorial provides steps for creating a Azure Synapse Analytics (hereinafter referred to as “Synapse”) source connector using the Platform user interface.

Getting started

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

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

Gather required credentials

In order to access your Synapse account on Platform, you must provide the following values:

Credential Description
connectionString The connection string associated with your Synapse authentication. The Synapse connection string pattern 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.

For more information about this value, refer to this Synapse document.

Connect your Synapse account

Once you have gathered your required credentials, you can follow the steps below to link your Synapse account to Platform.

Log in to Adobe Experience Platform and then select Sources from the left navigation bar to access the Sources workspace. The Catalog screen displays a variety of sources for which you can create an account with.

You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search option.

Under the Databases category, select Azure Synapse Analytics. If this is your first time using this connector, select Configure. Otherwise, select Add data to create a new Synapse connector.

The Connect to Azure Synapse Analytics page appears. On this page, you can either use new credentials or existing credentials.

New account

If you are using new credentials, select New account. On the input form that appears, provide a name, an optional description, and your Synapse credentials. When finished, select Connect and then allow some time for the new connection to establish.

Existing account

To connect an existing account, select the Synapse account you want to connect with, then select Next to proceed.

Next steps

By following this tutorial, you have established a connection to your Synapse account. You can now continue on to the next tutorial and configure a dataflow to bring data into Platform.

On this page