Show Menu
TOPICS×

Create a Microsoft SQL Server source connector in the UI

The Microsoft SQL Server connector is in beta. See the Sources overview for more information on using beta-labelled connectors.
Source connectors in Adobe Experience Platform provide the ability to ingest externally sourced data on a scheduled basis. This tutorial provides steps for creating a Microsoft SQL Server (hereinafter referred to as "SQL Server") 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 SQL Server base connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow .

Gather required credentials

In order to connect to SQL Server on Platform, you must provide the following connection property:
Credential
Description
connectionString
The connection string associated with your SQL Server account. The SQL Server connection string pattern is: Data Source={SERVER_NAME}\\<{INSTANCE_NAME} if using named instance>;Initial Catalog={DATABASE};Integrated Security=False;User ID={USERNAME};Password={PASSWORD}; .
Please refer to this document for more information on getting started with SQL Server.

Connect your SQL Server account

Once you have gathered your required credentials, you can follow the steps below to create a new inbound base connection to link your SQL Server 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 inbound base connections with, and each source shows the number of existing base connections associated to them.
Under the Databases category, select Microsoft SQL Server to expose an information bar on the right-hand side of your screen. The information bar provides a brief description for the selected source as well as options to connect with the source or view its documentation. To create a new inbound base connection, select Add data .
The Connect to Microsoft SQL Server 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 the base connection with a name, an optional description, and your SQL Server credentials. When finished, select Connect and then allow some time for the new base connection to establish.

Existing account

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

Next steps

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