Query2Report is a simple opensource business intelligence solution that allows users to build reports and dashboards for data analytics or corporate reporting. The application transforms SQL queries to beautiful and very impressive Google charts. The application offers automatic refresh functionality for nearly real-time reporting.
The different elements in reports can pull data from multiple databases instance belonging to same or different vendor.
A role based security allows the administrators to create public reports and personal workspaces. Angular JS is used to build this application with a responsive user interface design. It run on laptops, mobiles and tablets.
These are the main features:
- web based reporting and dashboard generator
- auto refresh for real-time reporting
- public and personal report workspaces
- integrates with any database using JDBC connections
- role based user access
More information available here:
https://sourceforge.net/projects/query2report/
where you can also find the download link.
Last version issued on August 4th 2018.