EncartaLabs

IBM InfoSphere Optim Solutions for Distributed Platforms

( Duration: 5 Days )

The IBM InfoSphere Optim Solutions for Distributed Platforms training course will teach attendees how to utilize the IBM InfoSphere Optim Solutions - Test Data Management, Data Privacy, and Data Growth for Archiving - for Distributed Platforms. attendees 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.

By attending IBM InfoSphere Optim Solutions for Distributed Platforms workshop, attendees will learn to:

  • 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

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

This course is for Application Developers, Business Analysts, Database Administrators, & Technical Personnel that are involved in implementing IBM InfoSphere Optim Solutions.

COURSE AGENDA

1

Introduction to IBM InfoSphere Optim Solutions

2

Optim Directory and Common Elements

3

Optim Designer and the Embedded Manager Overview

4

Access Definitions and Table Specifications

5

Introduction to Test Data Management

6

The Extract Process

7

Basic Masking Techniques

8

Validating Changes (Compare)

9

Creating Database Objects

10

Populating Destination Tables

11

Editing and Browsing Test Data

12

Special Privacy Functions

13

The Archive Process

14

The Delete Process

15

The Create Utility

16

The Insert Process

16

The Restore Process

17

More Archive Functions

18

Archive File Collections and Open Data Manager

19

Optim Primary Keys and Optim Relationships

20

Relationship Traversal Concepts

21

The Command Line Interface

22

Optim Utilities

23

Optim Security

24

Optim Implementation Best Practices

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top