Has anyone implemented PET on a MS SQL platform?
We are working through implementing encryption in our FSCM 9.1 environment (Tool 8.51). Due to the size of the database, database-level encryption is not feasible due to the impact on performance.
We are currently pursuing implementation of PET (using the 3DES 168 bit encryption), with our initial target being encryption of the TIN fields. Based on feedback from an SR I had open, we're working our way through every record, page, etc that references the TIN, creating a new fields and adding to the record to store the encrypted value. Then we're inserting custom PplCode into every place that the TIN is entered/displayed in our environment.