we have 2 systems 1 system send the data in XMl file and store into Azure Event hub , i need to process XMl file data & store it in sql server table.
multiple files are sent in event hub in 1 seconds.
currently we had tried with
- azure function with store procedure to do that but it has performance issue for failed cases.
- trying to implement azure hub with event grid with logic app & ADF but could not succeed.
could anyone suggest some best approach and links.