Skip to Content
avatar image
Former Member

Decrypt data in Web intelligence report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 30 at 12:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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,

  • Jan 30 at 12:48 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Jan 31 at 05:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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