You can modify an object's properties from its property sheet. To open a test data profile property sheet, double-click its Browser entry in the Test Data Profiles folder.
The General tab contains the following properties:
Property |
Description |
---|---|
Name |
Specifies the name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users |
Code |
Specifies the technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces |
Comment |
Specifies a descriptive label for the test data profile. |
Stereotype |
Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
Class |
Specifies the kind of data to be generated from the profile. You can choose between:
|
Generation source |
Specifies from where PowerDesigner will draw the data to populate the columns associated with the profile. You can choose between:
|
If you have selected to automatically generate number data on the General tab, you must define the following properties on the Detail tab:
Property |
Description |
---|---|
Type |
Specifies whether the data is to be generated randomly or sequentially. |
Range |
Specifies the range of numbers to generate from and, if a sequential type is specified, the step value to use when traversing the range. |
Decimal numbers |
Specifies that the numbers to be generated are decimal, and the number of digits after the decimal point to generate. |
If you have selected to automatically generate character data on the General tab, you must define the following properties on the Detail tab:
Property |
Description |
---|---|
Valid characters |
Specifies the characters that can be generated (by default, all alphanumeric characters and spaces), separated by commas. You can specify:
To allow any character, select the All checkbox. |
Invalid characters |
Specifies the characters that cannot be generated, using the same syntax as for the valid characters. To disallow accented characters, select the No accents checkbox. |
Mask |
Specifies the mask characters used to tell users what kind of character they must enter in a given context. By default the test data profile uses the following mask characters:
|
Case |
Specifies the case in which to generate the data. If you select Lower or Mixed case, select the First Uppercase checkbox to require that each word begin with a capital letter. |
Length |
Specifies the length of character strings to generate. You can specify either an exact required length or a range. |
If you have selected to automatically generate date and time data on the General tab, you must define the following properties on the Detail tab:
Property |
Description |
---|---|
Date range |
Specifies the upper and lower limits of the date range within which data can be generated. |
Time range |
Specifies the upper and lower limits of the time range within which data can be generated. |
Step |
Specifies step values for use when traversing the date and time ranges, if sequential values are generated. |
Values |
Specifies whether the values are to be generated randomly or sequentially. |
If you have selected to provide list data on the General tab, enter as many value-label pairs as necessary on the Detail tab.
If you have selected to provide data from a database on the General tab, you must define the following properties on the Detail tab:
Property |
Description |
---|---|
Data Source |
Specifies the data source from which to draw data for the profile. Click the Select a Data Source tool to the right of this field to open a separate dialog on which you can specify your connection parameters. |
Login and Password |
Specifies the login and password to use when connecting to the data source. |
Table, Column, and Query |
Specifies the table and column from which the data will be drawn. By default, a query selecting distinct values from the column is used. |
If you have selected to provide data from a file on the General tab, you must define the following properties on the Detail tab:
Property |
Description |
---|---|
File |
Specifies the file from which to draw data for the profile. |
Type |
Specifies whether the values are to be drawn randomly or sequentially. |