Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

Creating a Column Profile

Creating a Column Profile

To perform a data generation operation, you can create and run a column profile.
  1. Open a project and click the
    Discover
    view.
  2. Click the
    Profile
    view.
    The
    Profile
    view shows a list of the profiles in the project.
  3. Click
    Actions
    New Profile
    .
    The
    New Profile
    dialog box appears.
  4. Enter the profile name and description.
  5. Select
    Column
    .
  6. Click
    Next
    .
  7. To add the tables that you want to run a profile on, click
    Add
    .
    The
    Select Tables
    dialog box appears.
  8. Select the tables, and click
    OK
    .
    The list of selected tables appears.
  9. Click
    Next
    .
  10. To create the column profile, configure the required sampling options.
  11. Click
    Finish
    .
    The profile opens in a tab.
  12. To run the profile, click
    Actions
    Execute
    .
    The
    Execute Profile
    dialog box appears.
  13. Select a connection to run the column profile.
    A column profile run fails if you select a native Oracle ODBC connection. Create an Oracle ODBC connection with the DataDirect driver.
    A column profile run fails if you do not specify a schema name in the Microsoft SQL Server database connection.
  14. Click
    Execute
    , and close the profile.
  15. In the project, click
    Monitor
    to view the progress of the profile run.