Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

XSD Data Sources

XSD Data Sources

You can perform data subset, data masking, and data generation operations on XML sources.
Import XML source metadata from the PowerCenter repository. To import an XML source, you import the source definition from the PowerCenter repository. A workflow that you generate and run fails if you import the XML instead of the XML source definition (XSD).
You can view the list of XSD files in a project from the
Files
tab in the
Discover
view of the project. Highlight a file to view the properties in the tab below. You can open and view the properties of each file in a separate page.
The following image shows the file page in Test Data Manager:
The XSD file page contains a Properties tab, Map or Grid view, and a Details tab. You can edit the properties and apply data subset criteria, data masking rules, and data generation rules from the Details tab.
The file page contains the following tabs:
Properties
Displays the name of the XSD file, project information, and a count of the objects with data masking, data generation, or data subset criteria assignments.
View
You can view the elements in a file as a map or in a grid. View the elements in the file and assign a data domain. To apply a masking rule to multiple elements, you can mark elements as similar value objects. You cannot perform tasks on all elements in the map or grid view. You can choose to view select objects from a list of options in the
Map View
. You can filter and search for elements and attributes based on general properties in the
Grid View
.
Details
Apply subset criteria, data masking rules, or data generation rules from the
Details
tab on the file page. To generate test data, you can select a link between the XML elements and configure the range of child records that you want in the target column.
The
Details
tab has the following tabs:
General
View the properties of an element or attribute. You can add or edit a data domain assignment, and you can mark an attribute or element as restricted or sensitive. When you run a workflow, the PowerCenter Integration Service ignores elements and attributes that you mark as restricted.
If you select a link between the XML elements or attributes, you can configure the minimum and maximum number of child records for each parent record.
Data Masking
Assign a policy and data masking rule or directly assign a data masking rule to an element or attribute.
Data Generation
Assign a data generation rule to an element or attribute, or create and assign a data generation rule.
Criteria
Specify the data subset criteria to apply to an element or attribute.