how to decrypt column data(by java utility) before showing in report

Question

I have a requirement in which data is stored in encrypted form in DB. I have to show that data in decrypted form in report. To decrypt I have one java utility (jar) in project. so how can I actually use that in Knowage for Report.

Thanks in advance.

Answer 1

Hello,

try to create a dataset of type JavaClass and see if this suits your needs. Check out the official documentation for more detailed information.

Bye,
Marco

Comments

Thanks @Marco. This is the one way. but I don't want to use java data set. so as an alternative I used the event handler DataItemEventAdapter for modifying( in my case decryption) any data item before showing in report.

I created a new java class eg. 'MyDecryptionDataItemEventAdapter' And assigned this class to data item where ver I need in the report.

---

Hi viping,

if you found my answer useful please select it as "best answer" so that other people can see it.

Thank you very much!

---

Other than Java dataset is there another option to customise my data in cockpit like event handle in Birt report?