Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
pmscorca
Post Patron
Post Patron

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

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

1 ACCEPTED SOLUTION
v-cboorla-msft
Community Support
Community Support

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.

vcboorlamsft_1-1715319176204.png

vcboorlamsft_2-1715320440225.png

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.

View solution in original post

6 REPLIES 6
v-cboorla-msft
Community Support
Community Support

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.

vcboorlamsft_1-1715319176204.png

vcboorlamsft_2-1715320440225.png

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.

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

Thanks!

Hi @cw88 

 

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

vcboorlamsft_0-1715787106921.png

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.

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.

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.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.