we have client ERP solution which sends XMl file data in Azure Event Hub, we need to process XMl file data & store it in MS sql server table. ERP System send multiple files (1000’s files with different schemas) per seconds into Event Hub.
we did POC’s wh elow 2 approaches
- Azure function with Custom web API’s along with store procedure to do that but it has performance issue for failed cases.
- Event HUB with Logic app – logging & error handling can be critical with this approach.
we don’t have to use blob storage or azure data lake.
please suggest some best approach and links. or any tools which will help us.