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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.decube.io/transformation-tools/azure-data-factory.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.