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

[jwryu]

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.

[sam004]

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

[prom · Accepted solution]

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]

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.

[v-cboorla-msft]

Hi @jwryu 

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

Thanks.

[v-cboorla-msft]

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.