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
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?
Solved! Go to 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.
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.
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.
Check out the October 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
6 | |
5 | |
5 | |
4 | |
2 |