Building a reporting service in Microservice architecture

We were told that sharing is caring but not in case of microservices where we have one database per service. One service cannot access data to another service by directly connecting to a database instead we need some other mechanism (REST API's ) to fulfill our need. Generating reports from the distributed database requires a lot of effort and most of the time we end up implementing the anti-pattern of Microservices.

Let's illustrate by example. Say we have two microservices from which 1 holding data of orders while other holding…