Table of Contents

PowerDesigner - Generation of Test Data

About

How to create Test Data from Power Designer.

In Power Designer, Test Data Profiles (Metadata) permits you to define the definition of the data that you want generate but is not mandatory. The Test Data Profiles are then attached the columns.

Below is written a little “how to”.

Steps

Creation of the Data Profiles

Powerdeisgner Test Data Profiles

You can assign test data profiles directly to columns:

You cannot assign a test data profile to a foreign key column because it automatically takes the data profile of the primary key column in the parent table.

Powerdesigner Column Data Profile

If you do not see the column “Test Data Profiles”, you can:

Generation of the Test Data

In the Menu > Database > Generate Test Data.

During the generation, for a foreign key, PowerDesigner automatically takes the data profile of the primary key column in the parent table.