| title | ODBC connector overview | ||
|---|---|---|---|
| description | This article provides an overview of the supported capabilities of the ODBC connector. | ||
| ms.topic | how-to | ||
| ms.date | 03/03/2026 | ||
| ms.custom |
|
||
| ai-usage | ai-assisted |
The open database connectivity (ODBC) connector is supported in Data Factory for [!INCLUDE product-name] with the following capabilities.
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/-) | On-premises | Anonymous Basic Windows |
| Pipeline - Copy activity (source/destination) - Lookup activity |
On-premises | Anonymous Basic |
| Copy job (source/destination) - Full load - Append |
On-premises | Anonymous Basic |
To learn about how to connect to ODBC, go to Set up your ODBC connection.
To learn about the copy activity configuration for ODBC in pipelines, go to Configure ODBC in a copy activity.