IBM InfoSphere Optim Test Data Management solution, Part 1: Masking data using a column map procedure

This demo shows how to use a Lua string function to privatize sensitive data by reversing the characters in a specific column. In particular, the phone numbers in the supplied, sample OPTIM_CUSTOMERS table for U.S.-based customers are masked. Each portion of the phone number is reversed individually (e.g. area code, exchange, last four digits).

Shilpa Jaganmohan (shilpaj@us.ibm.com), Advisory Software Engineer, IBM

Shilpa Jaganmohan is an advisory software engineer in InfoSphere Optim Support Level 3. She worked in Optim distributed database development and implementation and now handles customer requests for support on Optim products.



William Steinagle (wsteinag@us.ibm.com), Advisory Software Engineer, IBM

William Steinagle is an advisory software engineer in InfoSphere Optim Support. He handles customer requests for support on Open Data Manager and other Optim Data products.



Xin Jin (jinx@us.ibm.com), Eclipse Developer, IBM

Cindy Jin is a technical team lead on the IBM InfoSphere Optim - Optim Designer project. She works on Optim design and implementation.



Wayne M. Deleo (wdeleo@us.ibm.com), Information Management Writer, IBM

Wayne M. Deleo is an information developer in the InfoSphere Optim solutions group. He works with Optim product engineering and support teams to develop user information for the Optim solutions.



01 November 2012

The IBM® InfoSphere® Optim™ Test Data Management solution offers proven technology to optimize and automate processes that create and manage data in nonproduction (testing, development and training) environments. Through targeted, right-sized and privatized test environments, business critical applications can be developed using real world data.

Duration

6:56 minutes

Download

DescriptionNameSize
Demo transcriptOptim_Masking_Lua1.pdf31KB

Resources

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=844103
SummaryTitle=IBM InfoSphere Optim Test Data Management solution, Part 1: Masking data using a column map procedure
publish-date=11012012