| title | Oracle database connector overview | ||
|---|---|---|---|
| description | This article provides an overview of the supported capabilities of the Oracle database connector. | ||
| ms.topic | how-to | ||
| ms.date | 07/09/2025 | ||
| ms.custom |
|
The Oracle database connector is supported in Data Factory for [!INCLUDE product-name] with the following capabilities.
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/-) | On-premises | Basic |
| Pipeline - Copy activity (source/destination) - Lookup activity - Script activity |
On-premises | Basic |
| Copy job (source/destination) - Full load - Append |
On-premises | Basic |
Note
To use Oracle connector in pipelines, install Oracle Client for Microsoft Tools (OCMT) on the computer running on-premises data gateway. For detailed steps, go to Prerequisites.
To learn about how to connect to Oracle database, go to Set up your Oracle database connection.
To learn more about the copy activity configuration for Oracle database in pipelines, go to Configure in a pipeline copy activity.