- Data masking
- Test data environment setup and management
Makes it really easy to obfuscate big tables involving lots of columns and to manage 100’s of tables without putting in much effort.
Data masking with InfoSphere Optim products creates intermediary extract files and writing the data to persistent storage, which means that extraction, masking, and insertion happen being separate processes, taking more for the process to run.
I have used IBM InfoSphere Optim for five years.
We have not had any stability problems.
We have had some scalability issues.
We previously used IBM DataStage. There is a lot less flexibility in the InfoSphere DataStage Pack compared to the InfoSphere Optim products for selecting a specific subset of data to be masked. DataStage is driven by supplied SQL statements, whereas InfoSphere Optim is driven by traversing the database model and picking up related data elements from a starting point. Optim has more data privacy options.
Initial setup was a bit tedious and time consuming.
It’s very helpful in the mainframe environment.