Home > Vendors > ibm > dt225g

DT225G - Using IBM InfoSphere Optim Solutions for Distributed Platforms V11.3

This course will teach you 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. You 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.

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

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 and load processes
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, restore, and load 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

Content

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

Audience

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.

Prerequisites

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

Certification

This course is not associated with any Certification.

Course Benefits

Career growth
Broad Career opportunities
Worldwide recognition from leaders
Up-to Date technical skills
Popular Certification Badges

Enquire Now

Cqj1h7

By clicking "Submit", I agree to the Terms Of Use and Privacy Policy

➤