Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
ChathuriGunarat
Frequent Visitor

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?

1 ACCEPTED SOLUTION
v-zhangtin-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
ChathuriGunarat
Frequent Visitor

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.

v-zhangtin-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.