Using IBM InfoSphere Optim Solutions for Distributed Platforms - On-Demand Course

The Using IBM InfoSphere Optim Solutions for Distributed Platforms course is a 5-day course that is designed to teach students how to utilize the IBM InfoSphere Optim Solutions; Test Data Management, Data Privacy, and Data Growth for Archiving for Distributed Platforms. Students will learn how to build correctly 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.

The focus of this course is on the technical aspects of the Optim Solutions and is intended for technical audiences. Students will learn the basics of how the Solutions work through hands on exercises illustrating how the technology applies to business scenarios.

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

• IBM InfoSphere Optim Solutions and how they fit into Enterprise Data Management
• IBM InfoSphere Optim architecture components
• Function and contents of the Optim Directory
• Use the Optim Designer to build Optim services
• Use the embedded Optim Manager to run and manage Optim services
• Components of an access definition
• Process for generating and masking test data
• Generate, perform, and validate an extract process
• Utilize column maps and table maps
• Perform a convert process to mask data
• Perform and interpret a compare process
• Create database objects using embedded object definitions
• Populate destination tables using insert process
• Edit and browse test data
• Utilize data privacy functions to privatize data
• Design, construct, and execute an archive process
• Use control files to check archive error conditions
• Design and execute delete processes
• Use the create utility with insert and restore processes
• Perform a selective and a full restore process
• Utilize archive actions
• Maintain archive indexes
• Utilize archive file collections and open data manager (ODM)
• Create and utilize Optim primary keys and relationships
• Relationship traversal concepts
• Execute processes from the command line interface
• Retry and restart processes
• Execute the export and import Directory processes
• Functional, object, and file access security
• List Optim implementation best practices

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.

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

• 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 and Load Processes
• 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