IBM InfoSphere Optim Test Data Management (TDM) Benefits

SD
Delivery manager at OSI Digital

It is a good tool that benefits our organization in terms of ease of maintenance and project management. We can check and showcase various reports to the management team.

View full review »
it_user642165 - PeerSpot reviewer
IT Leader in Global Technology, Corporate Systems at a insurance company with 10,001+ employees

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.
View full review »
OM
Data Modeler Manager / Application Development Manager at CIGNA Corporation

While allowing us to eliminate all sensitive data in lower environments, it also allows us to integrate in-house developed libraries.

View full review »
Buyer's Guide
Test Data Management
March 2024
Find out what your peers are saying about IBM, Broadcom, Informatica and others in Test Data Management. Updated: March 2024.
765,234 professionals have used our research since 2012.
it_user651513 - PeerSpot reviewer
Director-Projects at a tech services company with 10,001+ employees

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.

View full review »
AS
Technology Analyst at a tech services company with 10,001+ employees
  • 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
View full review »
it_user628044 - PeerSpot reviewer
Senior Project Manager /Senior Solution Architect at Cognizant

This feature helps organization to plan test data strategies based on data retention policies.

View full review »
SK
Technical Lead at Wipro Technologies

Performance improvement in the application by archiving the obsolete data on some of the packaged applications.

View full review »
SK
Technical Lead at Wipro Technologies

Data archiving saved much storage and improved production performance. We were able to achieve data privatization.

View full review »
EE
Database Security Consultant at a tech services company

My clients improved the quality of test data in their non-production environments and the privacy of sensitive information.

View full review »
it_user599013 - PeerSpot reviewer
Senior Test Analyst at a retailer with 1,001-5,000 employees

Makes it really easy to obfuscate big tables involving lots of columns and to manage 100’s of tables without putting in much effort.

View full review »
it_user653649 - PeerSpot reviewer
Product & Project Manager at a tech services company with 51-200 employees

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.

View full review »
it_user660612 - PeerSpot reviewer
Systems Analyst at a consultancy with 201-500 employees

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.

View full review »
Buyer's Guide
Test Data Management
March 2024
Find out what your peers are saying about IBM, Broadcom, Informatica and others in Test Data Management. Updated: March 2024.
765,234 professionals have used our research since 2012.