Azure Data Factory to ADX Free Cluster
Published Oct 23 2022 10:29 PM 1,711 Views
Microsoft

Azure Data Factory to ADX Free Cluster

 

If you are using Azure Data Factory and need to connect to an Azure Data Explorer Free Cluster, this walkthrough will show you how to create the linked service using System Managed Identity.

 

First make a note or copy the URL for your free cluster, example of the one we are using in the walkthrough:

ShafMahmood_0-1666264103576.png

 

From Data Factory select Manage -> Linked Services -> New.

ShafMahmood_1-1666264103582.png

 

 

Select ADX as the Linked Service Data Store.

ShafMahmood_2-1666264103586.png

 

Provide a Name and Description and for Authentication method select System Assigned Managed Identity.

ShafMahmood_3-1666264103592.png

 

 

For Account selection method select Enter manually and enter the URL of your cluster for Endpoint, ensure that the right database is selected if you have more than one.

 

Note: If you are not using the same account you created the cluster with you will not be able to select a database unless you have added permissions for the account.

 

ShafMahmood_4-1666264103600.png

 

At this point you will also see the managed identity name and object ID, make a copy of the object ID.

 

A test connection at this point will fail as you have not yet added permissions to the free cluster.

ShafMahmood_5-1666264103616.png

 

Add permissions to the free cluster for your ADF Managed Identity.

 

Run the following command to add the identity to the database:

 

.add database MyDatabase admins ("aadapp=<Managed Identity Object ID>;<Tenant ID>")

 

ShafMahmood_6-1666264103619.png

 

Once this is done you should be able test and see Connection successful.

ShafMahmood_7-1666264103627.png

 

 

 

Version history
Last update:
‎Oct 23 2022 03:54 PM
Updated by: