Forum Discussion
Ingesting on premise data with notebooks
Hi Anonymous
Which database are you referring here? Can you please specify?
Multiple local PG instances
Hi Anonymous
You should use a Data Pipeline to copy the data to lakehouse. Fabric data pipelines will be added to the On Prem data gateway in the next few months.
What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
If you need something sooner, you should use Azure Data Factory Pipelines with the Self-Hosted Integration Runtime. For more information please refer to these links:
Copy on-premises data using the Azure Copy Data tool - Azure Data Factory | Microsoft Learn
How to ingest data into Fabric using the Azure Data Factory Copy activity - Microsoft Fabric | Microsoft Learn
Hope this helps. Please let me know if you have any further queries.I know about the roadmap, but it's still couple month, we need it now.
In regards to the COPY activity, I am pretty sure you can't use it to build incremental ETL (to append), it re-copies all the data every time you run it, so this is not suitable for us.Hi Anonymous
There is no other work around in Microsoft Fabric for ingesting on-premise data. I have shared all the possible options.
tmjones2Helper I
So we have to manually create pipeline activities for each table we want? There's really no way to do it in code?
smeetshContinued Contributor
Create views on your on prem server, joining the tables you need, if there is a relation between then of course.
Next use a copy data action in a pipeline to call that view and ingest it into a lakehouse. Thats how we do it for multiple tables at my work.
I'm not realy sure where the advantage would be to do it with a notebook, since you would (depending on your database structure) have to either call multiple tables in a notebook, use multiple notebooks, or create a join between tables in a notebook.
Cheers
Hans