Decrypt data in Web intelligence report

[Former Member]

Hello,

We are trying to decrypt the data in web intelligence report. There is an encrypted data column that needs to be decrypted. Please suggest an option to decrypt the data in run time or when report is refreshed or any other alternative...

Appreciate the response. Thanks and looking forward to suggestions.

Regards,

Mohammad

[Former Member]

Hello Mohammed, did you get any update on the same?

How did you decrypt the data in BO at the universe OR report level? I am looking for the similar solution. could you help?

[manikandan_elumalai]

You definitely need the encryption and decryption logic in order to achieve this.. I would suggest you to build the decryption logic at database level as function and make use of it in object definition in universe level.

Thanks

Mani

[Former Member]

Hi Mani,

Function being used before data is loaded in database is

publicstring Encrypt'FIELD'(string 'FIELD'){returnthis.EncryptStringAES('FIELD);}

Now, in Universe object definition,

modifying the sql expression using the function ....Decrypt'FIELD'...would yield to intended result?

If there is an additional need of 'PlainText' or 'Ciphertext' etc.. I can try that as well.

Thank You,

Mohammad

[denis_konovalov]

If you have encrypted data in your database - that means there was some sort of process in place to either encrypt it during placement into the database or before it was placed into database.
Both means that it was done with external to BOE tools.
So, in order to decrypt it - either the DB function needs to be done or another tool.

Here is the sample - CMS DB. Its encrypted. The data in it can be accessed either via SDK or via CMS DB Driver (which decrypts the data) which allows webi to access it via universe.

Do you have a driver for your DB that decrypts data ?

[Former Member]

Hi Denis,

Sorry, we don't have a driver that decrypt the data.What are the steps to work through SDK as we don't have much programming expertise in house?

If anyone has any 3rd party tool to meet the gole please feel free to suggest.

Thank You

[denis_konovalov]

You haven't told us where that encrypted data is from and who encrypted it, so how can we answer those questions ?

[Former Member]

There is a .NET web/batch code that encrypts the field and then INSERTS/Updates the field in the database column.

[denis_konovalov]

then why would you expect BOE SDK to be able to un-encrypt it ?

You need to talk to/work with the people who made this .net web/batch code on how to decrypt their stuff before webi can pull it.

Webi or BOE in general cannot encrypt/decrypt data stored in the reporting databases. You need to work with people who own the database or who create the encrypted data.

[Former Member]

We don't have control on the process flow here, Thanks for your input Denis

All,

Please feel free to suggest an alternatives

Thanks,

[denis_konovalov]

there is no alternative.
no one can arbitrary decrypt encrypted data via reporting tool.
It is simply impossible. If you can't cooperate with people who encrypted data - then you are not supposed to decrypt it in the first place.
You are in effect hacking and trying to access something you're not supposed to.

Are you working for NSA ? 😉

[Former Member]

I know what I am doing.

I am not working for NSA, that's confidential.

[denis_konovalov]

NSA was a joke.
But the fact remains - if someone encrypted data, in order to decrypt it you need to cooperate with them.
Or use tools made to break encryptions.
In either case - SAP products can't help.

[former_member148884]

Web Intelligence has no encrypt/decrypt abilities. The only thing I can think to do is to schedule/save the data in the document to excel, CSV or text etc, then have the data decrypted outside of BI somehow.

Mike

[Former Member]

Thanks Mike for suggestion
We already have that option in place however our requirement is to have the decrypted report save as webi format

Regards,