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 ?
Asked
Active
Viewed 591 times
1 Answers
2
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:
- Fill you DWH (MonetDB) with sample data (One fact table, few dimensions)
- Create OLAP schema in on the top of the DWH tables using "OLAP schema workbench" tool
- On Pentaho BI Server CE:
- Add data sources - DWH connection, OLAP schema
- Create dashboards (according to samples on BI Server)

mzy
- 1,754
- 2
- 20
- 36
-
Yes, that was what i tried but i got an error, i'll try again. Thanks a lot for the quick start :) – GBrian Jan 21 '15 at 20:45
-
What issue have you been facing? MonetDB connection? Have you already solved it? – mzy Jan 23 '15 at 10:39