I've recently started learning about microservice architecture. API gateway is a pattern usually proposed for aggregating data from different microservices which own their data stores. However I wasn't able to find anything about being able to do that in a configurable way.
Scenario: Customers should be able to define reports that use aggregated data from different microservices. This should be configurable by not changing the underlying source code.
Possible solution in monolithic architecture:
- Based on customer needs custom SQL Query kept in JSON file is prepared that feeds data to Reporting Framework.
Possible solution in microservice architecture I can think of:
- Having another Reporting microservice using events for synchronization on top of a Data warehouse where we keep information from other microservices. Then we can use simmilar solution as in the monolithic app.
Is there any other way of achieving this? If not are there any patterns ,frameworks , things to consider that can be useful in this scenario ?