Forum Discussion
Data Flow & Data Pipline
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?
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.
4 Replies
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.
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
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.
How does fix this issue,
