IBM Optim Test Data Management

By managing data at the business-object level, IBM Optim™ preserves both the relational integrity of the data and its original business context. Business objects can be pulled from a single database or several related applications and databases. This “federated” extract capability makes it easy to create production-like environments that accurately reflect end-to-end test cases.

With a full range of data analysis capabilities, you can capture hidden correlations and bring them into view. Techniques include single-source and cross-source data overlap analysis, advanced matching, key discovery and transformation logic discovery.

Data governance is an organizational priority. With over 30 predefined data classifications and 40 predefined data privacy rules, Optim provides a standard way to govern the test data management process and validate that the policies and standards are honored throughout the lifecycle. Integration with the Governance Catalog allows users to drag and drop the classification and rule into column maps to automatically assign an executable data masking routine.

An intuitive, online interface and full-function browse utility helps to eliminate time consuming, error-prone, table-by-table comparisons. Optim identifies the expected database changes and uncovers differences that might go undetected.