InfoSphere Optim Test Data Management and Data Masking on z OS DT812G

This basic course is for Privacy Project Leaders and project team members who will be responsible for implementing and executing a data privacy strategy for one or more applications. This would include application developers, business analysts, and DBAs who have been assigned to your privacy project.

• Extract relational subsets of data from a database
• Choose the appropriate privacy functions to mask sensitive data
• Use the Compare function to verify your privacy strategy
• Insert privatized data to a target database
• Use the Optim relational editor to verify the inserted data
• Select the correct relationship traversal options for your data model
• Define Optim Relationships and Primary Keys, if needed
• Export and Import Optim Directory objects
• Identify the factors that affect Optim performance

You should have a working knowledge of:

• DB2 and relational database concepts
• DB2 SQL basics
• TSO/ISPF editing commands and job output retrieval functions

Unit 01: Introduction to IBM Optim Solutions

Unit 02: The Optim Directory

Unit 03: Introduction to Test Data Management

• Exercise 01: Getting Started

Unit 04: Extract the Data

• Exercise 02: Extract the Data to be Privatized

Unit 05: Create Database Objects

• Exercise 03: Create Database Objects

Unit 06: Basic Masking Techniques (Convert)

• Exercise 04: Use Basic Masking Techniques

Unit 07: Use Compare to Validate Your Changes

• Exercise 05: Use Compare to Validate Your Changes

Unit 08: Populate the Destination Tables

• Exercise 06: Insert and Load the Destination Tables

Unit 09: Retry or Restart an Optim Process

Unit 10: Edit and Browse Test Data

• Exercise 07: Edit and Browse Test Data

Unit 11: Optim Primary Keys and Relationships

• Exercise 08: Create Optim Primary Keys and Relationships

Unit 12: Relationship Traversal Concepts

• Exercise 09: Traversing Relationships

Unit 13: Export and Import Optim Directory Objects

• Exercise 10: Export and Import Optim Directory Objects

Unit 14: Optim and Legacy Data

Exercise 11: Extract Legacy Data

Unit 15: Batch Utilities

• Exercise 12: Use Batch Utilities

Unit 16: Optim Security Overview

Unit 17: Performance Considerations

Unit 18: Special Masking Functions

• Exercise 13: Use the Special Masking Functions