PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/20/2014 6:45 AM by  Sameera
Field Encryption
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Sameera
Consultant
Next
Advanced Member
(70 points)
Advanced Member
Posts:30


Send Message:

--
02/18/2014 12:26 AM
    Is there a way to enable/ disable encryption for a selected field in ITM.

    Also how can we read the fields like EMPLOYEEIDENTIFICATIONNUMBER from DB (looks like its encrypted)

    Thanks
    Sameera
    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    02/18/2014 11:03 AM
    Hi Sameera - that field is encrypted, and I don't believe there is a way to disable encryption or to read it using SQL. The same is true of the EmployeeAlternateIdentificationNumber business class (DB table "EmpAltIdentNbr")

    There are basically two options that I have found - either use IPA to look up the values, or use the command line "dataexport" utility to dump the data as xml and then parse the values as required (which is a pain in the rear). You would need a good understanding of xml, xslt, and xsd, as well as the appropriate toolsets to make this work.

    Good Luck.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Sameera
    Consultant
    Next
    Advanced Member
    (70 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    02/20/2014 6:45 AM
    Hi Kelly

    Thanks a lot for the support.

    Thanks
    Sameera
    You are not authorized to post a reply.