SAP PowerDesigner CDM 6.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 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
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: SAP PowerDesigner CDM (Conceptual Data Modeling) 6.1.x (https://www.sap.com/products/powerdesigner-data-modeling-tools.html)
Import interface: [Data Modeling] Data Store (Logical Data Model) via (Data Modeling) Logical only CDM Export File from SAP PowerDesigner CDM 6.x Import bridge: 'SybasePowerDesignerCdm06' 10.1.0

Please enter a description


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 for the model you are saving in the 'File Name' text box. Browse to select a specific directory.
3. Click 'OK'.

The bridge will use the generated CDM file as input.
FILE *.cdm   Mandatory
Encoding Specifies the character set encoding of the model to be imported or exported:
If there are multiple choices for a language, the actual encoding will be indicated between parentheses.
The default is 'Western European (Windows 1252)' on Windows 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 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