Oracle connector to read data from an Oracle source on-premise

[pmscorca]

Hi,

I'd like to know if it exists any Oracle connector to read data from an Oracle source on-premises as in Azure Data Factory.

It seems that a such connector isn't exist in Fabric Data Factory.

Thanks

[v-cboorla-msft · Accepted solution]

Hi @pmscorca 

Thanks for using Microsoft Fabric Community.

In Microsoft Fabric, you can utilize the Odbc connector to connect to an Oracle database even if it’s hosted on-premises.

To establish a connection to an on-premises Oracle database using the ODBC connector within Microsoft Fabric Dataflow Gen2, it is essential to ensure all necessary ODBC prerequisites are fulfilled prior to initiating the connection process.

For more details please refer : Set up your Odbc connection

Even with data pipelines, you can use the OPDG connector to connect to an Oracle database.

Document to refer : Integrating On-Premises Data into Microsoft Fabric Using Data Pipelines in Data Factory

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

[cw88]

@v-cboorla-msft : I can't find the "Oracle database" as data source in a data pipeline. How does it work?

Thanks!

[v-cboorla-msft]

Hi @cw88 

Please refer to the following documentation for Data pipeline connectors in Microsoft Fabric.

It appears the feature may not yet be available in your region. Our internal team has confirmed a planned rollout to all regions within the next few weeks.

I hope this information helps.

Thank you.

[v-cboorla-msft]

Hi @pmscorca 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @pmscorca 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.