topic Re: Oracle connector to read data from an Oracle source on-premise in Pipelines

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

pmscorca — Thu, 09 May 2024 20:42:22 GMT

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

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

v-cboorla-msft — Fri, 10 May 2024 05:56:16 GMT

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.

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

v-cboorla-msft — Mon, 13 May 2024 06:14:02 GMT

Hi pmscorca

Thanks.

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

cw88 — Mon, 13 May 2024 14:19:43 GMT

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

Thanks!

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

v-cboorla-msft — Wed, 15 May 2024 15:17:36 GMT

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.

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

v-cboorla-msft — Wed, 15 May 2024 15:35:32 GMT

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.

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

Anonymous — Tue, 30 Jul 2024 08:37:26 GMT

https://learn.microsoft.com/en-us/fabric/data-factory/connector-oracle-database-copy-activity