09-11-2018, 12:12 PM
Pentaho is a complete Business Intelligence stack. It will take you from raw data to complete statistics passing through reporting and analysis. Incredible, but mostly useless. There are only a handful of companies out there prepared for this kind of BI.
What I did was use their ETL tool, PDI, to create a data warehouse from a coreBOS database, Once you have the data warehouse you can start reporting and analyzing on it. Instead of using Pentaho tools for that I use metabase, because it is much easier to understand, much more user-friendly. It doesn't do the whole stack like Pentaho does but it does very well what most companies do need.
The thing is that with this approach you still need a separate database for the warehouse and sync information regularly while having some other downsides so I thought of another approach based on views which I would like to try.
HTH
What I did was use their ETL tool, PDI, to create a data warehouse from a coreBOS database, Once you have the data warehouse you can start reporting and analyzing on it. Instead of using Pentaho tools for that I use metabase, because it is much easier to understand, much more user-friendly. It doesn't do the whole stack like Pentaho does but it does very well what most companies do need.
The thing is that with this approach you still need a separate database for the warehouse and sync information regularly while having some other downsides so I thought of another approach based on views which I would like to try.
HTH
Joe
TSolucio
TSolucio