Find solution
How to generate reports?

What tools are available to automatically generate reports from an SQL database?

  • In particular, I'm interested in packages that will compute reports (by which I mostly mean time-based aggregations) and return them in a serialised format; I have no need for a display layer. Sure you can write SQL to do this for you, but if your data is in a schema that doesn't suit reporting well there is work to be done to pre-compute reports, materialise intermediate tables, and in a such a way as to make adding new reports easy. That's the heavy lifting I'd hope such a package would do for me.

  • Answer:

    Here's a general and a specific answer. First the general - go to http://www.reportingsoftware.info to get an intro to all the available reporting systems out there. That will give you a good starting point. Now the specific. Please take a look at http://www.windward.net which is, I think, the best reporting system out there by far (disclaimer, I'm the CTO there).

David Thielen at Quora Visit the source

Was this solution helpful to you?

Other answers

We recently launched the Vero Designer to specifically address this need. It can write really complex sql queries depending on your needs.  Having been in the analytics industry for the last 10 years we are seeing a growing need for use cases like yours.  Which is the need for a data prep/query layer thats separate from visualizations.  You are not alone :).Please do check us out at https://www.veroanalytics.com .  I would love to give you an unbiased list of alternatives, but I haven't seen any solution that is standalone like ours and can generate the necessary sql queries.  However, here are a few similar tools that you may have varying success with (the tools get more complex as you go down):Data Preparation Tools ( No SQL Generation layer as far as I know): http://www.paxata.com http://Trifacta.com http://Alteryx.com Business Intelligence Tools ( Has great SQL generation capabilities, but they are full stack solutions and likely overkill for your needs): http://go.sap.com/solution/platform-technology/business-intelligence.html http://www.microstrategy.com http://www.oracle.com/us/solutions/business-analytics/business-intelligence/enterprise-edition/overview/index.html Extract Load and Transform Tools (ETL - these can be quite complex) http://Talend.com http://www.informatica.com http://www.cloveretl.com Hope this is helpful.  Feel free to contact me directly if you wanted more information on these tools or http://www.veroanalytics.com.

Ajo Abraham

You can try out Ubiq (http://ubiq.co ). It is a web based MySQL reporting tool. It has built-in functions for time based aggregations like year, quarter, month, etc. You can apply them using a drag & drop interface. Also it has the ability to apply joins & filters. This should help you get the required data even if your schema doesn't suit reporting. Here's a sample report.

Sreeram Sreenivasan

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.