Oracle database connector overview

The Oracle database connector is supported in Data Factory for Microsoft Fabric with the following capabilities.

Support in data pipelines

The Oracle database connector supports the following capabilities in data pipelines:

Supported capabilities Gateway Authentication
Copy activity (source/destination) On-premises Basic
Lookup activity On-premises Basic
Script activity On-premises Basic

To learn about how to connect to Oracle database in data pipelines, 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.

Note

To use Oracle connector in date pipelines, please install Oracle Client for Microsoft Tools (OCMT) on the computer running on-premises data gateway. For detailed steps, go to Prerequisites.