# SAP PowerDesigner PDM 6.1.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 PDM (Physical 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 (Physical Data Model, Stored Procedure Expression Parsing) via PDM Export File | | **Data Profiling** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/Cloud/Content/Resources/images/cross.png) | | **Incremental Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/Cloud/Content/Resources/images/cross.png) | | **Multi-Model Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/Cloud/Content/Resources/images/cross.png) | | **Remote Repository Browsing for Model Selection** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/Cloud/Content/Resources/images/cross.png) | **SPECIFICATIONS** **Tool:** SAP / PowerDesigner PDM (Physical Data Modeling) version 6.1.x via PDM Export File See https://www.sap.com/products/powerdesigner-data-modeling-tools.html **Metadata:** [Data Modeling] Data Store (Physical Data Model, Stored Procedure Expression Parsing) **Component:** SybasePowerDesignerPdm06 version 12.0.0 **OVERVIEW** This bridge imports data models from a PowerDesigner .PDM (physical data model) file with Tables, Columns, Data Types. 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/Cloud/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** | | --- | --- | --- | --- | --- | --- | | **File** | Imports PDM file. If you do not have the model saved as an PDM file already:

1. Open a physical data model in SAP PowerDesigner DataArchitect.

2. Choose 'Save As' from the 'File' menu.

3. In the 'Files of type' list, select 'PDM Model (\*.pdm)'.

4. Enter the file name and select a directory to save the file in.

5. Click 'Save'. | FILE |
*.pdm
*.wam
| | Mandatory | | **Import disconnected objects** | In PowerDesigner you can delete the symbol that represents an object in a view without deleting the object itself. As a result, a model might contain 'invisible' objects (for example, tables or references) that are inconsistent with other objects. Import disconnected objects and place them in the main package:



'True'



'False'

Ignore disconnected objects. | BOOLEAN |
False
True
| False | | | **Encoding** | Select the character set encoding of the model to be imported. If there are multiple choices for a language, the actual encoding is 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 PDM 6.1.x"
Metamodel
SybasePowerDesignerPdm06** | **Mapping Comments** | | --- | --- | --- | | | | | | **Association** | **Reference** | | | Aggregation | | Based on attributes belonging both to a primary key and a foreign key associated with the association | | Description | Label + Description | Label + Description | | ExtraConstraint | | . | | PhysicalName | Code | Diagram Physical Name.Computed from the Name if not set | | **AssociationRole** | **Reference** | | | ExtraConstraint | Update constraint, Delete constraint | | | Multiplicity | Cardinality minimum, Cardinality maximum | 1-1 for the child Role | | PhysicalName | Code | For the parent Role only | | Source | | based on the multiplicity of each role | | **Attribute** | **Column, Check Parameter** | | | Description | Label + Description | Mapped only if comment is empty. | | DesignLevel | | . | | ExtraConstraint | Business Rule | | | Optional | Mandatory | | | PhysicalName | Code | Attribute Physical Name.Computed from the Name if not set | | Position | Position | The attributes are ordered by position in the PDM file | | **BaseType** | **Domain, Attribute Data Type** | **See DerivedType** | | DataType | Data Type | See datatype conversion array | | Length | Length | | | PhysicalName | Code | | | Scale | Precision | | | **CandidateKey** | **Index (Primary Key), Alternate Key** | | | Comment | Comment | | | Description | Label + Description | Mapped only if comment is empty. | | PhysicalName | Code | Key Physical Name.Computed from the Name if not set | | UniqueKey | Unique | | | **Class** | **Table** | | | Comment | Comment | | | CppClassType | | Set to ENTITY | | CppPersistent | | Set to True | | Description | Comment | Mapped only if comment is empty. | | PhysicalName | Code | Class Physical Name.Computed from the Name if not set | | **ClassDiagram** | **Diagram, SubModel** | | | Description | Label + Description | | | Name | Name | | | PhysicalName | Code | | | **DerivedType** | **Domain, Attribute Datatype, Check Parameter** | | | Description | Label + Description | | | InitialValue | Check Parameter Default | | | Length | Length | | | LowerBound | Minimum | | | PhysicalName | Code | Type Physical Name.Computed from the Name if not set | | Scale | Precision | | | UpperBound | Maximum | | | UserDataType | Data type | See datatype conversion array | | UserDefined | | Only user defined types are mapped to domain. | | **DesignPackage** | | **No equivalent in PowerDesigner. A main package "Logical View" will be created to contain all entities/references** | | **ForeignKey** | **Index (Foreign Key)** | | | Description | Label + Description | | | PhysicalName | Code | | | **Index** | **Index** | | | Comment | Comment | | | Description | Comment | Mapped only if comment is empty. | | PhysicalName | Code | Index Physical Name.Computed from the Name if not set | | **IndexMember** | | **Associated with each attribute in a key** | | Position | Position | | | SortOrder | Sort | | | **Note** | **Annotation** | | | **SQLViewAssociation** | **View (selected Tables)** | **For non User Defined View** | | **SQLViewAttribute** | | **Not mapped (embeded in the sqlTableWhereClause)** | | Expression | SQL Query | The expression is put in the SQL field of the SQLViewEntity. | | Position | | The attributes are ordered by position in the PDM file | | **SQLViewEntity** | **View** | **Views might be inconsistent if objects have been renamed.** | | Comment | Comment | | | Description | Comment | Mapped only if comment is empty. | | PhysicalName | Code | View Physical Name.Computed from the Name if not set | | WhereClause | SQL Query | | | **StoreModel** | **Model** | | | Description | Label + Description | Mapped only if comment is empty. | | PhysicalName | Code | Model Physical Name.Computed from the Name if not set | | **TypeValue** | **List of Values, Check Parameter** | **All the values are listed in one tag** | | Comment | Comment | | | Description | Comment | Mapped only if comment is empty. | | Position | | Order in the PowerDesigner file | | Value | Value | |