Connection to On-Premise Oracle Database with Fabric Data Pipeline

[vivien57]

Hello everyone,

It's easy to connect to an Oracle On-Premise database with a DataFlow but it seems to be more complex with a Data Pipeline?

Indeed, with Azure Data Factory (in the Azure ecosystem) the definition of a linked service allows you to do this, but on the Data Pipeline Fabric side this doesn't seem to be possible.

Has anyone managed to answer this scenario?

Thanks in advance,

Have a nice day

[v-cboorla-msft]

Hi @vivien57 

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

Thanks

[vivien57]

In fact, coming soon
https://learn.microsoft.com/en-us/fabric/release-plan/data-factory#opdg

[DennesTorres]

Hi,

Data pipelines don't support on premisse gateways yet. You need to use a dataflow gen 2 for that.

Kind Regards,

Dennes

[vivien57]

Hello, 

Thank you for your feedback,

However, if we look at this post on Azure Data Factory, it is listed as possible.

https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-data-stores-an...

This would mean that in an Azure Data Factory (Azure ecosystem) -> Data Pipelines (Fabric) migration we would have to redo the On-Prem -> Cloud flows?

[DennesTorres · Accepted solution]

Hi,

If I'm not mistaken, the list says it's possible the connection to Oracle, not to Oracle on premises. Being on premises is the limitation.

Unfortunatelly, at the moment, yes, you would need to migrate the flows.

But let's assume you are ingesting this data into a lakehouse on an Azure data lake storage. You could create shortcuts on your fabric lakehouse to this data lake storage and keep using data factory until the fabric pipeline support for on premises connection is released.

Kind Regards,

Dennes

[A_J_G]

The OPDG is now supported but Oracle databse is not one of the options available in data pipelines.

[vivien57]

Hello,

With datapipelines, you can use the ODBC connector to connect to an Oracle database.

have a nice day,

Vivien

[A_J_G]

Hi Vivien,

I see that the documentation says that the ODBC is not supported:

Set up your Odbc connection - Microsoft Fabric | Microsoft Learn

Regards,

Adrian