SAP PowerDesigner PDM 6.1.x - Import - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

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

Import tool: SAP PowerDesigner PDM (Physical Data Modeling) 6.1.x (https://www.sap.com/products/powerdesigner-data-modeling-tools.html)
Import interface: [Data Modeling] Data Store (Physical Data Model, Stored Procedure Expression Parsing) via PDM Export File from SAP PowerDesigner PDM 6.1.x Import bridge: 'SybasePowerDesignerPdm06' 10.1.0

Please enter a description


Bridge Parameters

Parameter Name Description Type Values Default Scope
File The bridge imports metadata from a PDM file. To create a PDM file for import:
1. Open a physical data model in SAP PowerDesigner DataArchitect.
2. Choose File -> Save/Save As.
3. In the 'File Name' text box, enter the file name for the model, and select a directory to save the file in.
4. Click OK.
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.
'True' - import disconnected objects and place them in the main package
'False' - ignore disconnected objects (default)
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. The defaults are 'Western European (Windows 1252)' on Windows platforms and 'Western European (ISO 8859-1)' on other platforms. 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