Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

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. T...
General Question
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    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.

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.