> For the complete documentation index, see [llms.txt](https://docs.decube.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.decube.io/transformation-tools/azure-data-factory.md).

# Azure Data Factory

## Supported Capabilities

{% tabs %}
{% tab title="Supported Capabilities" %}
**General**

* **Metadata** — metadata extraction and display of asset information (tables, columns, schemas). Types collected: Schema, Virtual Table, Virtual Column, Data Job, Data Run, Data Task
  {% endtab %}

{% tab title="Not Supported" %}
**General**

* Profiling
* Preview
* Data Quality
* Configurable Collection
* External Table
* View Table
* Stored Procedure
  {% endtab %}
  {% endtabs %}

Azure Data Factory can map lineage relationships to upstream and downstream objects from the following connectors:

* Upstream Connectors: postgresql, mysql, synapse, azure\_server, databricks, sql\_server, redshift, bigquery, adls
* Downstream Connectors: postgresql, mysql, synapse, azure\_server, databricks, sql\_server, redshift, bigquery, adls

## Connection Requirements

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

* Tenant ID
* Client ID
* Client Secret
* Subscription ID
* Resource Group Name
* Factory Name
* Data Source Name

<figure><img src="/files/rTB8vNdkpJV3Puq1xDLL" alt=""><figcaption><p>Azure Data Factory</p></figcaption></figure>

### How to connect

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

<figure><img src="/files/fYWKXkVNOEMTTsgmPZa6" alt=""><figcaption></figcaption></figure>

2. Go to `App registrations`.

<figure><img src="/files/AYbMSbCP9LwS3JqMsMz2" alt=""><figcaption></figcaption></figure>

3. Click on `New registration`.

<figure><img src="/files/CvSZIIAC61TodJPFCFJB" alt=""><figcaption></figcaption></figure>

4. Click `Register`.

<figure><img src="/files/iiqIxFcrbHBFGZtzS3rb" alt=""><figcaption></figcaption></figure>

5. Save the `Application (client) ID` and `Directory (tenant) ID`.
6. Click `Add a certificate or secret`.
7. Go to `Client secrets` and click `+ New client secret`.

<figure><img src="/files/SzwLmJjq5BI3kkYzsNW8" alt=""><figcaption></figcaption></figure>

8. Click `Add`.

<figure><img src="/files/LkeMT798jDzvVUprbQd8" alt=""><figcaption></figcaption></figure>

9. Copy and save the `Value`.

<figure><img src="/files/YwbsKAOB1VptaFW7yWSL" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/p1nI4M3vbPzNPbijszQY" alt=""><figcaption></figcaption></figure>

11. Go to `Access Control (IAM)`.

<figure><img src="/files/ZTQIJU03NKVfg7xXQz29" alt=""><figcaption></figcaption></figure>

12. Click on `+ Add` and select `Add role assignment`.

<figure><img src="/files/IMTTxF3q6ScWyGb7ADY0" alt=""><figcaption></figcaption></figure>

13. Select `Data Factory Contributor`.

<figure><img src="/files/Mt5ngQ1Bso8tAOVhhfmV" alt=""><figcaption></figcaption></figure>

14. Go to `Members` tab and Click on `+ Select members`.

<figure><img src="/files/uPbVykoymIFFEvHArM8S" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/Wp3rtUACk9RvDDErp4Ck" alt=""><figcaption></figcaption></figure>

16. Go to `Review + assign` tab and Click `Review + assign`

<figure><img src="/files/ucDLmh4UgqL0WwD58TQZ" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/pELdq8DFoHJjkeNcJwB8" alt=""><figcaption></figcaption></figure>

18. Copy the `Subscription ID`.

<figure><img src="/files/RiqnkhsUIe05H09WdIWr" alt=""><figcaption></figcaption></figure>

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