We have SAP and Hybris hosted onprem, which are the book of record for product and promo. The goal is to build a ETL solution to send to partner systems on products on promotion (effectively joining the feeds from both systems), the technical objective is to leverag azure cloud to build something scalable and reusable.
Shown in the diagram, I am thinking to use Azure Event Hub to build a steaming ETL, with SAP to replicate the product catalog to SQL Azure then use asa job to filter out by the Hybris promo events. However, with the size of SAP product, it does not seems to be a better fit.
Please help share some thoughts or best practices for this use case. Thanks