SAP PowerDesigner PDM 6.1.x - Import - Cloud

Talend Cloud Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Catalog

Note: This bridge is not available in Talend Cloud Data Catalog by default. You need to set up a remote harvesting agent to import metadata from this source. For more information, see Deploying a remote harvesting agent in Talend Cloud Data Catalog Administration guide.

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
Remote Repository Browsing for Model Selection
Multi-Model Harvesting
Incremental Harvesting

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.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 http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html or bundled in Documentation/ReadMe/MIMBKnownLimitations.html

SUPPORT
Provide a trouble shooting 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 'Save as type' list, select 'Logical Data Model (XML) (*.LDM)'.
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  
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