Using Oracle Test Data Manager with OUAF

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.

  • 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.

It is recommended that Oracle Test Data Management Pack be only used on Production environments to minimize licensing arrangements.

Note: If there is a need to comply with local privacy and protection laws that Oracle Data Masking Pack is also used with the Oracle Test Data Management Pack.

Note: This technique can be used with any release of the products or any release of the Oracle Utilities Application Framework.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Enterprise Taxation and Policy Management. I am the product manager for the Management Pack for these products.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today