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

Course Outline

• 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

Objective

• Describe the available IBM InfoSphere Optim Solutions and how they fit into Enterprise Data Management
• Describe the IBM InfoSphere Optim architecture components
• Describe the 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
• Describe and utilize the components of an access definition
• Describe the 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
• Explain relationship traversal concepts
• Execute processes from the command line interface
• Retry and restart processes
• Execute the export and import Directory processes
• Describe functional, object, and file access security
• List Optim implementation best practices