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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jwryu
Helper II
Helper II

Copying tables from Oracle database and MariaDB to Warehouse via Fabric Pipeline(scheduled batch)

Hello, 

i found out that connecting to Oracle or MariaDB is not supported in Fabric pipeline at the moment.

i know Dataflow Gen2 support those connectors but i do not want to use it since it is too slow(as i know)

and it still does not support fast-copy to on-prem database. 

 

notebook is also not an prefered option for now because the destination must be an Warehouse instead of Lakehouse(what a despair😢)

is there any other options? 

 

Thank you.

1 ACCEPTED SOLUTION
prom
Frequent Visitor

Hi,

You can try using Copy Pipeline for ODBC  with on-prem gateway. It;s better than DF2, almost as fast as ADF Copy. BTW. You can use ADF with Fabric Lakehouse as a destination.

 

Regards.

View solution in original post

5 REPLIES 5
sam004
New Member

You can use the Azure Data Factory tool to extarct data from Oracle database and MariaDB to Warehouse via Fabric Pipeline

prom
Frequent Visitor

Hi,

You can try using Copy Pipeline for ODBC  with on-prem gateway. It;s better than DF2, almost as fast as ADF Copy. BTW. You can use ADF with Fabric Lakehouse as a destination.

 

Regards.

trebllaw
Frequent Visitor

How do you actually do this? On Power BI Service/Microsoft Fabric, we've already created an ODBC Gateway Connection to our Oracle Source. When we try to use the Copy Assistant on the pipeline it requires us to use an Azure Data Lake Storage Gen2 staging environment, which we currently dont have.

Hi @jwryu 

 

Glad that you query got resolved.
Please continue using Fabric Community for further queries.

 

Thanks.

v-cboorla-msft
Microsoft Employee
Microsoft Employee

Hi @jwryu 

 

Thanks for using Microsoft Fabric Community.

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Appreciate your patience.

 

Thanks.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.