Open Source JavaScript Business Intelligence Software for Mac

BIRT is an open source technology platform used to create data visualizations and reports that can be embedded into rich client and web applications. Developers who use BIRT Designer are able to access information from multiple data sources easily and quickly in order to create reports and applications with stunning data visualizations. Actuate now provides a free report server, BIRT iHub F-Type, to deploy BIRT content so developers don't have to build their own infrastructure. With a flexible Open Data Access framework, developers can write custom data drivers to access data from any source, including Big Data sources like Apache Hadoop, Cassandra, and MongoDB, along with all traditional relational databases, Flat Files, XML data streams, and data stored in proprietary systems. Built for embedding, BIRT includes APIs for data access, chart generation, output formats, content execution, and integration within larger applications.

****Refer to the improved version of the same application @ https://sourceforge.net/projects/query2report/ **** Light weight reporter, LWR, is a simple web based reporting building and publishing application. LWR transforms bunch SQL queries to charts and displays in a report. Each report has one or more elements arranged in rows and columns. Each element has title, SQL Query, database connection pointing to database from where data is retrieved and type of graph/table renderer. The application uses google charts (default) or jfree charts to build the charting components. User has to define database connection by providing the username, password, driver and connection URL. We can define multiple database connection pointing to different databases building a report retrieving data from different databases. By clicking on the desired element in the report marks the element to auto refresh every 5 minutes by default (default can be changed).