New Features and Enhancements for Version 9.7.0
This section describes the new features and enhancements for version 9.7.0.
Test Data Warehouse
Configure a test data warehouse to store and manage multiple versions of test data in a central location. Store versions of test data from relational sources as versions of a data set.
A test data warehouse consists of a test data repository and a test data mart. The test data repository stores the metadata related to the data sets. The test data mart stores the data. You can use a single test data repository and a single test data mart for multiple machines in the domain that host a Test Data Manager Service. You can share and reuse test data across teams and projects. To return a test environment to a specific state, you can reset a data set version from the test data mart to a target. To search the test data repository, you can add tags to the data set versions.
For information about how to configure a test data repository and test data mart, see the Test Data Management 9.7.0 Administrator Guide.
For information about how to create a data set in the test data mart, see the Test Data Management 9.7.0 User Guide.
tdwquery
tdwquery is a command line program that you can use to analyze data in a data set version.
Store multiple versions of test data in the test data mart and then use tdwquery to run queries to analyze the data. You can use the Select and Select Distinct clauses with multiple functions and joins to filter and search for data when you run queries.
For information on how to configure and use tdwquery, see the Test Data Management 9.7.0 User Guide.
TDM Support for Hadoop
You can perform data movement, data masking, and data domain profiling operations on Big Data Edition Hadoop clusters. In Test Data Manager, you can create Hive and Hadoop Distributed File System (HDFS) connections and use them as source and target connections.
You can add groups and data masking components to a Hadoop plan. You can run data domain profiles on Hive and HDFS data sources to identify sensitive data.
You can create a Hadoop plan to move data from flat files, and relational databases such as Oracle and DB2, ODBC-Sybase, and ODBC-Microsoft SQL Server into Hive and HDFS targets. You can also create a Hadoop plan when you want to move data between Hadoop sources and targets.
In a Hadoop plan, you can perform data movement and data masking operations. You can run a plan audit report and plan detail report for a Hadoop plan. You cannot perform data subset and data generation operations in a Hadoop plan.
Connection Permissions
To restrict access to connections that you create in Test Data Manager, you can assign connection permissions.
Allow or deny access, or provide a certain level of access to users and user groups by assigning connection permissions. The level of tasks that you can perform depend on the permission assigned. Read, write, and execute are the three levels of permission. Assign and edit connection permissions from Test Data Manager.
For more information, see the Test Data Management 9.7.0 Administrator Guide.