Data Flow & Data Pipline

[ChathuriGunarat]

I want to use the OLEDB Connector, which is already available in Microsoft Power BI. However, this component is not available in the Microsoft Fabric platform, so I am unable to connect to the Oracle Database because I need to pass the service ID via the connection string. What solution can I use?

[ChathuriGunarat]

How does fix this issue,

[ChathuriGunarat]

I have successfully configured the VN DataGateway in Fabric. Could you please let me know which connector is used to connect to an Oracle 19c database(On-Premises db) database through the VN Gateway

[v-zhangtin-msft]

Hi, @ChathuriGunarat 

You can use the Oracle Connector. You can use this connector to connect with an on-premises Oracle Database or an Azure virtual machine with Oracle Database installed.

For more information, please refer to this document: Oracle Database - Connectors | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-zhangtin-msft · Accepted solution]

Hi, @ChathuriGunarat 

We support connectivity to the Warehouse or SQL analytics endpoint using OLE DB. Make sure you're running the latest Microsoft OLE DB Driver for SQL Server.

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

If you want to connect to an Oracle database using Microsoft Fabric, you can refer to the following links.

Copy data to and from Oracle - Azure Data Factory & Azure Synapse | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.