The IBM InfoSphere Optim Solutions for Distributed Platforms training course will teach you to utilize the IBM InfoSphere Optim Solutions - Test Data Management, Data Privacy, and Data Growth for Archiving - for Distributed Platforms. You will learn 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, delegates will learn to:
- Describe the available IBM InfoSphere Optim Solutions and how you 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 IBM InfoSphere Optim Solutions for Distributed Platforms class is ideal for Application Developers, Business Analysts, Database Administrators, & Technical Personnel that are involved in implementing IBM InfoSphere Optim Solutions.