Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

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

  • Tuition USD $4,125 GSA  $3,211.59
  • Reviews star_rate star_rate star_rate star_rate star_half 1950 Ratings
  • Course Code DT225G
  • Duration 5 days
  • Available Formats Classroom

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.

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

Who Can Benefit

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

You should have:

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

Course Details

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Ray is excellent instructor, very friendly & skilled.. the course is effective, interactive, lots of practice..

We went through AWS slides with the instructor answering our questions and providing his personal expertise. overall very positive experience

It was well organized and planned. That gave me a memorable learning experience.

Great course, though jam packed with information. Learned so much my head hurts.

Great! Teacher was awesome! Really engaging and that is hard to do with IT related things.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward