Mysql · Reporting platforms

any recommendations for mySQL reporting tools?

michael madison founder, ceo and menu-guru at menumodo

February 3rd, 2016

we need to produce Excel-style reports (i.e. no graphs or chats at this stage) on a regular basis for multiple customers.
The report is populated with information from mySQL.
The reports have been custom-built by our developer, and any change are time consuming.

I wonder whether there is an efficient tool with a non-technical GUI that would allow us to build, run, schedule, etc. reports.

Lee Guertin Editorial Research Manager, Online Analytics

February 3rd, 2016

If you have Microsoft Office/Office 365 (which I'm assuming yes since you are using/considering Excel) then try their PowerBI tool. Their "Pro" version will allow you to schedule and publish reports that query databases like MySQL at a low cost, essentially using the Azure cloud services to manage it. $9.95/mo is pretty reasonable. Most of it uses a drag and drop or graphical type of UI as well. Hope this helps. Good luck!

Lee Guertin Editorial Research Manager, Online Analytics

February 3rd, 2016

I'm in the middle of a licensing negotiation with Tableau right now. It isn't for the faint of heart or for a small budget. You'd need a server license, desktop professional license, and annual maintenance licenses just to even get started. More if you would need to support enterprise level operations or multiple report developers.

Amit Gulati Technical Lead at TuneCore

February 3rd, 2016

We use QlikView at my organization. You can use the tool to graphically generate reports and it has a built in web server to provide role based access to report dashboards as well. Scheduling reports is available as well. Keep in mind, though, that the value you can get from a gui tool is heavily dependent on the structure of your data. If your scheme was not designed with some regard to reporting needs, there will only be so much you can do without at least some SQL work. You may still require some initial investment into creating additional views or aggregations in order to get the full value of a BI tool. But it shouldn't be long before you see a return on the investment. You have the flexibility to import your own custom SQL as well so you can start taking advantage of the other features immediately using your current queries.

Joanan Hernandez CEO & Founder at Mollejuo

February 5th, 2016

If you have already the queries written and all you need is to get the result of those queries out, maybe MySQL workbench is just what you need.

Workbench is free to download and use (it's from MySql itself). The biggest challenge will be to set up the MySql connection. Once connected, you just go to the DB and do the query, you can then export these results to Excel from WorkBench itself.

Warning: If you do follow this route of using MySQl Workbench, be sure to connect to it with a limited privileges user, in order to not to do any damages. WorkBench is a MySQL DB tool. It can do everything from queries to delete entire DBs or tables, so be careful. Thus the way to avoid these damages is to create a user that can't to these type of damages.

Cheers!

Aleksey Malyshev Software Engineer at iTouch Biometrics, LLC

February 3rd, 2016

You need to provide a little bit more information about it. Will they see it on a desktop or a web browser? Or maybe you want to send an e-mail report? How far are your customers from the database? If they access it remotely, security is an important consideration.

One of those tools that I know is Microsoft Access.

Lee Guertin Editorial Research Manager, Online Analytics

February 3rd, 2016

Microsoft Access is another DB platform tool and DB type, not really a reporting platform or a report delivery tool. I wouldn't use it to import data from MySQL since it would basically be just transferring data from one DB into another DB that would then process data to enable the limited reporting UI, which is more effort intensive than it seemed this person was looking for...

Shobhit Verma

February 3rd, 2016

http://www.tableau.com/ is probably too much ?

Aleksey Malyshev Software Engineer at iTouch Biometrics, LLC

February 3rd, 2016

Access is not just a DB platform, it is also a nice UI building tool, that you can connect to many databases and build a desktop UI. I have not used it for a while. Maybe Microsoft added more features recently.

Lee Guertin Editorial Research Manager, Online Analytics

February 3rd, 2016

I realize that I was a little harsh on Access -- I should clarify that you *can* do reporting within MS Access. And you can export to Excel format. You can do that with other tools as well, but most people i have worked with find it less than intuitive and not as sophisticated as other tools on the market. Especially if any charts or visualizations like we have now in Excel are desired. I think it is part of why MS Office has been working on PowerBI as a reporting platform. I'm working with Tableau, Access, Excel, and PowerBI at the moment. Hope this helps!

Matthew Excell Lead Architect and Technology Strategy Consultant at Watchman Technologies, L.L.C.

February 3rd, 2016

JasperServer will do everything you mentioned (though the post was a touch light on details) and quite a bit more. Web, pdf, Excel and other office exports, etc. Easy to use for anyone who can write sql queries - there is an almost wysiwyg editor (Jaspersoft Studio) for the reports and a raft of documentation for it. The community edition is free or they have paid editions with additional features like adhoc reporting. No, I don't represent them - but several of my startups and clients have used the evolving products to great effect over the last 15 years.