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-karpurapud]

Hi @V-yubandi-msft 

We have not yet heard back from you about whether our response addressed your query?If so, kindly mark the helpful response and accept it as the solution to assist other community members in resolving similar issues more efficiently. If it did not, please share more details so we can assist you more effectively.

Thank You.

[v-karpurapud]

Hi @LituRout 

We are following up once again regarding your query. Could you please confirm if the issue has been resolved?If not, please provide detailed information so we can better assist you.

Thank you for your understanding and participation.

[V-yubandi-msft]

Hello @LituRout ,

Please let me know if my response was helpful or if you are still experiencing any issues. If the problem is resolved, you can mark it as solved.

Thank You.

[V-yubandi-msft · Accepted solution]

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.