Informatica Test Data Management 10.4 has been released and is now available for shipping immediately. This release contains various fixes requested by customers, critical enhancements, and PAM updates.
TDM 10.4 works on Informatica Domain 10.4 and can provision data for big data and non-big data environments on a single domain.
Identity column support for IBM DB2 running on i/OS.
Support for special characters in metadata for Microsoft SQL Server when used in bulk mode.
Assignment of Advanced masking rules to columns using REST APIs.
Support for Test Data Warehouse service, Command line utilities and REST APIs in Kerberos environment.
TDM 10.2.0 HotFix 1 has been released to shipping and is generally available immediately.
TDM Core Enhancements
Customer Requested Enhancements:
Users can now define parameters at a Global level and use the same in projects. Parameters can be created once and used across projects.
Subset execution is faster and easier to use. Users can decide on subset logic on the UI.
Customers can now perform a subset with referential integrity & masking in a single plan.
TDM 10.2. 0 HotFix 1 has public RESTful APIs for TDM, test data warehouse & the self-Service portal. Customers can use these APIs to automate actions.
Support for Cloud Databases:
Support for NoSQL Databases:
Microsoft SQL Server 2017
Oracle 12c Release 2
Microsoft Windows 2016
Oracle multi-tenant architecture
Persistent Data Masking Enhancements
Delimited Key String masking – Users can now configure delimited string masking using a key string masking rule to consistently mask a string of data that appears as a data substring in another column.
TDM 10.2 R1 has been released to shipping and is generally available immediately. This product release provides significant improvements to functional tester productivity, expanded PAM for Test Data Generation & test data warehouse, and encryption as a new protection technique.
TDM Core Enhancements
Self-Service Portal: The new self-service portal enables functional testers to prepare data and provision data for their testing environments in a modern UI. Functional testers can now do the following in the self-service portal:
Create copies of data
View and edit data
View related data
Benefits: Simplified operational user experience and improved tester productivity
Test data Generation & Test Data Warehouse Enhancements
PostgreSQL as repository for Test Data Warehouse: TDM 10.2 R1ships with PostgreSQL that can be used as the repository for Test Data Warehouse. Customers can continue to use Oracle as a repository too.
Benefits: cost savings and reduced licensing requirements
2. Expanded support for TDG & TDW: The following file formats are now supported for Test Data Generation & Test Data Warehouse:
Sequential multi record files
VSAM multi record files
IMS multi record files
PWX single record sequential files
3. PAM Updates
My SQL support for data subset, data masking, TDG & TDW
Native Netezza support
PostgreSQL as a source for data subset, data masking & TDG
Persistent Data Masking Enhancements
Encryption: 10.2 R1 introduces a new protection technique – Format Preserving Encryption for relational data stores.
Format preserving encryption allows for the replacement of alphabets with alphabets, while maintaining case, and replacement of numbers with numbers
Metadata preserving encryption allows for encryption as long as length and data type are maintained
Encryption based on a pass phrase
Support for string data types
Benefits: Share sensitive data with partners in a secure way. Decrypt to get back original data after processing is done. No change in metadata required.
2. Export/import Data Domain Column assignments: TDM 10.2 R1 provides the ability to export and import data domain column assignments.
Benefits: Improved productivity of compliance managers and security officers as they can now review the risk of each column offline and assign data domains to them. They do not have to be TDM users to be doing this work.
3. Integration with Secure@Source: Support for asynchronous data protection tasks initiated by Secure@Source and completed by TDM/PDM users.
Benefits: improved interop across Informatica products to detect and protect sensitive data
The End of Life dates for Test Data Management are as follows.
Minimum Support Period
End of Support
31 August 2019
31 August 2020
30 September 2018
30 September 2019
*Note that Extended and Sustaining Support are available at an additional charge and Sustaining Support is not available for all product releases. For further information, please contact: firstname.lastname@example.org
Support for Test Data Management for use with SAP (also known as Data Subset for SAP, Data Privacy for SAP, and Data Masking for SAP) will end on 03 April 2018. Extended support will end on 03 April 2019.
Note that Extended Support is available at an additional charge. Please contact email@example.com for more information.
Improved efficiencies for Test engineers by enabling generation of test data while executing a plan. Test data Administrators can parameterize various parameters like the connection, Owner & the Criteria’s while creating the plan & test engineers can provide the requires parameter values from within the TDM UI while executing the plans.
2. SSN Randomized masking – new SSN masking rules for valid & invalid SSNs
3. PDM Enhancement
1. Secure @ Source integration – Support data masking for sensitive data from Secure@Source
- Protect data from within Secure @ Source by defining masking as a protection mechanism
- Inplace masking for Hive sources from within the Secure@Source environments
2. Support for Spark ingestion to improve performance
4. HDFS Reader/Writer Support (for PC Mappings)
Customer Requested Enhancements
Table metadata can now be deleted from an entity forming part of the project.
Test data generation scheduled to be run at a later time can be unscheduled
DMO session properties are now available in the TDM UI
Support for computed Column in TDM
These enhancements provide significant operational efficiencies to our Customer’s test data creation & management processes.
Trigger management for Sql Server, Oracle, Sybase & DB2. Triggers created on these tables will now be automatically dropped and created while doing a subset.
Recursive Executor changes – Commits have now been introduced at regular intervals while running recursive executor for large data sets to avoid db lock issues and also to log the work being done.