Connecting ERP to Fabric

[cannoli]

I am looking into leveraging Microsoft Fabric to rebuild my data infrastructure which currently involves migrating data from multiple ERPs into an on prem data warehouse. I am finding it difficult to achieve scalability and flexibility. Does anyone know if it is possible to ingest data from an ERP into a lakehouse using Fabric or ADF? If so, is this a feasible way to accomplish this transformation? My goal is to migrate towards a cloud based approach.

[TomMartens · Accepted solution]

Hey @cannoli ,

there is a very short answer: yes, you can ingest data from an ERP to a lakehouse.

You can use the copy activity of a pipeline in combination with an on-premises data gateway, "copy" the data to the bronze layer of the lakehouse, then use notebooks (my recommendation) to "transform" the bronze data to silver. If you are not familiar with the medallion architecture this might help: https://www.youtube.com/watch?v=gqTWFBzgAlg

Hopefully, this provides you with an idea of how to tackle your challenge.

Regards,

Tom

[cannoli]

Thank you for the reply Tom! Everything seems to be working smoothly.

[v-cboorla-msft]

Hi @cannoli 

Thanks for using Microsoft Fabric Community.

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @cannoli 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.