Encrypted Data
Encrypted Data
I am looking for information on how to deal with encrypted data when running a column analysis. The copy of the data I am analyzing contains Non-public information (NPI) that has been encrypted. Can encrypted data even be analyzed? The encryption used is a DB2 encryption. From what I understand the actual data can be accessed once the password is retrieved. Is this sort of thing even possible during a Column Analysis or ultimately should a copy of the decrypted data be analyzed? In my case the table I am analyzing has only 1 column that is encrypted and after a Column Analysis the column status is Cannot Analyze
roc
Welcome!
I'm sure someone more smarter will be along to expand on this but from playing the home version of this game I would say that you would need to create a virtual table which includes a decrypted version of the column in question in order to perform the column analysis.
I'm sure someone more smarter will be along to expand on this but from playing the home version of this game I would say that you would need to create a virtual table which includes a decrypted version of the column in question in order to perform the column analysis.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. A decrypted copy of the data should be analyzed.
While, technically, you could perform column analysis on encrypted data, the results (in terms of values, formats, classifications, and even data types) would be unlikely to be meaningful.
And I would warrant that profiling for compliance with data rules would be even less useful were the data encrypted.
While, technically, you could perform column analysis on encrypted data, the results (in terms of values, formats, classifications, and even data types) would be unlikely to be meaningful.
And I would warrant that profiling for compliance with data rules would be even less useful were the data encrypted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To pick up on Craig's post, an IA virtual table cannot perform decryption. You may be able to create a materialized view or similar, however, and profile that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.