You can drag and drop transformations (Join, Aggregate, Pivot, Derived Column).

Explain how works for on-premise data.

Configure the and Sink (destination) using your datasets.

Supports encryption, private endpoints, and Azure Active Directory integration.

: Named views of data that point to the data you want to use in your activities. Linked Services

You only pay for what you use based on pipeline orchestration, execution hours, and integration runtime consumption. Azure Data Factory vs. SSIS

Once the test succeeds, click at the top of the interface to save your changes to the live Data Factory factory service.

: Think of these as connection strings that define the information needed to connect to external resources, such as an Azure SQL Database or a Blob Storage account.

| Feature | ETL (Extract, Transform, Load) | ELT (Extract, Load, Transform) | | :--- | :--- | :--- | | | Extract -> Transform -> Load | Extract -> Load -> Transform | | Transformation Location | Done on a separate engine (like Spark/Hive) before loading. | Done inside the destination data warehouse (like Synapse). | | ADF Role | ADF orchestrates the external transformation. | ADF moves raw data; transformation happens in the warehouse. |