SAP PowerDesigner CDM 8.0 to 16.x - Export - 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 8.0 to 16.x
Tool Web Site https://www.sap.com/products/powerdesigner-data-modeling-tools.html
Supported Methodology [Data Modeling] Data Store (Logical Data Model), Graphical Layout via CDM XML File

Export tool: SAP PowerDesigner CDM (Conceptual Data Modeling) 8.0 to 16.x (https://www.sap.com/products/powerdesigner-data-modeling-tools.html)
Export interface: [Data Modeling] Data Store (Logical Data Model), Graphical Layout via CDM XML File to SAP PowerDesigner CDM 8.0 to 16.x Export bridge: 'SybasePowerDesignerCdm' 10.1.0

FREQUENTLY ASKED QUESTIONS

Q: All the symbols are in the center of the screen,what can I do?
A: In the tool, select 'Symbol->Auto-Layout', it will redraw the current diagram. Note that you will have to do this for each diagram.

Q: Some symbols seem to be missing, what can I do?
A: In the tool, select 'Tools->Complete Links', it will draw the missing symbols. Note that you will have to do this for each diagram.


Bridge Parameters

Parameter Name Description Type Values Default Scope
Version Select here the version of SAP Power Designer (CDM) file you want to generate. ENUMERATED
8.0
9.0
9.5
10.0
11.0
12.0
15.0
16.0
16.0  
File The bridge generates a CDM file.

In order to load the converted model, start PowerDesigner and:

1. Choose 'Open' from the File menu.

2. In the 'List files of type' list box select PowerDesigner Files.

3. Locate the drive and the folder that contains the file you want to open. Double-click on a folder in the Folders list to switch to a different folder. If necessary, switch to a different drive by selecting a drive from the Drives list.

4. Locate the file you want to open. Type the name of the file in the 'File Name' text box or select it from the File Name list.

5. Click 'Open'.
FILE *.cdm   Mandatory
Description Specify how to export the Description and Comment properties in PowerDesigner.

'Comment & Description' - Export the comment property to the PowerDesigner comment field and the description property to the PowerDesigner description field. This is the default.

'Comment' - Export the comment property (or the description property, if any), to the PowerDesigner comment field.

'Notes/Description' - Export the comment property (or the description property, if any), to the PowerDesigner description field.
ENUMERATED
Comment & Description
Comment
Notes/Description
Comment & Description  
XML Indentation (pretty printing) This option controls the pretty printing of the XML, for the purpose of opening the generated file in a text editor.

For example, specify here a tabulation character, or some space characters.

By default, there is no indentation which leads to a more compact file.
STRING      
Reverse role names This option tells the bridge to swap the rolenames for each relationship in the model.

'False' - Do not reverse rolenames. This is the default.

'True' - Reverse rolenames.
BOOLEAN   False  
Connection Allows selecting a connection by name, if the source model contains multiple database connections.
If the source model contains multiple connections and this parameter value is left empty, the connection with the most objects is selected.
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"SAP PowerDesigner CDM 8.0 to 16.x"
Metamodel
SybasePowerDesignerCdm07
Mapping Comments
     
Association Relationship Association is moved if not in the same package as its classes.
Aggregation Dependent  
Comment   .
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
ExtraConstraint   .
Name Name Diagram Name. Computed if not set
NativeId   .
PhysicalName Code Diagram Physical Name.Computed from the Name if not set
Stereotype   .
AssociationRole Relationship  
Comment   .
CppContainment   .
CppFriend   .
CppScope   .
CppStatic   .
DesignLevel   No equivalent for Physical Only objects.
ExtraConstraint   .
Multiplicity Cardinality  
Name Role name  
NativeId   .
Navigable   .
Ordered   .
Source Dependent  
Stereotype   .
Attribute Attribute/Data Item  
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
ExtraConstraint Business Rule  
Name Name Attribute Name. Computed if not set
Optional Mandatory  
PhysicalName Code Attribute Physical Name.Computed from the Name if not set
Position   The attributes are ordered by position in the CDM file
BaseType Domain, Attribute Data Type See DerivedType
CandidateKey Identifier/Primary Identifier  
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Name Name Key Name. Computed if not set
PhysicalName Code Key Physical Name.Computed from the Name if not set
UniqueKey   Only unique candidate keys are exported.
Class Entity  
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Name Name Class Name. Computed if not set
PhysicalName Code Class Physical Name.Computed from the Name if not set
ClassDiagram Conceptual Diagram  
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Name Name  
PhysicalName Code Diagram Physical Name.Computed from the Name if not set
DerivedType Domain, Attribute Data Type  
DataType Data type See datatype conversion array
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Length Length  
LowerBound Minimum  
Name Name Type Name. Computed if not set
PhysicalName Code Type Physical Name.Computed from the Name if not set
Scale Precision  
UpperBound Maximum  
DesignPackage Package  
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Name Name Package Name. Computed if not set
PhysicalName Code Package Physical Name.Computed from the Name if not set
Generalization Inheritance Generalization is duplicated if its subtypes are not in its package.
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Name Name Generalization Name. Computed if not set
PhysicalName Code Generalization Physical Name.Computed from the Name if not set
GeneralizationRole InheritanceLink  
Note Annotation  
Projection Symbol Graphical Information
BackgroundColor fill color  
FontColor font color  
Height height  
LineColor line color  
Width width  
X x  
Y y  
RelationshipProjection Symbol Graphical Information
FontColor font color  
LineColor line color  
StoreModel Model  
Description Comment  
DesignLevel   No equivalent for Physical Only objects.
Name Name Model Name. Computed if not set
PhysicalName Code Model Physical Name.Computed from the Name if not set
Name Label  
TypeValue List of Values All the values are listed in one tag
DesignLevel   No equivalent for Physical Only objects.
Name Label  
Position   TypeValues are ordered by position in the CDM file
Value Value