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

[Sachit1]

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?

[frithjof_v]

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

[Anonymous · Accepted solution]

Hi @Sachit1 ,

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.