Oracle Connector Version Compatibility in Fabric Data Factory

[LituRout]

Hi Team,

In Azure Data Factory, we recently received a notification that the Oracle connector version 1.0 will be deprecated, and we are required to switch to version 2.0, which only supports Oracle Database 19c or later.

We are now moving to Microsoft Fabric Data Factory, and I would like to confirm:

Is there any similar version restriction in Fabric Data Factory's Oracle connector when connecting to an on-premises Oracle database?

Does Fabric Data Factory support older Oracle versions (e.g., 11g or 12c), or is it restricted to Oracle 19c+ like ADF v2.0?

Any official documentation or guidance on version compatibility would be really helpful.

[V-yubandi-msft]

Hi @LituRout ,

Thanks for posting your query in the Microsoft Fabric Community. Currently, Microsoft Fabric Data Factory does not enforce a strict requirement for Oracle connections to be version 19c or above. In contrast to Azure Data Factory v2.0, which mandates Oracle 19c or later, Fabric Oracle connector provides greater flexibility.

For connections to an on premises Oracle database, the connector can be used via the on premises data gateway, provided the Oracle Client for Microsoft Tools (OCMT) is installed on the same machine.

Key points to consider

1. The connector supports Copy, Lookup, and Script activities within pipelines.

2. There is no officially specified minimum Oracle version, so older versions such as 11g or 12c may be compatible, assuming the environment is configured correctly.

Refer to Microsoft official documentation for a detailed explanation.
Oracle database connector overview - Microsoft Fabric | Microsoft Learn

Set up your Oracle database connection - Microsoft Fabric | Microsoft Learn

If this was helpful, marking it as the accepted solution can make it easier for others with the same question to find.