PDI/Kettle Solution Share (Presented at #PCMD15)

This has been presented at the German Pentaho Community Meeting 2015 (#PCMD15):

Before you share a PDI solution with the community, clients etc. you probably want to ensure that it does not contain any security related information you do not want to share.

There are many information within transformations and jobs that you may not want to expose to others like: hostnames, usernames, creator information, server names, file paths etc.

Use the PDI/Kettle Solution Share (explained on the Pentaho Wiki) to remove these unwanted (secure & private) information in your Kettle/PDI jobs and transformations.

It is using the XSL Transformation job entry by modifying the jobs and transformations stored in XML.

solution_share_job1

It is looping via all files and replacing the shown variables:

solution_share_job2

It should also encourage you to share your solution with others, e.g. via the Kettle Exchange on the Pentaho Wiki.

This works for multiple files es well for a repository export.

Here is the how to (see the latest version on the Pentaho Wiki for any changes):

  1. Download the solution_share.zip (attached to PDI/Kettle Solution Share), unzip it to a folder of your choice
  2. Open solution_share_main.kjb from Spoon
  3. Execute it with the test files within the solution_share/share folder
  4. A new folder solution_share/share_date_time (e.g. share_public_2015-02-08_22-06-27) has been created with the cleaned files
  5. You may want to compare the files if they do not contain any private information like connections, user names etc.
  6. Put your files to share into the ./share folder instead the sample files (you can also modify the default location by changing the parameter within solution_share.ktr)

If you want to add and/or modify the elements that are removed from your solution, you can do so by editing the XSL Transformation: share_remove.xsl

share_remove_xsl

Please see the complete share_remove.xsl within the on PDI/Kettle Solution Share.

Über Jens Bleuel

Have a look at my XING Profil: https://www.xing.com/profile/Jens_Bleuel2
Dieser Eintrag wurde veröffentlicht in Kettle (PDI). Fügen Sie den permalink zu Ihren Favoriten hinzu.