Search

Azure Data Factory

Version 22.0.8486

Azure Data Factory

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

Prerequisites

Before you connect, you must first connect a data source to your CData Connect account. See Data Model for more information.

Note: To connect Azure Data Factory to CData Connect, your CData Connect instance must be hosted in an internet-facing server that is accessible to other entities through a stable URL (for example, myConnectInstance.cdata.com). If your instance of CData Connect is hosted locally and only accessible from a localhost address (for example, localhost:8080) or local network IP address (for example, 192.168.1.x), it will not be able to communicate with Azure Data Factory.

Connecting to CData Connect

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

  1. Login to Azure Data Factory.

  2. 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.

  3. Open Azure Data Factory Studio and select your Data Factory.

  4. In the Factory Resources section, highlight the Datasets option.

  5. Click the three dots to open the Dataset actions and select New Dataset.

  6. In the search bar, enter SQL Server and select it when it appears.

  7. Enter a name for the server. In the Linked service field, select New.

  8. Enter the connection settings.

    • Name—enter a name of your choice.

    • Server name—enter the server name from the Azure Data Factory connection modal in CData Connect

    • 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 as defined on the Users page.

    • Password—select Password (not Azure Key Vault) and enter the password for the user.

  9. Click Create.

  10. Select your new connection in the Linked service field.

  11. Select your desired table and click OK.

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