SAP PowerDesigner CDM 8.0 to 16.x - Export
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | SAP |
| Tool Name | PowerDesigner CDM (Conceptual Data Modeling) |
| Tool Version | 8.0 to 16.x |
| Tool Web Site | https://www.sap.com/products/powerdesigner-data-modeling-tools.html |
| Supported Methodology | [Data Modeling] Data Store (Logical Data Model), Graphical Layout via CDM XML File |
SPECIFICATIONS
Tool: SAP / PowerDesigner CDM (Conceptual Data Modeling) version 8.0 to 16.x via CDM XML File
See https://www.sap.com/products/powerdesigner-data-modeling-tools.html
Metadata: [Data Modeling] Data Store (Logical Data Model), Graphical Layout
Component: SybasePowerDesignerCdm version 11.2.0
OVERVIEW
This bridge generates a PowerDesigner .CDM (Conceptual data model) file with entities, attributes, domains, relationships and their implementation (e.g. PK/FK) as well as the graphical layout (diagrams).
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
Q: All the symbols are in the center of the screen, what can I do?
A: In the tool, select 'Symbol->Auto-Layout', it will redraw the current diagram. Note that you will have to do this for each diagram.
Q: Some symbols seem to be missing, what can I do?
A: In the tool, select 'Tools->Complete Links', it will draw the missing symbols. Note that you will have to do this for each diagram.
LIMITATIONS
When importing from a multi model source technology (e.g. a database server with multiple databases or schemas), only one model (e.g. schema) is exported. Therefore, limit the import scope to a single model (e.g. subset one schema of a database).
Refer to the current general known limitations at https://www.metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | ||||||||
| Version | The version of SAP Power Designer (CDM) file to generate. | ENUMERATED |
|
16.0 | |||||||||
| File | The path name of the generated CDM file. In order to load the converted model, start PowerDesigner and: 1. Choose 'Open' from the File menu. 2. In the 'List files of type' list box select PowerDesigner Files. 3. Browse to the generated CDM file and select it from the file name list. 4. Click 'Open'. |
FILE | *.cdm | Mandatory | |||||||||
| Description | How to export the Description and Comment properties in PowerDesigner: 'Comment & Description' Export the comment property to the PowerDesigner comment field and the description property to the PowerDesigner description field. 'Comment' Export the comment property (or the description property, if any), to the PowerDesigner comment field. 'Notes/Description' Export the comment property (or the description property, if any), to the PowerDesigner description field. |
ENUMERATED |
|
Comment & Description | |||||||||
| XML Indentation (pretty printing) | Controls the pretty printing of XML, for the purpose of opening the generated file in a text editor. E.g. 'space characters' Several space characters as indentation. 'tab key' Tab character as indentation. 'empty' No indentation which leads to a more compact file. |
STRING | |||||||||||
| Reverse role names | Swap relationship rolenames for each model: 'False' Do not swap rolenames. 'True' Swap rolenames. |
BOOLEAN | False | ||||||||||
| Connection | Allows selecting a connection by name, if the source model contains multiple database connections. If the source model contains multiple connections and this parameter value is left empty, the connection with the most objects is selected. |
STRING |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"SAP PowerDesigner CDM 8.0 to 16.x" Metamodel SybasePowerDesignerCdm07 |
Mapping Comments |
| Association | Relationship | Association is moved if not in the same package as its classes. |
| Aggregation | Dependent | |
| Comment | . | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| ExtraConstraint | . | |
| Name | Name | Diagram Name. Computed if not set |
| NativeId | . | |
| PhysicalName | Code | Diagram Physical Name.Computed from the Name if not set |
| Stereotype | . | |
| AssociationRole | Relationship | |
| Comment | . | |
| CppContainment | . | |
| CppFriend | . | |
| CppScope | . | |
| CppStatic | . | |
| DesignLevel | No equivalent for Physical Only objects. | |
| ExtraConstraint | . | |
| Multiplicity | Cardinality | |
| Name | Role name | |
| NativeId | . | |
| Navigable | . | |
| Ordered | . | |
| Source | Dependent | |
| Stereotype | . | |
| Attribute | Attribute/Data Item | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| ExtraConstraint | Business Rule | |
| Name | Name | Attribute Name. Computed if not set |
| Optional | Mandatory | |
| PhysicalName | Code | Attribute Physical Name.Computed from the Name if not set |
| Position | The attributes are ordered by position in the CDM file | |
| BaseType | Domain, Attribute Data Type | See DerivedType |
| CandidateKey | Identifier/Primary Identifier | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Name | Key Name. Computed if not set |
| PhysicalName | Code | Key Physical Name.Computed from the Name if not set |
| UniqueKey | Only unique candidate keys are exported. | |
| Class | Entity | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Name | Class Name. Computed if not set |
| PhysicalName | Code | Class Physical Name.Computed from the Name if not set |
| ClassDiagram | Conceptual Diagram | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Name | |
| PhysicalName | Code | Diagram Physical Name.Computed from the Name if not set |
| DerivedType | Domain, Attribute Data Type | |
| DataType | Data type | See datatype conversion array |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Length | Length | |
| LowerBound | Minimum | |
| Name | Name | Type Name. Computed if not set |
| PhysicalName | Code | Type Physical Name.Computed from the Name if not set |
| Scale | Precision | |
| UpperBound | Maximum | |
| DesignPackage | Package | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Name | Package Name. Computed if not set |
| PhysicalName | Code | Package Physical Name.Computed from the Name if not set |
| Generalization | Inheritance | Generalization is duplicated if its subtypes are not in its package. |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Name | Generalization Name. Computed if not set |
| PhysicalName | Code | Generalization Physical Name.Computed from the Name if not set |
| GeneralizationRole | InheritanceLink | |
| Note | Annotation | |
| Projection | Symbol | Graphical Information |
| BackgroundColor | fill color | |
| FontColor | font color | |
| Height | height | |
| LineColor | line color | |
| Width | width | |
| X | x | |
| Y | y | |
| RelationshipProjection | Symbol | Graphical Information |
| FontColor | font color | |
| LineColor | line color | |
| StoreModel | Model | |
| Description | Comment | |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Name | Model Name. Computed if not set |
| PhysicalName | Code | Model Physical Name.Computed from the Name if not set |
| Name | Label | |
| TypeValue | List of Values | All the values are listed in one tag |
| DesignLevel | No equivalent for Physical Only objects. | |
| Name | Label | |
| Position | TypeValues are ordered by position in the CDM file | |
| Value | Value |