Database Reference
In-Depth Information
The Test Data Management Pack allows for data subsetting, data discovery, and modeling. The data subsetting
functionality enables you to create a referentially intact subset of data on production, development, and test systems.
Subsetting data for testing purposes makes testing easier by allowing you to select a percentage, 1% or 5%, of data
required.
Other features in this pack enable you to do the following:
•
Create/edit subset definitions
•
Preview the subset details and space estimates
•
Define and execute pre- and post-subset scripts
•
Execute the subset definition across targets
•
Export/import subset definitions
The second option is the Oracle Application Testing Suite, which is an extension to EM12c and enables the same
features as the Test Data Management Pack. The Oracle Application Testing Suite addresses all the same concerns and
provides a complete suite to create the test environment and perform the tests as needed.
enterprise Manager.
Note
As the complexity of applications increases, especially in shared computing environments such as the cloud,
access to sensitive data increases. Access to this data, such as social security numbers, can be limited by masking
it between environments. The Oracle Data Masking Pack replaces the original sensitive data with realistic-looking
scrubbed data that has the same type of characteristics as the original. This enables organizations to share fully
masked data and still be in compliance with both internal corporate governance and government regulations.
The Data Masking Pack enables you to do the following:
•
Create or use masking definitions
•
Mask real application testing workloads
•
Define format libraries for reuse
•
Export/import masking templates
•
Export/import format libraries
EM12c, through the Data Masking Pack, introduced the ability to discover data dependency and modeling.
This functionality allows you to discover data models and sensitive data in your environment so that you can protect
them through data masking. Using Oracle's FAST (Find, Assess, Secure, and Test) methodology to implement data
masking, you can create a test environment on Oracle Exadata that has all the sensitive information masked before
proceeding with the next step of validating the performance of the system.
Additional data-masking features enable you to do the following:
•
Create/edit application data models
•
Manually define applications, schemas, and tables
•
Use out-of-the-box metadata collection drivers for customer and packaged applications
•
Define sensitive columns manually or by using sensitive column discovery
•
Classify sensitive columns by sensitive types