View Full Version : Encrypt PDI passwords

01-29-2010, 10:19 PM
PDI has a basic obfuscation method for making it difficult for casual people to lift passwords for DB connections. I have customers that maintain different versions of a “shared.xml” file that maintain different physical connections to databases (think development, QA/testing, and production).

In order to generate the different shared.xml, a user has to usually (per Matt Casters comment below there is a utility that allows user to do this outside of Spoon) open up PDI, created the connections, save them, and then sometimes copy and paste the sections needed to create their “dev” version of shared.xml or their “production” version of shared.xml. Many times this just to generate the password, as they can hand edit the other pieces (hostname, schema, etc).

I just committed a quick little PDI transformation (http://source.pentaho.org/svnkettleroot/Kettle/trunk/samples/transformations/Encrypt%20Password.ktr) that gives you the PDI encrypted form of a password.

http://www.nicholasgoodman.com/bt/blog/wp-content/uploads/2010/01/201001291332-tm.jpg (http://www.nicholasgoodman.com/bt/blog/wp-content/uploads/2010/01/201001291332.jpg)

Happy Password Encrypting!

More... (http://www.nicholasgoodman.com/bt/blog/2010/01/29/encrypt-pdi-passwords/)