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. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Glossary

Creating a Data Set

Creating a Data Set

Run a plan to create a data set. Create and run different plans for data generation operations.
  • You cannot create a data set if the tables contain columns with user-defined data types. If a table contains columns with user-defined data types, mark the columns as restricted before you include the tables in a plan to create a data set. To mark a column as restricted, open the project and click
    Discover
    Columns
    and select the option
    Restricted
    for the required column.
  • Verify whether the tables in the data source contain primary keys. Create logical keys in all transactional tables that do not have any primary keys. A reset operation might fail if a transactional table with null values does not have primary keys.
  • If a table contains more than two character columns with a precision of 4000 each, edit the precision to 3,999 or less. A reset operation might fail if a data set contains more than two character columns with a precision of 4,000 each and you do not disable constraints during the reset operation.
  • You cannot perform
    self-service portal
    tasks that require a staging connection if a table in the
    data pack
    contains columns with a precision of 4,000 or greater. Edit the precision to 3,999 or less.
  1. Open a project and add the required data sources and the project components.
  2. Optional. Create parameters to use in the plan.
  3. To create a plan, click
    Execute
    and then click
    Actions
    New
    .
  4. Enter a name and optional description for the plan. Click
    Next
    .
  5. Add and configure the required components.
  6. Configure the plan settings.
  7. To create a data set, select
    Test Data Warehouse
    from the list of target connections.
    The
    Data Set Properties
    section appears.
  8. Enter a data set name. TDM enters the plan name by default. You can edit the name.
    When you enter a data set name that does not exist in the test data warehouse, you create the first version of a data set. TDM enters the data set version number.
  9. Enter an application name and application version to identify the data set.
  10. Add tags to the data set. Use a comma to separate tags.
    To delete a tag that you enter, click the
    X
    icon that appears with the tag. To use the keyboard to delete a tag, press
    Tab
    or
    Shift+Tab
    to select the tag and then press
    Delete
    from the keyboard.
  11. Configure the error and recovery settings and advanced settings as required.
  12. Optionally, configure an override strategy for a data source or a table.
  13. To save the plan, click
    Finish
    .
  14. To generate and run the workflow, click
    Actions
    Generate and Execute
    in the
    Plan Properties
    page.
  15. Optional. To publish the test data to the
    self-service portal
    , enter a name and select users or user groups to assign permission. You can add tags and enter a description for the
    data pack
    .
You can view the job log messages in the
Monitor
page. When the job completes successfully, you can view the data set in the
Data Sets
view.