Reading Encrypted Queue Data in SQL Database?

[PayamKarbasi]

Hi, we are using BP 6.5.1 and the Queue Data was set as Encrypted for years. As we need to read the Data field from BPAWorkQueueItem SQL table, we turned it Not to be Encrypted anymore. So, we have access to fetch data from the Work Queue for in-house Data Analytics purposes now.

However, the historical data within "Data" field remains Encrypted. Any idea what solution should be practiced reading those encrypted data, or, how to decrypt all historical data (using any solution)?

Here is a sample of records, showing the last encrypted huge column (data) on the right side:

​

------------------------------
Payam Karbasi
------------------------------

[BohyonHwang]

Encryption schemes are used when writing the data for credentials and encrypted work queues into the database.
Especially AES-256 is virtually impenetrable without the key.
Therefore decryption is possible only if you have saved the key.

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------

[PayamKarbasi]

Thanks for your response, Bohyon. While we are using AES256 encryption, do you happen to have any piece of actual SQL query sample handy for decryption?

------------------------------
Payam Karbasi
------------------------------

[BohyonHwang]

Once you get encrypted data from SQL then you can decrypt it using decryption library.
Fortunately, you can find Utility - Encryption VBO in the DX.
visit this URL https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---encryption-2.

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------