Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Oracle database connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Supported capabilities
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/-) | On-premises | Basic |
| Data 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 data pipelines, install Oracle Client for Microsoft Tools (OCMT) on the computer running on-premises data gateway. For detailed steps, go to Prerequisites.
Related content
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 data pipelines, go to Configure in a data pipeline copy activity.