What's new in Optim

Version 9, Release 1 of IBM® InfoSphere® Optim™ provides the following enhancements:

General

The Optim Designer and Optim Manager now provide full support for the test data management and data masking functions of the IBM InfoSphere Optim solutions. Among other things, Optim Designer and Optim Manager support the long standing compare, edit, browse, and show steps functions. Because Optim Designer and Optim Manager are the strategic user interfaces for the Optim solutions, text in Optim Designer and Optim Manager interfaces is translated into all Group 1 national languages. In general, this release includes:
  • Launchpads to install all components of Optim 9.1
  • A simple scripting language for column transformations
  • API support for service management
  • Two-way integration with IBM Atlas eDiscovery Process Management
  • For archive files:
    • Storage retention with suspension and resumption of expiration
    • Split, hold, expire, and convert capabilities
    • File validation
    • Command-line interface capacity for creation of archive file indexes and registration of protected archive files
    • Open data manager support for archive files with more than 4,000,000,000 rows
    • Optim Connect Studio now supports data source creation for archive files and archive file collections
  • Enhancements to Optim Connect, including:
    • Case insensitive collation for Microsoft SQL Server data sources
    • A general solution for big arithmetic that increases the supported upper limit for precision from 15 to 34
  • Delete by ROWID on Oracle data sources
  • Multi column search in lookup functions
  • Extended support for Teradata, including support for:
    • Teradata Binary Loader format
    • TPT support for child tables
    • Support for the SAMPLE clause on extract
  • Native processing support for Netezza® version 6.x, including tier migration.
  • Toleration support for:
    • DB2® for Linux, UNIX, and Windows v10
    • Informix® v11.7
    • Sybase v15.5
    • Teradata v14
  • New platform support:
    • AIX® v7.1
    • Redhat Enterprise Linux v6
  • Auditing of additional events, including open data manager access to archive files
  • Optional streaming of audit records to IBM InfoSphere Guardium® for database activity monitoring
  • Retirement of the management server

Optim Designer

  • Slimmed down service wizards for all test data management services (extract, insert, load, and convert)
  • Full-function property editors to manage and maintain all test data management services
  • New pre-configured repository to host all service-related, design, and operational artifacts
  • Newly redesigned repository explorer and perspective
  • New transformation process to copy requests in traditional Optim directories as services in the repository

Optim Manager

  • Administration capabilities for maintaining the Optim repository (stop, start, export, and backup)
  • Job orchestration
  • Enhanced support for service overrides