Forum Discussion
Ingesting on premise data with notebooks
Hi, I have an on premise database with a running PowerBI gateway and this is how we connected to these sources previously. Now, the requierement is that we would recreate our ETL process in Microsoft...
smeetsh
Continued Contributor
Continued ContributorWe ingest data from an on prem MSSQL server by having created a view on the on-prem server that gets us the information we need.
That view is than called from a pipeline, using a gateway, which allows us to enter the data into a "lakehouse raw" table and next we do the ETL from there. We use the sql endpoint for the ETL, but I assume you could also use a notebook to do it.