topic How to get data into a lakehouse or warehouse from SQL, Mongo without pipelines? in Dataflow

How to get data into a lakehouse or warehouse from SQL, Mongo without pipelines?

Anonymous — Wed, 31 Jul 2024 20:09:19 GMT

1. We have an on prem SQL server with some tables to be brought into Fabric. Is there a way to insert data from this SQL server into a Fabric lakehouse or warehouse directly, without using pipelines?

2. We have data from MongoDB to be brought into Fabric. Is there a way to insert this data into a Fabric lakehouse or warehouse directly, without using pipelines?

Re: How to get data into a lakehouse or warehouse from SQL, Mongo without pipelines?

Anonymous — Thu, 01 Aug 2024 03:24:32 GMT

Hi Anonymous ,

Based on your description, I think you can use dataflow gen2 and then configure its destination to lakehouse or warehouse.

Refer to the steps below:

After publish successfully, you can see data in lakehouse.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to get data into a lakehouse or warehouse from SQL, Mongo without pipelines?

frithjof_v — Fri, 02 Aug 2024 05:32:46 GMT

As far as I know, shortcuts or mirroring is not available for on-prem SQL Server or MongoDB.

So you would need to use some ETL method to get the data into Fabric (e.g. data pipeline, dataflow gen2, notebook, etc.)