CoreBOSBB
How does our metabase integration work? - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: How does our metabase integration work? (/showthread.php?tid=1255)



How does our metabase integration work? - Guido1982 - 09-10-2018

I see we have an integration for metabase, but can't really find how we integrated it. Could someone elaborate on this?


RE: How does our metabase integration work? - joebordes - 09-10-2018

The current integration is based on ETL to a data warehouse using Pentaho PDI. When I finished that work I thought that it would be better to do it using views and I am waiting for someone to fund that approach. Look for me and we can discuss the pros, cons, and options.


RE: How does our metabase integration work? - Guido1982 - 09-10-2018

Sorry, you have to walk me through some things, just watching a Pentaho video now but this raises a lot of questions about what this actually is. Is it a reporting client that we can connect to the database? And metabase is about the same thing?


RE: How does our metabase integration work? - joebordes - 09-11-2018

You don't need to learn PDI. I have a better solution.


RE: How does our metabase integration work? - Guido1982 - 09-11-2018

I will look for you in gitter, or we can do a hangout. Just need to understand the terminology, I'm sure when you know that, it can't be too difficult.


RE: How does our metabase integration work? - joebordes - 09-11-2018

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


RE: How does our metabase integration work? - Guido1982 - 09-11-2018

Yes, my approach would always be to keep the central CB database and only create views into that database. Building a second dependant DB is a recipe for problems / a lot of work I think.