Azure Data Factory

Azure Data Factory is a cloud-based data integration and orchestration service by Microsoft Azure. See all your ETLs in decube and monitor the status of your jobs.

Supported Capabilities

Data Quality	Capability
Freshness	❌
Volume	❌
Schema Drift	❌
Field Health	❌
Custom SQL	❌
Job Failure	✅

Catalog	Capability
Data Profiling	❌
Data Preview	❌

Data Recon	Capability
Add Recon	❌

Minimum Requirement

From our Azure account, we will need the following information:

• Subscription ID

• Tenant ID

• Client ID

• Client Service

• Resource Group Name

• Factory Name

Connect to Azure Data Factory.

How to connect

1. On the Azure Home Page, go to Azure Active Directory.

1. Go to App registrations.

1. Click on New registration.

1. Click Register.

1. Save the Application (client) ID and Directory (tenant) ID.

2. Click Add a certificate or secret.

3. Go to Client secrets and click + New client secret.

1. Click Add.

1. Copy and save the Value.

1. Go to Data Factories and click the factory you wanna add.

1. Go to Access Control (IAM).

1. Click on + Add and select Add role assignment.

1. Select Data Factory Contributor.

1. Go to Members tab and Click on + Select members.

1. Search and select the service principal that was created in the previous step. Click on Select.

1. Go to Review + assign tab and Click Review + assign

1. Go to Data Factories and select the factory you wanna add, copy the Name and Resource group.

1. Copy the Subscription ID.

1. Fill all the required fields in the connection form, and click on Test this connection once connection is successful, give your database a name and connect the data source.