News for hackers. Stuff that matters.
Re:IT job satisfaction plummets to all-time low by tom_b on Thursday January 07, 2010 @01:55PM (#1037733)
Believe it or not, Pentaho is what we have in place right now. For the ETL backend, I think it is a really nice tool. Flexible, intuitive, and measures up well to Informatica and other $$$ tools.

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).

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.
Re:IT job satisfaction plummets to all-time low by tom_b on Wednesday January 13, 2010 @10:36PM (#1051847)
Caught this question only after a few days, sorry for the delay. We actually are using Oracle (we have a site license).