topic Re: Data Flow & Data Pipline in Dataflow

Data Flow & Data Pipline

ChathuriGunarat — Tue, 20 Aug 2024 06:57:05 GMT

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?

Re: Data Flow & Data Pipline

Anonymous — Wed, 21 Aug 2024 02:41:13 GMT

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.

Re: Data Flow & Data Pipline

ChathuriGunarat — Sun, 25 Aug 2024 09:20:00 GMT

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

Re: Data Flow & Data Pipline

Anonymous — Mon, 26 Aug 2024 06:44:43 GMT

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.

Re: Data Flow & Data Pipline

ChathuriGunarat — Wed, 04 Dec 2024 08:26:17 GMT

How does fix this issue,