SAP PowerDesigner CDM 6.x - Import
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
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 |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
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.2.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 MIMB Known Limitations or bundled in Documentation/ReadMe/MIMBKnownLimitations.html
SUPPORT
Provide a troubleshooting 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 |
|
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 |