Chapter 10 Generating a Database from a PDM

Creating a test data profile

When you create a test data profile you need to define the following properties:

Property Description
Name Name of the profile
Code Code of the data profile
Profile class You can assign one of the following data type classes:

Number

Character

Date/Time

When you define the profile class, make sure it reflects the DBMS limitations, for example, someDBMS do not support dates prior to a certain date.

Generation source

You define a test data generation source for each data profile. You can use the following test data generation sources:

Generation source Test data values are generated
Automatic By PowerDesigner
List From a list of test data values
ODBC From a target ODBC data source
File From a source file

Each data generation source has its own set of options for defining generation parameters.

Steps To create a test data profile:

  1. Select Model→Test Data Profiles.

    The List of Test Data Profiles appears.
  2. Click a blank line in the list.
  3. Type a test data Profile name and a profile code.
  4. Select a data type class from the Profile Class dropdown listbox.

    Note   Display the column you need
    If you do not see the column you need, display it with the Customize Columns and Filter tool. For details, see the General Features Guide .

  5. Click Apply.
  6. Double-click the new profile to display its property sheet.
  7. Define generation source parameters.
  8. Click OK in each of the dialog boxes.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.