# SAP PowerDesigner CDM 8.0 to 16.x - Export

Availability-note[AWS](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-aws)

AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com

## 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 12.0.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 [MIMB Known Limitations](https://help.qlik.com/talend/en-US/talend-data-catalog/8.1/Subsystems/ModelBridgeGuide/Content/MIMB-Known-Limitations.htm)  
  
**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 | <table><tr><td>8.0</td></tr><tr><td>9.0</td></tr><tr><td>9.5</td></tr><tr><td>10.0</td></tr><tr><td>11.0</td></tr><tr><td>12.0</td></tr><tr><td>15.0</td></tr><tr><td>16.0</td></tr></table> | 16.0 |  |
| **File** | The path name of the generated CDM file.<br><br><br><br>In order to load the converted model, start PowerDesigner and:<br><br><br><br>1. Choose 'Open' from the File menu.<br><br>2. In the 'List files of type' list box select PowerDesigner Files.<br><br>3. Browse to the generated CDM file and select it from the file name list.<br><br>4. Click 'Open'. | FILE | \*.cdm |  | Mandatory |
| **Description** | How to export the Description and Comment properties in PowerDesigner:<br><br><br><br>'Comment & Description'<br><br>Export the comment property to the PowerDesigner comment field and the description property to the PowerDesigner description field.<br><br><br><br>'Comment'<br><br>Export the comment property (or the description property, if any), to the PowerDesigner comment field.<br><br><br><br>'Notes/Description'<br><br>Export the comment property (or the description property, if any), to the PowerDesigner description field. | ENUMERATED | <table><tr><td>Comment &amp; Description</td></tr><tr><td>Comment</td></tr><tr><td>Notes/Description</td></tr></table> | 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.<br><br><br><br>'space characters'<br><br>Several space characters as indentation.<br><br><br><br>'tab key'<br><br>Tab character as indentation.<br><br><br><br>'empty'<br><br>No indentation which leads to a more compact file. | STRING |  |  |  |
| **Reverse role names** | Swap relationship rolenames for each model:<br><br><br><br>'False'<br><br>Do not swap rolenames.<br><br><br><br>'True'<br><br>Swap rolenames. | BOOLEAN | <table><tr><td>False</td></tr><tr><td>True</td></tr></table> | False |  |
| **Connection** | Allows selecting a connection by name, if the source model contains multiple database connections.<br><br>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)<br>Metamodel<br>(based on the OMG CWM standard)** | **"SAP PowerDesigner CDM 8.0 to 16.x"<br>Metamodel<br>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 |  |