Which open source dashboard/BI tools can work with monetDB?

Question

I'm trying to create a rich online dashboard to analyze web traffic with monetDB. Does anybody know how to integrate with an open source solution ?

Answer 1

I would recommend to use:

• DWH: MonetDB
• ETL: PDI (Pentaho Data Integration)
• OLAP: Mondrian OLAP (OLAP schema workbench tool)
• Dashboards: Pentaho BI Server CE (CDF: charts portfolio CCC + maps, etc.)

For a quick start:

1. Fill you DWH (MonetDB) with sample data (One fact table, few dimensions)
2. Create OLAP schema in on the top of the DWH tables using "OLAP schema workbench" tool
3. On Pentaho BI Server CE:
   • Add data sources - DWH connection, OLAP schema
   • Create dashboards (according to samples on BI Server)