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.

[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.