Decryt Data

[manodwh.b]

Hi,

Can some one help with how to decrypt a filed with AES/CBC/PKCS5Padding algorithm in PDI/Spoon?

[manodwh.b]

Can some one help with how to decrypt a filed with AES/CBC/PKCS5Padding algorithm in PDI?

Thanks,
Mano

[Sparkles]

I suggest putting the required jars in lib folder, then find a java tutorial and apply that in a java user defined class step.

[manodwh.b]

could you please let me know what are the jars required for decrypt data with AES/CBC/PKCS5Padding algorithm?

[Sparkles]

could you please let me know what are the jars required for decrypt data with AES/CBC/PKCS5Padding algorithm?

I have no idea sorry, the topic is general java, not pentaho kettle specific. I suggest you go looking on the internet.

[gutlez]

According to https://github.com/pentaho/pentaho-k...yptoTrans.java

PDI is not built to prepare the IV parameter that is needed to do AES/CBC/PKCS5Padding decryption.
The JARs should already be in place, since the Symmetric Cryptography step uses them.

You should file a request at jira.pentaho.com to enhance this step.

[Sparkles]

If you can do it in java, you can do it in spoon. You would have better luck searching for a java solution, then implement it by putting the jars in the lib folder and the code that uses the library in the java user defined class step.

[manodwh.b]

Hi acbonnemaison, could you please let me know the solution for this,since i got same senario? Thanks in Advance!! Manohar

[Sparkles]

Hi acbonnemaison, could you please let me know the solution for this,since i got same senario? Thanks in Advance!! Manohar

Aanything you can do in java you can you do in spoon. If I was to do your task, I would have to google some java tutorial, example or documentation. That would probably include some jars, which, if you want to include it in a kettle project, you must put in the lib folder. After that, you can create your own code inspired by the documentation/tutorial/example mentioned earlier. This can be put in a User Defined Java Class step. You can find great tutorials for it online too. If there's anything specific you don't understand with UDJC, I suggest you come back here and ask.

[saidlp13]

Create a java class with appropriate functions and place them in pentaho lib folder and call them in transformation using javascript step. It worked for me. Let us know if you have any concerns.

Hi,

Can some one help with how to decrypt a filed with AES/CBC/PKCS5Padding algorithm in PDI/Spoon?