View previous topic :: View next topic
|
Author |
Message |
madishpa
New User
Joined: 18 May 2007 Posts: 28 Location: Hyderabad
|
|
|
|
Hi,
Could anyone please advise regarding the masking of particular data columns while unloading DB2 tables.
My requirement is to unload DB2 tables from production environment and load into pre-production environment.
I would need to take care of things like masking information related to customer-like name, phone number etc.
Could you please advise if there is already any method for encryption/masking.Even if while loading into pre-production environment if this request is met, then also it is fine.
If not, please advise if there is any tool which can take care of this request.
Thanks in advance.
Kind regards,
Pavan. |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
There must be many products available to do this.
One I know of is Optim, from IBM (formerly a PST product).
You use this rather than an unload.
If you want to stay with unload/load then you probably need to write your own to mask the data prior to the load.
We chose to use Optim in conjunction with our own code to permform this task.
It took two people, 9 months to complete. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
data masking / obfuscation is not something to be taken lightly!
if the data <obfuscated> is not related to anything else just putting random chars/numbers will be enough
if the data is involved in some kind of <logical relation> with some other tables/dataset You will need a consistent masking approach
the power of Your organization should be aware of the legal aspects of data obfuscation
the most effective approach both from a technical and legal point of view might be to rely on products designed for data masking
google for "data masking obfuscation certification" and You will find lots of hints and gotchas and solutions ( buyt not free ) |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Pavan,
Quote: |
masking of particular data columns while unloading DB2 tables
|
If those columns are not used in the program. Why unload and load those columns ? You can skip it in the unload and load default values.
As enrico said,
Quote: |
if the data is involved in some kind of <logical relation> with some other tables/dataset You will need a consistent masking approach. |
That would be really interesting.
Sushanth |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Thanks Don. |
|
Back to top |
|
|
|