Pentaho 4.5 – Tools Update

If you followed the articles about installing Pentaho (CE) applications in this blog, now is the opportunity to upgrade them as the have been posted on sourceforge on Monday (5/7/2012) with these quick instructions.

Part I

You need to go to http://sourceforge.net/projects/pentaho/files/ for your tar.gz or zip files.

Update PDI – Data Integration (ETL)

1. Rename your folder to ‘data-integration-old
2. Download pdi-ce-4.3.0-stable.tar.gz
3. Unpack its content ‘data-integration’ into Pentaho folder
4. Copy your ‘development’ folder from the older directory
5. Optional plugins: Copy two folders /Pentaho/data-integration-old/plugins/spoon : DataCleaner and kettle-profiling-datacleaner to your new directory.
6. Copy your database drivers (Oracle, Mysql, etc) from /Pentaho/data-integration/libext/JDBC
7. Clean the cache: Tools->Database->Clear cache.

Be carefull I couldn’t save a transformation after an error, and an warning about saving was generated after a timeout from a database. That happened to Kettle a few versions before (2.5) I think but I will keep using this and previus versions for a while.

Update PRD – Report Designer

1. Rename your folder to ‘report-designer–old’
2. Download prd-ce-3.9.0-GA.tar.gz
3. Unpack its content ‘report-designer’ into Pentaho folder
4. Copy your ‘development’ folder from the older directory
5. Copy your database drivers (Oracle, etc) from /Pentaho/report-designer/lib/jdbc
6. [Edit]
   If you use a Pentaho data Integration as a Data Source, you might get the following error when the preview button is used:
   org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Caught Kettle Exception: Check your configuration
   The easy way to avoid it is to copy the files from Kettle:
   /Pentaho/data-integration/libext/JDBC/
   into your PRD:
   /Pentaho/report-designer/lib/jdbc/
   

Update PME – Metadata Editor

1. Rename your folder to ‘metadata-editor–old’
2. Download pme-ce-4.5.0-stable.tar.gz
3. Unpack its content ‘metadata-editor’ into Pentaho folder
4. Copy mdr.btd and mdr.btx from the older directory

Part II

Now go to http://sourceforge.net/projects/mondrian/files/

Update  PSW – Schema Workbench

1. Rename your folder to ‘schema-workbench–old’
2. Download psw-ce-3.4.1.1.tar.gz
3. Unpack its content ‘schema-workbench’ into Pentaho folder
4. Copy your ‘development’ folder from the older directory
5. Copy your database drivers (Oracle, MySql, etc) from /Pentaho/schema-workbench/drivers

Update  PAD – Aggregation Designer

1. Rename your folder to ‘aggregation-designer–old’
2. Download pad-ce-1.4.0-stable.tar.gz
3. Unpack its content ‘aggregation-designer’ into Pentaho folder
4. Copy .databaseMetaInfo and .schemaInfo from the older directory
   (In a the nautilus file browser remember to check the option show hidden files)
5. Copy your ‘development’ folder from the older directory
6. Open the app. Close the wizzard if it appears. Then in the menu File->Open and search for pad_workspace in your development folder to restore your work.

Notes

Now only the BI Server and the Studio Designer needs to be upgraded. I will edit this for the BI server as it is a bit complcated. The Design Studio hasn’t been posted yet.

Keep both folther the new and -old for a while. When you feel confident about your new software then erase the -old directories.

Advertisement