Training offering

Using IBM InfoSphere Optim Solutions for Distributed Platforms (v11.3)

Overview

This course will teach participants how to utilize the IBM InfoSphere Optim Solutions - Test Data Management, Data Privacy, and Data Growth for Archiving - for Distributed Platforms. Participants will learn how to create "right-sized" test data environments with the Test Data Management Solution; how to privatize confidential data with the Data Privacy Solution; and how to archive retired data with the Data Growth Solution.

This course focuses on the technical aspects of the Optim Solutions and is intended for technical audiences. Participants learn the basics of how the Solutions work through hands on exercises illustrating how the technology applies to business scenarios.

This course does not include information on how to install and configure the Optim technology.

Public

This is a basic usage course for application developers, business analysts, database administrators, and technical personnel that are involved in implementing IBM InfoSphere Optim Solutions.

Prerequisits

You should have:

• A working knowledge of Windows
• A basic understanding of relational databases
• The ability to construct basic SQL statements

Objective

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:

http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

• The current GTP list price
• The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.

Topics

• Introduction to IBM InfoSphere Optim Solutions
• Optim Directory and Common Elements
• Optim Designer and the Embedded Manager Overview
• Access Definitions and Table Specifications
• Introduction to Test Data Management
• The Extract Process
• Basic Masking Techniques
• Validating Changes (Compare)
• Creating Database Objects
• Populating Destination Tables
• Editing and Browsing Test Data
• Special Privacy Functions
• The Archive Process
• The Delete Process
• The Create Utility
• The Insert Process
• The Restore Process
• More Archive Functions
• Archive File Collections and Open Data Manager
• Optim Primary Keys and Optim Relationships
• Relationship Traversal Concepts
• The Command Line Interface
• Optim Utilities
• Optim Security
• Optim Implementation Best Practices