SAP PowerDesigner PDM 8.x 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 PDM (Physical 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 (Physical Data Model), Graphical Layout via PDM XML File

Export tool: SAP PowerDesigner PDM (Physical Data Modeling) 8.0 to 16.x (https://www.sap.com/products/powerdesigner-data-modeling-tools.html)
Export interface: [Data Modeling] Data Store (Physical Data Model), Graphical Layout via PDM XML File to SAP PowerDesigner PDM 8.x to 16.x Export bridge: 'SybasePowerDesignerPdm' 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 Sybase Power Designer (PDM) file you want to generate.
ENUMERATED
8.0
9.0
9.5
10.0
11.0
12.0
15.0
16.0
16.5
16.5  
File The bridge generates a PDM 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 *.pdm   Mandatory
Target Database Specify the target database. 'Auto Detect' means that the bridge will try to auto-detect the target database from the originating model.

A database prefixed with a star (*) means it is only available for PowerDesigner 10 or newer.

A database prefixed with a double star (**) means it is only available for PowerDesigner 11 or newer.

A database prefixed with a triple star (***) means it is only available for PowerDesigner 12 or newer.

A database prefixed with a fourfold star (****) means it is only available for PowerDesigner 15 or newer.

A database prefixed with a fourfold star (*****) means it is only available for PowerDesigner 16 or newer.

A database prefixed with a fourfold star (******) means it is only available for PowerDesigner 16.5 or newer.
ENUMERATED
Auto Detect
Access 95
Access 2000
***** Access 2007
ADABAS D
ALLBASE/SQL G.1
ANSI Level 2
AS/400
****** Hadoop Hive 1.0
IBM DB2 UDB 5.x Common Server
IBM DB2 UDB 6.x Common Server
IBM DB2 UDB 7.x Common Server
* IBM DB2 UDB 8.x Common Server
**** IBM DB2 UDB 9.0 Common Server
***** IBM DB2 UDB 9.5 Common Server
***** IBM DB2 UDB 9.7 Common Server
****** IBM DB2 Version 10.x for Linux, UNIX, and Windows
IBM DB2 4.x for MVS/ESA
IBM DB2 5.x for OS/390
IBM DB2 UDB 6 for OS/390
IBM DB2 UDB 7 for OS/390
* IBM DB2 UDB 8 for OS/390
**** IBM DB2 Version 9.x for z/OS
***** IBM DB2 Version 10 for z/OS
****** IBM DB2 Version 11 for z/OS
****** IBM DB2 Version 12 for z/OS
INFORMIX SQL 7.x
INFORMIX SQL 8.x
INFORMIX SQL 9.x
***** INFORMIX SQL 10.x
***** INFORMIX SQL 11.x
InterBase 4.0
InterBase 5.x
InterBase 6.x
Microsoft SQL Server 6.x
Microsoft SQL Server 7.x
Microsoft SQL Server 2000
*** Microsoft SQL Server 2005
**** Microsoft SQL Server 2008
****** Microsoft SQL Server 2012
****** Microsoft SQL Server 2014
****** Microsoft SQL Server 2016
MySQL 3.22
MySQL 3.23
* MySQL 4
*** MySQL 5
***** Netezza 4.5
***** Netezza 5.0
****** Netezza 7.x
NonStop SQL
ODBC 3.0
ORACLE Version 7
ORACLE Version 8
ORACLE Version 8i (8.1.5)
ORACLE Version 8i2 (8.1.6)
* ORACLE Version 9i
* ORACLE Version 9i2
** ORACLE Version 10g
**** ORACLE Version 11g
****** ORACLE Version 12c
PostgreSQL 7
*** PostgreSQL 8
****** PostgreSQL 9.x
****** SAP HANA Database 1.0
Sybase AS Anywhere 6
Sybase AS Anywhere 7
* SAP SQL Anywhere 8
* SAP SQL Anywhere 9
**** SAP SQL Anywhere 10
**** SAP SQL Anywhere 11
***** SAP SQL Anywhere 12
****** SAP SQL Anywhere 16
****** SAP SQL Anywhere 17
SAP AS Enterprise 11.0
* SAP AS Enterprise 11.5-11.9
SAP AS Enterprise 12.0
* SAP AS Enterprise 12.5
* SAP AS Enterprise 12.5.1
*** SAP AS Enterprise 15.0
**** SAP AS Enterprise 15.0.2
***** SAP AS Enterprise 15.5
***** SAP AS Enterprise 15.7
****** SAP AS Enterprise 16.0
SAP AS IQ 12.0
* SAP AS IQ 12.4.3
* SAP AS IQ 12.5
** SAP AS IQ 12.6
**** SAP AS IQ 12.7
***** SAP IQ 15.0
***** SAP IQ 15.2
****** SAP IQ 15.3
****** SAP IQ 15.4
****** SAP IQ 16.0
Teradata
Teradata V2R5
**** Teradata V2R6
***** Teradata 12
***** Teradata 13
****** Teradata 14
****** Teradata 15
****** Teradata 16
Auto Detect  
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 PDM 8.x to 16.x"
Metamodel
SybasePowerDesignerPdm07
Mapping Comments
     
Association Reference  
Aggregation   .
Comment Comment  
Description Comment Mapped only if comment is empty.
ExtraConstraint   .
PhysicalName Code Diagram Physical Name.Computed from the Name if not set
AssociationRole Reference  
ExtraConstraint Update constraint, Delete constraint  
Multiplicity Cardinality  
AssociationRoleNameMap Attribute/Index  
Attribute Column  
Comment Comment  
Description Comment 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   The attributes are ordered by position in the PDM file
BaseType Domain, Attribute Data Type See DerivedType
CandidateKey Key  
Comment Comment  
Description Comment Mapped only if comment is empty.
PhysicalName Code Key Physical Name.Computed from the Name if not set
UniqueKey Primary Key The primary key will be referenced in the <PKey> tag.
Class Table  
Comment Comment  
Description Comment Mapped only if comment is empty.
DimensionalRole Dimensional Type  
PhysicalName Code Class Physical Name.Computed from the Name if not set
ClassDiagram Physical Diagram  
Comment Comment  
Description Comment  
Name Name  
PhysicalName Code  
DatabaseSchema User Tables and objects belonging to a User are linked to a schema
Comment Comment  
PhysicalName Code  
DerivedType Domain, Attribute Data Type  
Description Comment  
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.
ForeignKey Join  
Generalization Reference  
Comment Comment  
Description Comment  
PhysicalName Code Generalization Physical Name.Computed from the Name if not set
GeneralizationRole Reference  
Comment Comment  
Description Comment  
PhysicalName Code Generalization Physical Name.Computed from the Name if not set
Identity Identity Identity column
Comment Comment  
Description Comment Mapped only if comment is empty.
PhysicalName Code Index Physical Name.Computed from the Name if not set
Position   The index members are ordered by position in the PDM file
SortOrder Sort  
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  
SQLViewAssociation View Relationship  
SQLViewAttribute View Column  
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  
Comment Comment  
Description Comment Mapped only if comment is empty.
PhysicalName Code Model Physical Name.Computed from the Name if not set
StoredProcedure Stored Procedure  
Comment Comment  
Description Comment Mapped only if comment is empty.
Semantics Definition  
Trigger Trigger Create one trigger for each mode specified.
Comment Comment  
Description Comment Mapped only if comment is empty.
PhysicalName Code Trigger Physical Name.Computed from the Name if not set
Semantics Trigger Code  
TypeValue List of Values All the values are listed in one tag
Comment Comment  
Description Comment Mapped only if comment is empty.
Value Value