Reporting Tool for Spring Projects (Getting data from different databases in one report)

In spring projects , we use different databases for  different services .
There will be requirement to get  data from different databases in  to one report . It is practically not an easy task .

But  in  BIRT (an open source technology platform used to create data visualizations and reports that can be embedded into rich client and web applications) reporting tool can address this  issue easily .

First you have to create new separate Data Source connections for all  databases that you want to use .
Second step is  create separate Data Sets (Query to get data from particular database)  for  each  database that you want to use .

Third step is  create new  Join Data Set  using already created data sets in second step . Through this join data sets , you  can easily get data  from different databases to your report without much effort(you can create many Join Data Sets  as you wish) .