1

I have some csv's containing the sale transactions. The file is come from another department in another state and it's encrypted for security reason. It's encrypted using Rijndael-128 mode CBC encryption.

I need to decrypt the file before make a report about it. How do that using pentaho? I know pentaho provide GPG encrypt and decrypt steps but my requirement is use that Rijndael encryption.

Rio Odestila
  • 125
  • 2
  • 19
  • 1
    Hi, If you can implement decrypt logic using java or javascript then you can load content of file in memory using "Load file content in memory" step and then apply decrypt logic on it. – Niraj Sep 22 '18 at 04:24

1 Answers1

0

Using the user java class step allows you to implement your own java code and decrypt the file from this step.

https://wiki.pentaho.com/display/EAI/User+Defined+Java+Class

jacktrade
  • 3,125
  • 2
  • 36
  • 50
  • how about Symmetric Cryptography step? Rijndael is like AES encrypt or not? – Rio Odestila Oct 15 '18 at 03:18
  • AES has a fixed block size of 128 bits and a key size of 128, 192, or 256 bits, whereas Rijndael can be specified with block and key sizes in any multiple of 32 bits, with a minimum of 128 bits and a maximum of 256 bits. https://stackoverflow.com/questions/748622/differences-between-rijndael-and-aes#748645 – jacktrade Oct 15 '18 at 09:58