Kurs informasjon: Using InfoSphere Optim Test Data Mgmt and Data Masking on Dist Systems - ILO - New

NOTE: This is a live, instructor-led online course. Do not make arrangements to travel.

This course replaces course IBM Optim Test Data Mgmt with Data Privacy Option for Distributed Systems - ILO (3T212). This is the Instructor-led Online version of Classroom course Using Optim Test Data Mgmt with Data Masking Option on Dist Systems (DT213NO).

This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course material.

Using IBM Optim Test Data Management with Data Masking Option for Distributed Systems was designed to provide technical users with a foundation in the functionality basics of the Optim Solution. This course provides both a conceptual understanding of data masking as well as the Optim Solution's capabilities for de-identifying data for privacy protection and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim Solution's business value, features, and functionality.

This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. The focus of the course is hands-on experience building relational intact subsets of non-privatized and/or privatized data and creating Optim Primary Keys and Optim relationships which permit cross database extraction of data. You will learn the basics of how the technology works through hands-on practice and how to apply the technology to business scenarios.

This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim implementation project and confidently perform Optim tasks ongoing.

This course is designed to teach you the IBM InfoSphere Optim Test Data Management with Data Masking Option Solution basic concepts, functionality and GUI used to implement a test data management and a data masking solution. Hands-on exercises and checkpoint questions will be used to check the attendee's progress.

View this course in other countries

Roadmaps:

• Optim Test Data Management Solution (and Data Masking) for Distributed Systems – End User V8.1

Til top

This is a basic usage course for application developers, business analysts, database administrators, and technical personnel involved in implementing a data privacy solution using the IBM Optim Test Data Management with Data Masking Option for Distributed Systems Solution.

Til top

You should be able to:

• Access the internet for download of software
• Use basic Window functionality
• Discuss basic relational database concepts and objects such as tables, indexes, views, and join
• Construct and use basic SQL statements

Til top

• Discuss how data privacy concerns impact mission critical applications
• Discuss how the Optim Solution supports a test data management and a data privacy strategy
• Describe how the Optim Solution fits into the architectural landscape
• Choose the appropriate transformation technique
• Discuss how to define selection criteria
• Describe how the Optim Extract process works
• Create table maps and column maps
• Use Optim to create new tables and load those tables with data
• Describe how the Optim convert process works
• Describe how to insert masked data to a target database
• Discuss how to use Optim Compare to compare Extracts of single and multiple tables of data with other Extracts or existing tables
• Describe how to compare multiple sets of data
• Describe to define Optim Relationships and Optim Keys
• Use the Optim utilities to backup and reload the Optim Directory
• Use the Optim utilities to schedule Optim jobs
• Use the Command Line Interface to run Optim processes
• Explain how to use Column Map procedures and exit routines to modify columns
• Discuss the security options available with Optim
• List best practices for Optim implementation
• Transform and mask confidential data including, but not limited to, social security numbers, national IDs, credit card information, e-mail addresses, and telephone numbers
• Use Optim masking techniques to modify a wide variety of personal and confidential data

Til top

• Introduction to IBM InfoSphere Optim
• Optim Architecture
• The Optim Directory
• Access Definitions and Table Specifications
• The Extract Process
• The Convert Process
• The Compare Process
• The Create Utility
• The Insert and Load Process
• The Edit Process
• Optim Primary Keys and Optim Relationships
• Traversing Relationships
• The Command Line Interface
• Optim Utilities (Restart/Retry, Export/Import, Scheduling)
• Column Map Procedures and Exit Routines
• Optim Security
• Optim Implementation Best Practices
• InfoSphere Optim Data Masking Workshop

CURRICULUM RELATIONSHIP :

This course is one of three courses aimed at core Optim technical skills.

The three courses are:

• Installing and Configuring Optim Core Technology for Distributed Systems (DT2A3)
• Optim Data Growth for Archiving for Distributed Systems (DT203)
• Using Optim Core Technology for Distributed Systems (DT293) (Combination of InfoSphere Optim Data Growth for Archiving on Dist Systems (DT203) and Using Optim Test Data Mgmt with Data Masking Option on Dist Systems (DT213)

Til top