Looking for a good BI product to report on MySQL Data.

[mparak]

Dear Friends,

I work in Delphi and manage Really LARGE databases in MySQL.
We normally write all the slice and dice, OLAP cubes and analytics using Delphi but it seems that there are a host of specialist application frameworks designed to do the heavy lifting and fancy views for the developer. I have seem Oracle Application Developer Framework in action and I most say it was "sweet".
We are in the marketplace to choose a product that works well with MySQL but need to find something that leverage the Delphi knowledge that we have.
While the MySQL site recommends the Pentaho Suite, amongst others, I was just wondering what other developers with similar skills have chosen.
We would greatly appreciate your ideas and input.

Basic requirements are.
Ease of use and setup.
Automatic and fast Aggregation of Data.
Web Interface. Developer and End user.
Template based design.
User enabled "what if" scenarios.
etc..

I look forward to hearing from all my peers on this matter.

Warmest Regards

[hsanchez]

Hi.

Take a look at http://www.pentaho.com

Hernán

[mparak]

Hi Hernan,

Tried it in the past and while it seems a likely candidate, the setup and general steep learning curve to get productive seems intimidating.

Regards
M

[mparak]

DevExpress DBPivotGrid.
Check it out.
All the glitz, really expensive, but worth every cent.