SAP PowerDesigner PDM 6.1.x - Import
Availability-note
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 |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
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 11.2.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
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 |
|
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 | |||||||||||||||||||||||||||
| 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 |
|
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 |