DBMS Definition Files

DBMS definition file provide PowerDesigner with the information necessary to model, reverse-engineer, and generate for a particular DBMS. PowerDesigner provides definition files for most popular DBMSs. You select a DBMS when you create a PDM.

DBMS definition files have an .xdb extension and are located in install_dir/Resource Files/DBMS. To view the list of DBMSs, select Tools > Resources > DBMS. For information about the tools available in resource file lists, see PowerDesigner Resource Files.

You can consult or modify the DBMS definition file attached to your PDM in the Resource Editor by selecting Database > Edit current DBMS. When you select a category or an item in the left-hand pane, the name, value, and related comment appear in the right side of the dialog box.

Warning! We strongly recommend that you make a back up of the resource files delivered with PowerDesigner before editing them.

Each DBMS file has the following structure:

General - contains general information about the database, without any categories (see General Category (DBMS)). All items defined in the General category apply to all database objects.
Script - used for generation and reverse engineering. Contains the following sub-categories:
- SQL - contains the following sub-categories, each of which contains items whose values define general syntax for the database:
  - Syntax - general parameters for SQL syntax (see Syntax Category)
  - Format - parameters for allowed characters (see Format Category)
  - File - header, footer and usage text items used during generation (see File Category)
  - Keywords - the list of SQL reserved words and functions (see Keywords Category)
- Objects - contains commands to create, delete or modify all the objects in the database. Also includes commands that define object behavior, defaults, necessary SQL queries, reverse engineering options, and so on (see Script/Objects Category (DBMS)).
- Data Type - contains the list of valid data types for the specified DBMS and the corresponding types in PowerDesigner (see Script/Data Type Category (DBMS)).
- Customize - Retrieves information from PowerDesigner Version 6 DBMS definition files. It is not used in later versions.
ODBC - present only if the DBMS does not support standard statements for generation. In this case the ODBC category contains additional items necessary for live database connection generation .
Transformation Profiles – contains group of transformations used during model generation when you need to apply changes to objects in the source or target models (see Transformations (Profile)).
Profile - allows you to define extended attribute types and extended attributes for database objects (see Profile Category (DBMS)).

The following properties are available on the root of a DBMS definition file:

Property	Description
Name / Code	Name and code of the DBMS.
File Name	[read only] Path and name of the DBMS file.
Family	Used to classify a DBMS, and to establish a link between different database resource files. For example, Sybase AS Anywhere, and Sybase AS Enterprise belong to the SQL Server family. Triggers are retained when you change target within the same family. Merge interface allows to merge models from the same family.
Comment	Additional information about the DBMS

Triggers Templates, Trigger Template Items, and Procedure Templates
The DBMS Trigger templates, Trigger template items, and Procedure templates are accessible via the tabs in the Resource Editor window. In addition, for Oracle, there is a tab for database package templates.
Database Generation and Reverse Engineering
PowerDesigner supports generation and reverse engineering of databases through scripts and live connections via SQL statements and queries stored in the Script/Objects category. Generation and reverse-engineering of scripts and generation to a live connection all use the same statements, while reverse-engineering from a live connection uses separate queries.
General Category (DBMS)
The General category is located directly beneath root, and contains high-level items that define the basic behavior of the DBMS.
Script/Sql Category (DBMS)
The SQL category is located in the Root > Script category and contains sub-categories that define the SQL syntax for the DBMS.
Script/Objects Category (DBMS)
The Objects category is located in the Root > Script > SQL category (and, possibly within Root > ODBC > SQL), and contains the following items that define the database objects that will be available in your model.
Script/Data Type Category (DBMS)
The Data Type category provides mappings to allow PowerDesigner to handle DBMS-specific data types correctly.
Profile Category (DBMS)
The Profile category is used to extend standard PowerDesigner objects. You can refine the definition, behavior, and display of existing objects by creating extended attributes, stereotypes, criteria, forms, symbols, generated files, etc, and add new objects by creating and stereotyping extended objects and sub-objects.
ODBC Category (DBMS)
The ODBC category contains items for live database generation when the DBMS does not support the generation statements defined in the Script category.
Physical Options (DBMS)
For some DBMSs, additional options are used to specify how an object is optimized or stored in a database. In PowerDesigner, these options are called physical options and are displayed on the Physical Options and Physical Options (Common) tabs of object property sheets.
PDM Variables and Macros
The SQL queries recorded in the DBMS definition file items make use of various PDM variables, which are written between percent signs. These variables are replaced with values from your model when the scripts are generated, and are evaluated to create PowerDesigner objects during reverse engineering.