Kurs informasjon: Using Optim Test Data Mgmt with Data Masking Option on Dist Systems

Using IBM Optim Test Data Management with Data Masking Option for Distributed Systems was designed to provide technical users with a foundation in the functionality basics of the Optim Solution.

This course provides both a conceptual understanding of data masking as well as the Optim Solution's capabilities for de-identifying data for privacy protection and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim Solution's business value, features, and functionality.

This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. The focus of the course is hands-on experience building relational intact subsets of non-privatized and/or privatized data and creating Optim Primary Keys and Optim relationships which permit cross database extraction of data. Participants will learn the basics of how the technology works through hands-on practice and how to apply the technology to business scenarios.

This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim implementation project and confidently perform Optim tasks ongoing.

This course is designed to teach the attendee the IBM Optim Test Data Management with Data Masking Option Solution basic concepts, functionality and GUI used to implement a test data management and a data masking solution. Hands-on exercises and checkpoint questions will be used to check the attendee's progress.

View this course in other countries

Roadmaps:

• Optim Test Data Management Solution (and Data Masking) for Distributed Systems – End User V8.1

Til top

This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data privacy solution using the IBM Optim Test Data Management with Data Masking Option for Distributed Systems Solution.

Til top

You should be able to:

• Access to the internet for download of software
• Use basic Window functionality
• Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
• Construct and use basic SQL statements

Til top

• Discuss how data privacy concerns impact mission critical applications
• Discuss how the Optim Solution supports a test data management and a data privacy strategy
• Describe how the Optim Solution fits into the architectural landscape
• Choose the appropriate transformation technique
• Discuss how to define selection criteria
• Describe how the Optim Extract process works
• Create table maps and column maps
• Use Optim to create new tables and load those tables with data
• Describe how the Optim convert process works
• Describe how to insert masked data to a target database
• Discuss how to use Optim Compare to compare Extracts of single and multiple tables of data with other Extracts or existing tables
• Describe how to compare multiple sets of data
• Describe to define Optim Relationships and Optim Keys
• Use the Optim utilities to backup and reload the Optim Directory
• Use the Optim utilities to schedule Optim jobs
• Use the Command Line Interface to run Optim processes
• Explain how to use Column Map procedures and exit routines to modify columns
• Discuss the security options available with Optim
• List best practices for Optim implementation
• Transform and mask confidential data including, but not limited to, social security numbers, national IDs, credit card information, e-mail addresses, and telephone numbers
• Use Optim masking techniques to modify a wide variety of personal and confidential data

Til top

• Introduction to IBM InfoSphere Optim
• Optim Architecture
• The Optim Directory
• Access Definitions and Table Specifications
• The Extract Process
• The Convert Process
• The Compare Process
• The Create Utility
• The Insert and Load Process
• The Edit Process
• Optim Primary Keys and Optim Relationships
• Traversing Relationships
• The Comand Line Interface
• Optim Utilities (Restart/Retry, Export/Import, Scheduling)
• Column Map Procedures and Exit Routines
• Optim Security
• Optim Implementation Best Practices
• InfoSphere Optim Data Masking Workshop

CURRICULUM RELATIONSHIP :

This course is one of three courses aimed at core Optim technical skills.

The three courses are:

• Installing and Configuring Optim Core Technology for Distributed Systems (DT2A3)
• Optim Data Growth for Archiving for Distributed Systems (DT203NO)
• Using Optim Core Technology for Distributed Systems (DT293) (Combination of Optim Data Growth for Archiving for Distributed Systems (DT203NO) and Using Optim Test Data Mgmt with Data Masking Option on Dist Systems (DT213NO))

Til top