Azure Data Factory

This page outlines the steps to connect Azure Data Factory to the CData Connect Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

Connect a data source to your CData Connect account. See Connections for more information.
Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

To establish a connection from Azure Data Factory to the CData Connect Virtual SQL Server API, follow these steps.

Login to Azure Data Factory.
If you have not yet created a Data Factory:
1. Click Create and enter your configuration information in each tab.
2. When you are finished entering information, click Review + create and then Create to save the Data Factory.
Open Azure Data Factory Studio and select your Data Factory.
In the Factory Resources section, highlight the Datasets option.
Click the three dots to open the Dataset actions and select New Dataset.
In the search bar, enter SQL Server and select it when it appears.
Enter a name for the server. In the Linked service field, select New.
Enter the connection settings.
- Name—enter a name of your choice.
- Server name—enter the Virtual SQL Server endpoint and port separated by a comma: tds.cdata.com,14333
- Database name—enter the Connection Name of the CData Connect data source you want to connect to (for example, Salesforce1).
- User Name—enter your CData Connect username. This is displayed in the top-right corner of the CData Connect interface. For example, test@cdata.com.
- Password—select Password (not Azure Key Vault) and enter the PAT you generated on the Settings page.
Click Create.
Select your new connection in the Linked service field.
Select your desired table and click OK.

You can now use this Dataset when creating Data flows in Azure Data Factory.