Re:IT job satisfaction plummets to all-time low
by smokinn on Friday January 08, 2010 @10:33AM
(#1039701)
What database did you plug Pentaho into? Like I said earlier I was thinking of using LucidDB but according to this benchmark: http://www.mysqlperformanceblog.com/2010/01/07/star-schema-b... it seems InfiniDB might be a better candidate.
But the reporting model, with the designer/xaction dev/publish quirkiness just bugs me. I find myself editing the XML definition files when I want to change stuff rather than firing up the tools. The documentation is a little lacking as well, but I have demanding standards there.
I also don't particularly care for how business models show up in the GUI for user-driven report building. To be fair, that is probably somewhat related to a poor model without proper dimensional design put in place. First pass efforts (before my time here) basically copied the operational system schemas into the data warehouse (shudder).