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

SPECIFICATIONS
Tool: SAP / PowerDesigner CDM (Conceptual Data Modeling) version 6.1.x via (Data Modeling) Logical only CDM Export File
See https://www.sap.com/products/powerdesigner-data-modeling-tools.html
Metadata: [Data Modeling] Data Store (Logical Data Model)
Component: SybasePowerDesignerCdm06 version 11.0.0

OVERVIEW
This bridge imports data models from a PowerDesigner .CDM (Conceptual data model) file with Entities, Attributes, Domains. 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 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 and browse to select a specific directory.
3. Click 'OK'.

This bridge will use the generated CDM file as input.
FILE *.cdm   Mandatory
Encoding Specifies the character set encoding of the model to be imported.

If there are multiple choices for a language, the actual encoding will be 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 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