Ingest into lakehouse

[innocence84]

Hi all,

How can we ingest data from SQL server oltp databases into lakehouse in fabric? 

I found this link, but it is ingesting data from source files: https://learn.microsoft.com/en-us/fabric/onelake/onelake-medallion-lakehouse-architecture

Thanks

[AndyDDC · Accepted solution]

Hi @innocence84 at the moment you can either use Dataflows Gen2 in Fabric with an onpremises gateway to load data into Fabric.  Or use another service like data factory/synapse pipelines with onpremises gateways to load data into fabric onelake

[v-nikhilan-msft]

Hi @innocence84 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

[innocence84]

Thank you for your support. 😊