Forum Discussion
Super UserConnection to On-Premise Oracle Database with Fabric Data Pipeline
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
Power ParticipantHi,
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
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,
VivienHi Vivien,
I see that the documentation says that the ODBC is not supported:
Set up your Odbc connection - Microsoft Fabric | Microsoft Learn
Regards,
Adrian
