can we run a jar file from qv load script and consume the output in qlikview ?
If my jar is encrypting the data, I would like to consume the encrypted data and display in my dashboard.
and in my second jar i have the decryption code, which when called need to display decrypted data.
Let me know if there is an alternate way to do this. The restriction is I can only use java .
Appreciate all your help.
I think you could write a Java program which either de- or encrypts the data with your lib and stores it as CSV which you call in load script:
execute cmd.exe /C "java -jar myprogram.jar";
Or, you write a JDBC wrapper driver (or we can do this) which does the job (de- or encryption) on the resultset and then use our JDBC connector to stream the data directly into QlikView. In this case there will no data written persisent to disk outside of QlikView like in the first case.