# SAP PowerDesigner CDM 6.x - Import 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** | **6.1.x** | | **Tool Web Site** | https://www.sap.com/products/powerdesigner-data-modeling-tools.html | | **Supported Methodology** | [Data Modeling] Data Store (Logical Data Model) via (Data Modeling) Logical only CDM Export File | | **Data Profiling** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Incremental Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Multi-Model Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | | **Remote Repository Browsing for Model Selection** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Content/Resources/images/cross.png) | **SPECIFICATIONS** **Tool:** SAP / PowerDesigner CDM (Conceptual Data Modeling) version 6.1.x via (Data Modeling) Logical only CDM Export File See https://www.sap.com/products/powerdesigner-data-modeling-tools.html **Metadata:** [Data Modeling] Data Store (Logical Data Model) **Component:** SybasePowerDesignerCdm06 version 11.2.0 **OVERVIEW** This bridge imports data models from a PowerDesigner .CDM (Conceptual data model) file with Entities, Attributes, Domains. This bridge also imports all relationships and their implementation (e.g. PK/FK) as well as the graphical layout (diagrams). **REQUIREMENTS** n/a **FREQUENTLY ASKED QUESTIONS** n/a **LIMITATIONS** Refer to the current general known limitations at [MIMB Known Limitations](https://help.qlik.com/talend/en-US/talend-data-catalog/8.0/Subsystems/ModelBridgeGuide/Content/MIMB-Known-Limitations.htm) or bundled in Documentation/ReadMe/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** | | --- | --- | --- | --- | --- | --- | | **File** | When a model is currently loaded in SAP PowerDesigner DataArchitect CDM:



1. Choose 'Save/Save As' from the File menu.

2. Type the file name and browse to select a specific directory.

3. Click 'OK'.



This bridge will use the generated CDM file as input. | FILE | \*.cdm | | Mandatory | | **Encoding** | Specifies the character set encoding of the model to be imported.



If there are multiple choices for a language, the actual encoding will be indicated between parentheses. | ENUMERATED |
Central and Eastern European (ISO-8859-2)
Central and Eastern European (Windows-1250)
Chinese Traditional (Big5)
Chinese Simplified (GB18030)
Chinese Simplified (GB2312)
Cyrillic (ISO-8859-5)
Cyrillic (Windows-1251)
DOS (IBM-850)
Greek (ISO-8859-7)
Greek (Windows-1253)
Hebrew (ISO-8859-8)
Hebrew (Windows-1255)
Japanese (Shift_JIS)
Korean (KS_C_5601-1987)
Thai (TIS620)
Thai (Windows-874)
Turkish (ISO-8859-9)
Turkish (Windows-1254)
UTF 8 (UTF-8)
UTF 16 (UTF-16)
Western European (ISO-8859-1)
Western European (ISO-8859-15)
Western European (Windows-1252)
Locale encoding
No encoding conversion
| windows-1252 | | ## Bridge Mapping | **Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)** | **"SAP PowerDesigner CDM 6.x"
Metamodel
SybasePowerDesignerCdm06** | **Mapping Comments** | | --- | --- | --- | | | | | | **Association** | **Relationship** | | | Aggregation | Dependent | | | Description | Label + Description | | | DesignLevel | Generate Table | Set to LOGICAL\_ONLY if not checked | | Name | Name | | | PhysicalName | Code | | | **AssociationRole** | **Relationship** | | | DesignLevel | Generate Table | Set to LOGICAL\_ONLY if not checked | | Multiplicity | Cardinality minimum, Cardinality maximum | | | Name | Role | | | Source | | based on the multiplicity of each role | | **AssociationRoleNameMap** | **Relationship** | **The association between the primary key column and the foreign key column** | | **Attribute** | **Data Item, Entity Attribute** | | | Description | Label + Description | | | InitialValue | Check Parameter default | | | Name | Name | | | Optional | Mandatory | | | PhysicalName | Code | | | Position | | Order in the PowerDesigner file | | **BaseType** | **Domain, Attribute Datatype** | | | DataType | Data Type | See datatype conversion array | | Description | Label + Description | | | Length | Data Type Length | | | Name | Name | | | Scale | Data Type Precision | | | **CandidateKey** | **Entity Attribute (identifier property)** | | | UniqueKey | | True for Primary Key | | **Class** | **Entity** | | | CppClassType | | Set to ENTITY | | CppPersistent | | Set to True | | Description | Label + Description | | | DesignLevel | Generate Table | Set to LOGICAL\_ONLY if not checked | | Name | Name | | | PhysicalName | Code | | | **ClassDiagram** | **Submodel** | **A main class diagram "Main" will be created to contain all entities/references** | | Description | Label + Description | | | Name | Name | | | PhysicalName | Code | | | **DerivedType** | **Domain, Attribute Datatype, Check Parameter** | | | DataType | Data Type | See datatype conversion array | | Description | Label + Description | | | InitialValue | Check Parameter Default | | | Length | Data Type Length | | | LowerBound | Check Parameter Minimum | | | Name | Name | | | PhysicalName | Code | | | Scale | Data Type Precision | | | UpperBound | Check Parameter Maximum | | | **DesignPackage** | | **No equivalent in PowerDesigner. A main package "Logical View" will be created to contain all entities/references** | | **ForeignKey** | | **Based on Primary Key and association role** | | **Generalization** | **Inheritance** | | | Description | Label + Description | | | Name | Name | | | PhysicalName | Code | | | **GeneralizationRole** | **InheritanceLink** | | | **IndexMember** | | **Associated with each attribute in a key** | | Position | | Computed | | **StoreModel** | **Model** | | | Description | Label + Description | | | Name | Name | | | PhysicalName | Code | | | Name | Label/Value | | | **TypeValue** | **Check Parameter** | | | Name | Label/Value | | | Position | | Order in the PowerDesigner file | | Value | Value | |