IBM InfoSphere Optim Test Data Management Reviews

3.9 out of 5 stars
 (8)
Anonymous avatar x80
Real User
IT Leader in Global Technology, Corporate Systems at a insurance company with 10,001+ employees
May 23 2017

What is most valuable?

We use these functions: * Archive – archive data to PST files, we do not archive data to the archive DBMS * Data privacy – masking of PII and PHI data * Submitter – test data management This product archives all types of relational databases.... more»

How has it helped my organization?

Archive Moving data that is no longer needed in daily processing on to archive files, resulting in: * Faster query performance. * Shorter batch execution trails. * Stops/slows the growth of disk spaces. We don’t have to constantly add... more»

What needs improvement?

IBM treats non-production deploys with a lower priority to resolve problems. When we archive, we select a similar-sized non-production environment first, before we archive production. We need the volume to determine how big to make the... more»
Anonymous avatar x80
Real User
Technology Analyst at a tech services company with 10,001+ employees
Apr 23 2017

What is most valuable?

I value data masking, data extraction/sub-setting, data comparison, and data load.

How has it helped my organization?

* Creates an automated process for production data extraction * Does scrubbing * Does sub-setting and movement of data * Tests regions across various platforms including legacy and distributed platforms

What needs improvement?

The tool needs to have more test data management features like synthetic data generation and data reservation. Optim is capable of extracting/masking production data and move it to the test region, for test data provisioning. However, there... more»
Test data management report from it central station 2018 02 03 thumbnail
Find out what your peers are saying about IBM, CA Technologies, Informatica and others in Test Data Management.
253,234 professionals have used our research since 2012.
Anonymous avatar x80
Real User
Director-Projects at a tech services company with 10,001+ employees
May 18 2017

What is most valuable?

I really appreciate using the match keys and comparing the records before and after masking. This is done by joining multiple tables to form a single record. This helps to get a faster validation of data.

How has it helped my organization?

The product has helped to streamline the Test Data Management (TDM) process. Without this product, participation from several stakeholders such as DBAs, Admins, and the Environment refresh team were required.

What needs improvement?

Scripting complex data masking requirement in Lua can be converted into a simpler, user-friendly interface. Instead of a free text editor, which is used to code the functions (mostly "if-else" conditions), a drop-down like interface can be... more»
37c3c990 7c53 435f 8a64 447569ffa0fb avatar
Real User
Product & Project Manager at a tech services company with 51-200 employees
May 10 2017

What is most valuable?

* Optimizing and automating recurring processes that create and manage non-production environment data. * Creating right-sized fictionalized test databases. * Protecting sensitive data in non-production environments: Sensitive data such as national IDs, credit card numbers, email addresses and confidential corporate information can be masked to protect it from... more»

How has it helped my organization?

This product allowed us comprehensive test data management capabilities for creating right-sized, fictionalized test databases and it accurately provides subsets of referential intact data.
Anonymous avatar x80
Real User
Systems Analyst at a consultancy with 201-500 employees
May 11 2017

What do you think of IBM InfoSphere Optim Test Data Management?

Valuable Features Data masking with consistency across databases and applications is the most valuable feature. • Improvements to My Organization We only do data masking as of now because it is a compliance requirement. However, the benefits in sub-setting have not been realized yet. No application has availed of the service. • Room for Improvement Licensing could be improved. The PVU licensing mechanism is a limiting factor to expanding the use of the tool. • Use of Solution I have been using IBM Optim for five years. • Stability Issues We did have some stability issues. • Scalability Issues We did have some scalability issues. • Customer Service and Technical Support I would give technical support a rating of 7/10. • Previous Solutions We did not...
See 3 more reviews

User Assessments By Topic About IBM InfoSphere Optim Test Data Management

Archive Moving data that is no longer needed in daily processing on to archive files, resulting in: * Faster query performance. * Shorter batch execution trails. * Stops/slows the growth of disk spaces. We don’t have to constantly add additional disk space to the DBMS. After data is archived, we do not shrink the DB, on non-processing days. We also do not allow the tool to delete the data that was archived. Instead, we work with the Application DBAs to move the data onto Oracle Partitions; instead of deleting data and watching the commits process on the transaction logs. A misstep can throw the database into recovery mode. Instead, we just drop the partition holding the data that was archived. Data Privacy * All PII/PHI data in non-production environments is masked. * Used during end-to-end testing. By using the same rules for all data, we ensure data integrity across all of our applications. * Ensures customer data is not exposed in non-production environments. Subsetter (Test Data Management) * In the past, PeopleSoft admin would build non-production environments using chunks of transaction data, including all the static/reference data, resulting in broken chained data and a lot of useless data. * Selecting logical slices of data, we can ensure 100% data integrity and smaller-size databases. Also, we can pick and choose specific types of data to test and then combine that with data privacy. We have an efficient test bed of data that is optimized for performance, testing criteria, and is PII/PHI compliant.
Test data management report from it central station 2018 02 03 thumbnail
Find out what your peers are saying about IBM, CA Technologies, Informatica and others in Test Data Management.
253,234 professionals have used our research since 2012.

IBM InfoSphere Optim Test Data Management Questions

Oct 19 2017
Need archival software comparison for IBM OPTIM,Informatica ILM, Delphix. - What database it will support? - Performance - System Requirements - Cost - Support - Recommendation to use which one and why Thanks in Advance
Anonymous avatar x30
Andrew Crouch Hi, I can’t help re Delphix but see below for IBM Optim and... more»
Anonymous avatar x80
User at a healthcare company with 1,001-5,000 employees
What companies or services do you recommend that have experience with the IBM InfoSphere Optim tool, that have experienced with, or might be interested in, providing SMEs to transform data in Intersystems Cache, SQL or Oracle databases, into databases that are thoroughly de-identified of PII?  ... more»

What is IBM InfoSphere Optim Test Data Management?

IBM Optim solutions manage data from requirements to retirement. They boost performance, empower collaboration, and improve governance across applications, databases and platforms. By managing data properly over its lifetime, organisations are better equipped to support business goals with less risk.

Also known as
IBM Optim Test Data Management, Optim Test Data Management
IBM InfoSphere Optim Test Data Management customers

Dignity Health

Vendor 7400 screenshot 1514653938
BUYER'S GUIDE
Not sure which Test Data Management solution is right for you?

Download our free Test Data Management Report and find out what your peers are saying about IBM, CA Technologies, Informatica, and more!
Test data management report from it central station 2018 02 03 thumbnail

Sign Up with Email