Migrate a fully developed Hyperion Platform to Pentaho

Task:

Migrate a fully developed Hyperion Reporting platform to Pentaho. The Platform consists of about 200 fully developed reports.

Technologies used:

  • MySQL
  • Pentaho Data Integration (PDI)
  • Pentaho Report Designer (PRD)
  • Pentaho Schema Workbench (PSW)/OLAP
  • Bash Scripting

Report:

the main issue here was that the business guru who has developed the reports in the first place was not in the company any more. With the help of the customers IT- and business users we were able to reverse-engineer all of the reports. Now the Pentaho platform is still up and running and heavily used. I am still doing a lot of supportive work there.

Lessons learned:

Never underestimate the creativity of a business user

What the customer says