Clarifying server setup for Pentaho BI stack

I am investigating a solution for very rich reporting on financial data across multiple subsidiaries.  

We will export a CSV from each financial system and import it to a relational DB, probably MySql.

From there, I want to get to Pentaho Analyzer.  I believe I need Mondrian sitting between the relational DB and Analyzer.  Right?  Is there any other piece needed in that stack ... not counting the J2EE server and any other pieces that will install with Pentaho?

Thanks!
LVL 32
Daniel WilsonAsked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Author Commented:
Kettle would be the piece recommended to bring data from Mysql to Mondrian.  Pentaho Analyzer looks like a great tool for a large enterprise.  It's beyond my customer's budget ... so ... I'm looking at Saiku.
0
 
Daniel WilsonAuthor Commented:
I'm providing and accepting the answer since I talked with someone from Pentaho.  Great pre-sale service, btw.  Hoping the answer helps someone else.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.