Using IBM InfoSphere Optim Solutions for Distributed Platforms v11.3 DT225G

Duration: 
5 days
Codes: 
DT225G
Versions: 
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.

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.

Skills Gained

  • 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

Prerequisites

You should have:

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

Course Outline

  • 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

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Live Virtual Live Virtual5 3750 £3750 2019-09-23
Yorkshire Leeds5 3750 £3750 2019-10-21
Virtual Virtual5 3750 £3750 2019-10-21
London London5 3750 £3750 2019-10-21
Live Virtual Live Virtual5 3750 £3750 2019-11-11
Live Virtual Live Virtual5 3750 £3750 2019-11-25
Live Virtual Live Virtual5 3750 £3750 2019-12-30
Live Virtual Live Virtual5 3750 £3750 2020-02-03
Live Virtual Live Virtual5 3750 £3750 2020-02-17