InfoSphere Optim Test Data Management and Data Masking on z/OS - 1T812G

Description

This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. You will learn the basics of how the technology works, and how the technology applies to business scenarios. This course does not include information on how to install and configure the technology.

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

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

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

Aim

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

Participant requirements

You should have a working knowledge of:

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

Participant

This 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.