topic Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric in Pipelines

I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

cmukul007 — Tue, 21 May 2024 14:36:32 GMT

I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric. I do not want to use onpremise data gateway but use virtual network data gateway. I have a virtual network data gateway created but it does not have the option to chose Oracle as a connection type. Any idea ?

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

v-cboorla-msft — Wed, 22 May 2024 06:46:37 GMT

Hi cmukul007

Thanks for using Microsoft Fabric Community.

Currently you cannot access an on-premise Oracle database in a Data Pipeline within Microsoft Fabric using a virtual network (VNet) gateway.

Virtual Network gateways are designed for connectivity between Azure Virtual Networks and on-premises locations. They don't provide the specific drivers or protocols needed to connect to an Oracle database.
Data Pipelines within Fabric rely on on-premises data gateways (OPDG) for on-premises data access. These gateways act as secure bridges between your on-premises environment and Azure Data Factory (the service behind Fabric data pipelines).

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

Thank you.

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

v-cboorla-msft — Thu, 23 May 2024 16:57:27 GMT

Hi cmukul007

Thanks.

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

cmukul007 — Fri, 24 May 2024 12:29:13 GMT

Thanks for the information.

I am now actually trying to access Oracle on premise database in a notebook in Microsoft Fabric. Do you know if that is already possible?

Initially I got driver error but after doing some configurations now i get the network error. "ORA-17868: Unknown host specified" and i assume this is network error. But how can i resolve that?

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

robert2001b — Mon, 27 May 2024 11:25:45 GMT

You might consider using a Dataflow Gen2 within Data Factory for Microsoft Fabric. Data pipelines currently do not support on-premises gateways, but Dataflow Gen2 can be used to connect to on-premises data sources. Ensure that your firewall is configured to allow outbound connections to *.frontend.clouddatahub.net from the gateway for Fabric pipeline capabilities.

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

cmukul007 — Mon, 27 May 2024 13:39:08 GMT

Yes I can use Dataflow Gen2 but I am looking for a solution where i do not have to provision an on-premise data gateway. It is possible to connect to On-premise database in Azure Databricks Notebooks so I am looking for the same in Microsoft Fabric notebooks. Can you check on this ?

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

v-cboorla-msft — Mon, 27 May 2024 13:50:27 GMT

Hi cmukul007

Apologies for the inconvenience.

Currently, Microsoft Fabric notebooks do not directly support connecting to on-premise databases through the Power BI Gateway. Fabric Spark doesn’t do the integration with PBI gateway.

For similar thread please refer : Re: Ingesting on premise data with notebooks - Microsoft Fabric Community

Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

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

Thank you

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

v-cboorla-msft — Tue, 28 May 2024 17:07:23 GMT

Hi cmukul007

Thanks.

Re: I want to access oracle onpremise database in Data Pipeline in Microsoft Fabric

v-cboorla-msft — Thu, 30 May 2024 15:49:34 GMT

Hi cmukul007

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.