Data Source Checks (PDM)

PowerDesigner provides default model checks to verify the validity of data sources.

Check

Description and Correction

Name/Code contains terms not in glossary

[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - None.

Name/Code contains synonyms of glossary terms

[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - Replaces synonyms with their associated glossary terms.

Name/Code uniqueness

Object names must be unique in the namespace.
  • Manual correction - Modify the duplicate name or code.
  • Automatic correction - Appends a number to the duplicate name or code.

Existence of physical data model

A data source must contain at least one physical data model in its definition.
  • Manual correction: Add a physical data model from the Models tab of the property sheet of the data source.

  • Automatic correction: Deletes data source without physical data model.

Data source containing models differing DBMS types

The models in a data source should share the same DBMS since they represent a single database.
  • Manual correction: Delete models with different DBMS or modify the DBMS of models in the data source.

  • Automatic correction: None

Unsupported source models

Each lifecycle policy can only manage one external database, so any data sources defined (and the models they reference) must all point to the same database.
  • Manual correction: Remove any data sources pointing to other databases.

  • Automatic correction: None