A Linked Service in ADF is like a connection (connection string) to a data store.
This blog post provides step by step instructions for creating a Common Data Service Linked Service in Azure Data Factory (ADF). I will follow up this post with step by step instructions on how to Create a Common Data Service Dataset in ADF.
This is the first step in creating an ADF Pipeline for your Common Data Service (CDS) migration or integration. So let's get started.
To follow these instructions you will need to create an Azure Activate Directory App Registration and will need the Application (Client Id) and Secret for said App registration. I have a previous blog post explaining how to Create an Azure Activate Directory App Registration at https://www.d365freelancing.com/post/creating-application-users-in-power-platform.
Step by Step Instructions
After opening Azure Data Factory
Click on Manage Icon
Click on Linked Services (under connections)
Click the New button (Screenshot 1: Create new Linked Service in ADF)
Type Common Data Service in the search bar
Select Common Data Service for Apps Linked Service
Press Continue. (Screenshot 2: Select Common Data Service Linked Service)
Set the CDS Linked Service attributes
Name: CommonDataSerive_ContactManagement_SourceAndTarget, I like to include the linked service type, application and the stage of the migration or integration process.
Description: enter a description that describes your linked service and its purpose
Connect via Integration Runtime: AutoResolveIntegrationRuntime, I always use the default and have never had to create a new Integration Runtime.
Deployment Type: Online, obviously use online unless you are one of the few businesses with an on-premises instance of CDS.
Service Uri: the base URL to the Common Data Service instance that is to be connected to.
Authentication Type: AAD Service Principle, always use AAD Service Principle because the office365 Authentication Type does not work at the time of writing this article and might be deprecated based on discussions I have had with Microsoft.
Service Principle Id: The Application (Client) Id from your App Registration.
Service Principle Key: The Client Secret from your App Registration
Click the Test Connection button (Screenshot 3: Common Data Service Linked Service Properties)
If some of the details are wrong then a connection failed message is displayed (Screenshot 4)
If the details are correct then a connection successful message is displayed (Screenshot 5)
Click Create button
That is how a Common Data Service Linked Service can be created in Azure Data Factory. Ensure an App Registration is configured with a client secret before setting up a Common Data Service Linked Service as you will need the Application (Client) Id and Secret.