1

I want to encrypt files using PGP in Pentaho. I have a Java program to encrypt the file through command line. Kettle recommends to encrypt row by row using user defined call, Is there a way to encrypt whole file as such using kettle user defined class? I am new to kettle.

jacktrade
  • 3,125
  • 2
  • 36
  • 50
Ganesh
  • 1,654
  • 2
  • 19
  • 32

3 Answers3

2

I'm not sure about your requirement. but you can develop kettle plugin

http://type-exit.org/adventures-with-open-source-bi/2010/06/developing-a-custom-kettle-plugin-a-simple-transformation-step/

In the plugin just pass filename to method Runtime.exec() to encrypt your file.

Peerapat A
  • 420
  • 4
  • 13
2

Yes you can. Create a new Kettle Job, add your file transformation to the flow job, now use the Encrypt files with PGP Step.

jacktrade
  • 3,125
  • 2
  • 36
  • 50
  • I tried that using gpg2.exe, but it says could not find public key even after importing the key.... Can you explain this part? – Ganesh Dec 22 '13 at 04:10
  • sorry i do not use windows os. i only use kettle on Linux – jacktrade Dec 22 '13 at 21:14
  • Hi... Can you explain how to use in Linux, the configuration I had to provide, we will be finally using this in a LINUX machine – Ganesh Dec 22 '13 at 23:25
  • Hi... Can you explain how to use in Linux, the configuration I had to provide, we will be finally using this in a LINUX machine – Ganesh Dec 30 '13 at 01:16
  • You can use GnuPG to generate a key. then use the kettle job to encrypt file within this key. -> https://www.gnupg.org/gph/en/manual/c14.html – jacktrade Sep 21 '18 at 06:41
0

You can do this at job level. you have a step called Encrypt PGP files. This has to be used at job level. Hope I have answered your question.

Dileep_Kettle
  • 1
  • 2