Forum Discussion
How to get data into a lakehouse or warehouse from SQL, Mongo without pipelines?
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?
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.)
