SAP PowerDesigner CDM 8.0 to 16.x - Export - 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 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

SPECIFICATIONS
Tool: SAP / PowerDesigner CDM (Conceptual Data Modeling) version 8.0 to 16.x via CDM XML File
See https://www.sap.com/products/powerdesigner-data-modeling-tools.html
Metadata: [Data Modeling] Data Store (Logical Data Model), Graphical Layout
Component: SybasePowerDesignerCdm version 11.0.0

OVERVIEW
This bridge generates a PowerDesigner .CDM (Conceptual data model) file with entities, attributes, domains, relationships and their implementation (e.g. PK/FK) as well as the graphical layout (diagrams).

REQUIREMENTS
n/a

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.

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
Version The version of SAP Power Designer (CDM) file to generate. ENUMERATED
8.0
9.0
9.5
10.0
11.0
12.0
15.0
16.0
16.0  
File The path name of the generated 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. Browse to the generated CDM file and select it from the file name list.
4. Click 'Open'.
FILE *.cdm   Mandatory
Description 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.

'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) Controls the pretty printing of XML, for the purpose of opening the generated file in a text editor. E.g.

'space characters'
Several space characters as indentation.

'tab key'
Tab character as indentation.

'empty'
No indentation which leads to a more compact file.
STRING      
Reverse role names Swap relationship rolenames for each model:

'False'
Do not swap rolenames.

'True'
Swap 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