Business Intelligence reporting with mySql [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_Go百科

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 6 years ago.

Improve this question

Are there any good open source projects for Business Intelligence reporting in mySql or is there a commercial option that is not too expensive? Am in a 5 man shop so spending a lot of $$$ is not an easy option

---

Pentaho is a good option... http://www.pentaho.com/

It's opensource, I have a friend that sells BI and use this solution to delivery and he likes it a lot

There is also JasperSoft but I didn't heard anything about it http://www.jaspersoft.com/

---

You might as well have a look to icCube; there's a community edition that might be enough for your needs; otherwise the enterprise edition are quite affordable compared to the major actors of the market.

---

Then you have InfoBright which is a MySQL fork. They have their own columnar oriented storage engine which is optimized for BI/DW type of queries. Having the same SQL syntax and index free tables it could be an interesting choice for a MySQL shop. There is a crippled community version free of charge.

---

There is Eclipse-plugin based, BIRT. We have just started using it and so far it seems good. We are using the community edition and my knowledge on other versions is limited. Otherwise, Pentaho is a great option.

---

I'm going to confirm the Pentaho Choice. There's a Pentaho Business Suite that you can buy, but you are free to get all the tools for free.

I use Pentaho Data Integration to data pump raw data from our database in France, all the way to mauritius in Africa. PDI handles the file transfer with ssh then performs the loading with all the business logic in it and finally remove files that have been loaded successfully from the production server.

I've tried a bit the reporting tool it's a very complete product.

All it takes is time and effort to learn. The community online is very active and the developers answer on the forum Directly (I know the PDI project leader does)