By ACShorten on Feb 18, 2014
The Oracle Test Data Management Pack allows the quick and safe copying a subset of data from a production database to a non-production database. The pack can be used standalone or in association with the Oracle Data Masking Pack to comply with data privacy and data protection rules mandated by regulation or policy that restrict the use of actual customer data for non-production purposes.
Oracle Utilities Application Framework based products can utilize this pack using the following technique:
- A copy of the production schema with no data should be created on the production database. It is important not to load the data as this will aid in the creation. A copy of the schema can be built using Oracle SQL Developer or using tools included in Oracle Database Control/Oracle Database 12c EM Express.
Note: Oracle highly recommends not using the live production schema for the definition process.
- Follow the instructions in the Building A Data Model section of the Technical Best Practices for Oracle Utilities Application Framework Based Products (Doc Id: 560367.1) to prepare the copied schema for loading into Oracle Test Data Management Pack.
- Install the Oracle Test Data Management Pack within Oracle Enterprise Manager as prescribed in the Database Testing Guide.
- Create an Application Model on the copied and prepared schema using the instructions in the Data Discovery And Modeling documentation.
- Optionally, remove any tables or objects you do not want managed with the Oracle Test Data Management Pack Application Data Model you just loaded. For example, you might want to remove administration tables to optimize the time for the extract. This can be done within the Oracle Test Data Management Pack interface available within Oracle Enterprise Manager.
- The Application Model now can be used against any production schema (as the source) at execution time.
- Define the data subset you wish to extract as outlined in the Data Subsetting documentation. This can be a fixed subset, percentage or a complex SQL condition to determine the active subset to extract.
- Optionally, identify the sensitive data you want to mask and associate the formatting to be used for handling the masked data. This will automatically mask the data in the extract as outlined in the Masking Sensitive Data documentation.
- Extract the data subset using the Oracle Test Data Management Pack functionality. The extract will be in Oracle Data Pump export format. This can be safely transported to the target machine and loaded using Oracle Data Pump import. Remember to set the TABLE_EXISTS_ACTION on the import appropriately for your target environment (such as APPEND, TRUNCATE or REPLACE).
It is recommended that Oracle Test Data Management Pack be only used on Production environments to minimize licensing arrangements.
Note: This technique can be used with any release of the products or any release of the Oracle Utilities Application Framework.