Skip to main content
Last updated on

Create a Dynamics 365 connection

Create a Dynamics 365 connection in Catalog Explorer to store authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create Dynamics 365 ingestion pipelines without needing direct access to the credentials.

Alternatively, admin users can create a connection and a pipeline at the same time in the data ingestion UI. See Create an ingestion pipeline.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites​

Complete the source setup. Use the authentication details you obtain to create the connection.

Create a connection​

  1. In the Databricks workspace, click Data icon. Catalog > Create > Create a connection.
  2. On the Connection basics page of the Set up connection wizard, specify a unique Connection name.
  3. In the Connection type drop-down menu, select Dynamics 365.
  4. (Optional) Add a comment.
  5. Click Next.
  6. On the Authentication page, specify the following:
    • Client secret: The secret value for your Microsoft Entra ID application registration. Obtain this from the source setup.
    • Client ID: The unique identifier (Application ID) for your Microsoft Entra ID application registration. Obtain this from the source setup.
    • Azure storage account name: The name of the Azure Data Lake Storage Gen2 account where Synapse Link exports your D365 data.
    • Tenant ID: The unique identifier for your Microsoft Entra ID tenant. Obtain this from the source setup.
    • ADLS container name: The name of the container within your Azure Data Lake Storage (ADLS) Gen2 account where the D365 data is stored.
  7. Click Create connection.

Next steps​

Create an ingestion pipeline.

On this page