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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

slideshows

Posted June 11, 2018

Top Reporting Tools for MySQL in 2018

By Rob Gravelle

  • Previous
    Top Reporting Tools for MySQL in 2018
    Next

    Top Reporting Tools for MySQL in 2018

  • Previous
    SeekTable
    Next

    SeekTable

    SeekTable is an online ad-hoc reporting web tool that supports pivot tables and pivot charts. The company behind SeekTable.com is located in Kyiv, Ukraine. The SeekTable service is maintained by the same team that supports NReco Components. They've been in business long enough that you can be sure that SeekTable will not suddenly vanish. Although your data is only ever used to build visualizations and reports requested by you, a web-based service may not be the best choice for very sensitive data.

    Data can come from a variety of sources, including CSV,TSV, and Excel files, as well as a number of databases, including MySQL (Amazon Aurora), SQL Server (Azure SQL), PostgreSql (Amazon Redshift, PipelineDB), Yandex ClickHouse (binary protocol), MongoDb (Azure Cosmos DB), ElasticSearch, and just about any other DBMS that has a compatible ODBC driver.

  • Previous
    WideStage Open Source Reports
    Next

    WideStage Open Source Reports

    Here we have a lightweight self service reporting tool that's powered by NodeJS. It uses Semantic so that your users can query data using business terms instead of SQL. It also supports SQL Server, Oracle, and Google BigQuery.

    In addition to NodeJS, WideStage Open Source Reports also requires that npm, Bower, and MongoDB be installed on your system. MongoDB is used to store the widestage metadata, so you have to install it even if your data is stored in MySQL. Once everything is installed, you can launch the application by typing "node server.js" at the command prompt. Then point your browser to your ip/server name and enter your credentials to access your reports.

  • Previous
    Quadbase
    Next

    Quadbase

    Quadbase Systems, Inc. has focused on leading edge Java technologies for Web-enabled data reporting, visualization, and dashboard presentations since 1997. Their reporting products are EspressReport and EspressReport ES.

    EspressReport is a Java report development toolkit designed for business intelligence and operational reporting. It offers a powerful, easy-to-use report writer/report engine.

    The ES in EspressReport ES stands for Enterprise Server. It provides a powerful, centralized enterprise reporting architecture that leverages the functionality of EspressReport's pure Java reporting engine and extends it to enterprise-level functionality.

  • Previous
    PHP-Reports
    Next

    PHP-Reports

    If you're a web developer like me, you'll appreciate a language that lets you integrate reporting into your websites. PHP is one of my preferred programming languages, so PHP-Reports is an obvious choice for me. Developed by Murat Çileli, PHP-Reports is a cloud based, interactive report engine for generating neatly formatted PDF reports from Word (.docx) templates. The name is a bit of a misnomer, because PHP-Reports also supports ASP.NET, ASP.NET MVC, WPF, Silverlight, WinRT, HTML5, Windows Forms, Java, Python, Objective-C, Swift, Delphi and other languages as well.

    Here's a code sample:

    $pr = new PHPReports('f9nb3k8bzfumne6g6yu6fu4d');
    $pr->setTemplateId(2);
    $pr->setOutputFileType(PHPReports::OUTPUT_PDF);
    $pr->setOutputAction(PHPReports::ACTION_GET_DOWNLOAD_URL);
    $pr->setOutputFileName('My_Generated_Report.pdf');
    $pr->setTemplateVariables(
        array(
            'client_name'   => 'Armut Inc.',
            'email_address' => 'murat.cileli@gmail.com',
            'products'      => array('Computer', 'Smart Phone', 'Book')
        ));
    $pr->generateReport();
    
  • Previous
    Datapine MySQL Reporting Tools
    Next

    Datapine MySQL Reporting Tools

    Datapine was founded in 2012 with the idea to facilitate the complex process of data analytics through technical innovation. After four years in business, they had acquired thousands of users in more than 25 countries around the globe.

    All you need to do to set up datapine is connect your SQL database(s), such as MySQL, PostgreSQL, MS SQL Server or Oracle, which takes under 10 minutes. After setup is complete, you're ready to start carrying out your MySQL queries and generating custom reports.

    The tools include a MySQL query builder, MySQL report builder, business intelligence software, dashboard builder, and more.

    Although the service costs money, they do offer a free trial so that you can get a feel for the product.

  • Previous
    Ubiq
    Next

    Ubiq

    Ubiq is a web-based reporting tool that supports a wide variety of databases, including MySQL, PostgreSQL, Amazon RDS, Amazon Redshift, and others. Ubiq lets you quickly build interactive dashboards and reports using a drag & drop interface. No uploading of data or programming is required. Results are presented in visually stunning online dashboards and reports that may be exported in multiple formats as well as securely shared with others.

    Subscriptions are purchased on a monthly basis. Prices range from $18 per month for a single user (3 dashboards), $45 per month for three users (10 dashboards), to $75 per month for five users (15 dashboards). Custom plans may also be purchased for other group sizes. All plans are available via a free trial in order to determine which plan is best suited to your requirements.

  • Previous
    Smart Report Maker
    Next

    Smart Report Maker

    Smart Report Maker is a popular PHP report builder for MySQL by StarSoft Software, an online software development company with a focus on the open source Internet development market. It's one of several products in their roster, which also includes Smart Form Maker, Smart Chart Maker, and Smart Pivot Table.

    Smart Report Maker allows the creation of PHP auto-update reports for any MySQL database without writing any SQL or programming code. Users can design reports visually with an easy-to-use wizard specifically designed for speed.

    A single license for Smart Report Maker is available from mysqlreports.com for $48 USD. That allows you to install Smart Report Maker in 5 domains. There is an online demo that you can try for evaluation purposes. Bundle licenses are available as well. For instance, you can purchase Smart Report Maker, Smart Chart Maker, Smart Form Maker, and Smart Pivot Table for $135 USD during a limited time sale. (Normally it's $192)

  • Previous
    dbForge Studio for MySQL
    Next

    dbForge Studio for MySQL

    Sometimes, reporting is one component within a larger software package. Case in point, dbForge Studio for MySQL is a GUI tool for managing, developing and administrating MySQL and MariaDB databases that features a MySQL Data Reporting and Analysis Tool. It allows users to design a variety of report types with parameters, customizable formatting, calculated summaries, and more. In addition, the Master-Detail Browser allows users to view and analyze related data all together in a comprehensive way.

    It also offers a Pivot Table tool for converting large amounts of data into compact and informative summaries. You can rearrange (or pivot) your data using drag & drop until you get the best layout for understanding the data relationships and dependencies.

    dbForge Studio for MySQL comes in three editions: Standard Edition, Professional Edition, and Enterprise Edition. Prices for single licenses are $149.95, $299.95, $399.95 respectively, with discounts available for multiple licenses.

Back in 2015, I presented a slideshow of the Top 10 MySQL Reporting Tools. Since then, many readers shared their own favorite reporting tools for MySQL. Moreover, the reporting landscape has changed in the past three years. These two developments have informed me that this might just be the right time to revisit this topic. So now, for your viewing pleasure, here are another 8 of the Top Reporting Tools for MySQL.

See all articles by Rob Gravelle



Comment and Contribute

 


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