http://forums.mysql.com/read.php?33,41056,61281#msg-61281

If by “analytic” you mean OLAP, data mining etc: there are a number of options.

OLAP servers:

* Mondrian: Java OLAP engine that uses most DBMSs, including MySQL
* Palo: spreadsheet server. Custom data source, Excel and PHP integrations
* Lemur: C++ OLAP server – academic

OLAP UIs

* JPivot: Web OLAP UI integrating with Mondrian and XML/A (Microsoft Analysis Services, Hyperion). JSP tags + portlets
* JRubik: Java thick client for Mondrian – based on JPivot
* pocOLAP: crosstab Web UI

Data mining, statistics

* Weka
* Project R

Reporting servers

* BIRT
* JasperReports Portal: JasperReports in JBoss Portal
* OpenReports: JasperReports based web application
* marvelIT: OpenReports in a portal

BI servers: Reporting and Analytics

* Pentaho
* SpagoBI
* OpenI
* Bizgres

ETL – to build data warehouses and operational data stores

* Octopus
* KETL – part of Bizgres
* Kettle
* CloverETL
* dbmt