Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

slideshows

Posted December 14, 2015

Top 10 MySQL Reporting Tools

By Rob Gravelle

  • Previous
    Top 10 MySQL Reporting Tools
    Next

    Top 10 MySQL Reporting Tools

    Most businesses and governmental agencies require regular and ad hoc reports on stored data. Upper management bases policy and strategy decisions on reports while various departments such as marketing will adjust their efforts in response to information gleaned through reports.


    There are a number of free and commercial reporting products available for MySQL. Some generate canned reports while others offer entire Business Intelligence solutions. Here are a few choice offerings, in no particular order.

  • Previous
    BIRT
    Next

    BIRT

    Short for Business Intelligence and Reporting Tools, BIRT is a top-level open source Eclipse Foundation project that provides data visualization reports that can be embedded into rich client and web applications. Like many, if not most eclipse projects, it mainly favors the Java and Java EE platforms.


    The BIRT project is sponsored primarily by Actuate with additional contributions coming from IBM and Innovent Solutions. The BIRT technology platform has become one of the most widely adopted reporting tools with over 12 million downloads and over 2.5 million developers across 157 countries. Major technology players that have incorporated BIRT into their product lines include IBM and Cisco.

  • Previous
    dmyreports
    Next

    dmyreports

    Here is a dynamic open source report generator specifically designed for MySQL.  It runs on the server in executable PHP scripts. It provides users the ability to select tables, fields, and set conditions graphically using a web-based interface. Generated reports can then be saved or exported to several other formats.


    dmyreports is licensed under the Apache Software License.

  • Previous
    NextReports Suite
    Next

    NextReports Suite

    NextReports Suite offers three open source utilities that support report creation for a variety of database vendors using the Java language.


    NextReports Designer is a GUI tool for building grid-style reports.

    NextReports Engine is a lightweight Java platform development library, which can be used to run NextReports within your applications.


    NextReports Server allows you to view and/or schedule NextReports and Jasper reports. Reports may also be delivered automatically via E-mail, FTP, SSH, Windows Share, or WebDAV.  Supported presentation formats include HTML, EXCEL, PDF, as well as real time dashboards.

  • Previous
    JasperReports
    Next

    JasperReports

    JasperSoft, the makers of JasperReports, offer several free Business Integration products, the most popular of which is the JasperReports Library.  In fact, the company claims that it is the world's most popular open source reporting engine. Written in Java, it can connect to any data source to produce reports that may be viewed, printed, or exported to a variety of document formats, including HTML, PDF, Excel, OpenOffice and Word.


    Other offerings include:

    • the Reporting and Analytics Server
    • Jaspersoft ETL, an open source data integration platform
    • Jaspersoft Studio, an open source report designer
    • visualize.js, a programmable JavaScript framework for embedding reports, visualizations, and analytics inside your applications.
  • Previous
    Navicat for MySQL
    Next

    Navicat for MySQL

    Some commercial database admin tools include reporting as a subset of their total functionality.  Navicat for MySQL is a GUI database administration tool that supports report creation via its Report Editor.  It breaks down the building of a report into three distinct components: Selecting the data, designing the report, and previewing the finished appearance. 


    Navicat for MySQL reports support drilldowns, subreports, charts, crosstab reports, and other advanced features that set it apart from open source products.


    The Report Designer comes with the Enterprise Edition, which costs $199.00 USD for one license or $159.00 USD for a non-commercial license.

  • Previous
    IBM Cognos Business Intelligence
    Next

    IBM Cognos Business Intelligence

    Far more than a reporting tool, IBM Cognos Business Intelligence is a web-based, integrated business intelligence suite by IBM. The software consists of several components, including Cognos Connection Query Studio, Report Studio, Analysis Studio, and Event Studio.


    Report Studio is the report creator.  It offers two different authoring modes: professional and express.


    Professional authoring mode enables access to the full range of Report Studio functionality for creating any type of report, including charts, maps, lists, and repeat functions.


    The express authoring mode has a more simplified user interface, designed for non-technical users. It enables them to create traditional financial or management reports within a more streamlined user interface.


    One IBM Cognos Express Business Intelligence User License, including Software Subscription and Support for 12 Months costs $637.00 USD.

  • Previous
    JReport
    Next

    JReport

    The Jinfonet company is highly regarded in the realm of embeddable reporting and data visualisation.  Their JReport offering is a commercial Java reporting solution that provides sophisticated enterprise reporting, ad hoc reporting, and data analysis. A 100% Java EE architecture and set of APIs allow JReport to be embedded into an application, providing end users with a GUI interface to generate reports, share information, and analyze data. Moreover, a report can be made interactive, extending its usability by allowing users to sort, group, navigate, and filter via the Web.

  • Previous
    QlikView
    Next

    QlikView

    This product by Qlik offers the best of both words: a free personal edition as well as professional grade Business Intelligence tools.  As part of a suite of business intelligence products, QlikView helps to visually represent how data is associated. Users can conduct searches across all data anywhere in the database, either globally or within a specific column.  Clicking a data point in a field instantaneously filters other fields based on the selection.


    QlikView‘s search engine employs an in-memory architecture, which has the advantage of better performance than traditional disk-based and query-based BI tools. QlikView loads all of the data into RAM memory and makes it available so that both fast associative searches and real-time analyses are possible.

  • Previous
    Report Manager
    Next

    Report Manager

    If free is what you’re looking for, then Report Manager might just be the tool for you.  It’s made by the ReportMan company in Girona, SPAIN, near Barcelona.  Report Manager features a graphical Report Manager Designer and a set of libraries and utilities to preview, export or print reports. It includes native .Net and Delphi/C++Builder libraries, ActiveX components, and also a standard dynamic link library for use in languages like GNU C.


    Report Manager is offered under the MPL open source license model. You can use it in your commercial software but any enhancements to the engine must be published.  Email help support may be purchased based on the amount of hours.

  • Previous
    DataVision
    Next

    DataVision

    If you like the look and feel of Crystal Reports, but don’t have the budget for it, DataVision offers an open source equivalent. Reports can be designed using a drag-and-drop GUI. They may be run, viewed, and printed from the application or exported as HTML, XML, PDF, Excel, LaTeX2e, DocBook, or delimited text files.  The output files produced by LaTeX2e and DocBook can in turn be used to produce PDF, text, HTML, PostScript, and more.


    DataVision is written in Java and runs on any platform. It can generate reports from any database with an available JDBC driver, including Oracle, PostgreSQL, MySQL, Informix, hsqldb, Microsoft Access, Progress, and others. Unlike many competing products, DataVision can produce reports from text data files. Columns read from text files can be separated by any character.


    See all articles by Rob Gravelle

Most businesses and governmental agencies require regular and ad hoc reports on stored data.  Upper management bases policy and strategy decisions on reports while various departments such as marketing will adjust their efforts in response to information gleaned through reports.

There are a number of free and commercial reporting products available for MySQL.  Some generate canned reports while others offer entire Business Intelligence solutions.  Here are a few choice offerings, in no particular order.



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.