Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
You can use the Azure Data Factory tool to extarct data from Oracle database and MariaDB to Warehouse via Fabric Pipeline
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.
Hi @jwryu
Glad that you query got resolved.
Please continue using Fabric Community for further queries.
Thanks.
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.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Check out the April 2024 Fabric update to learn about new features.