erwin 7.x Data Modeler - 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 erwin, Inc.
Tool Name erwin Data Modeler
Tool Version 7.x
Tool Web Site https://erwin.com/products/erwin-data-modeler/
Supported Methodology [Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout via COM API on Native (.erwin) or Export (.XML) File

Export tool: erwin, Inc. erwin Data Modeler 7.x (https://erwin.com/products/erwin-data-modeler/)
Export interface: [Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout via COM API on Native (.erwin) or Export (.XML) File to erwin 7.x Data Modeler Export bridge: 'CaErwin7Xml' 10.1.0

The bridge generates an erwin XML file.

EXPORTING TO erwin 7 DATA MODELER (erwin FORMAT)

This bridge relies on the erwin Data Modeler COM/OLE API to export erwin metadata files. Therefore, erwin 7 Data Modeler must be properly installed on the machine executing this bridge.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File This bridge generates either an .XML or .erwin (native erwin) file.
The bridge determines which format based upon the extension of the file name in this bridge parameter.

In order to load the converted .XML model in erwin:

1. Choose 'Open' from the File menu.
2. In the 'List files of type' list box select XML Files (*.xml).
3. Locate the drive and the folder that contains the file you want to open.
- Double-click on the folders 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
*.xml
*.erwin
  Mandatory
Version Specify here the version of erwin to generate the data model for.

When generating an erwin 7 binary file (*.erwin), this version of the software must be installed locally.

When generating an erwin 7 xml file (*.xml), any version can be generated for use on the local or a remote computer.
ENUMERATED
Latest
7.3
7.2
7.1
7.0
Latest  
Design level Specify here the design level of the data model to generate.

'Logical only' : will generate a logical data model

'Physical only' : will generate a physical data model

'Logical & physical' : will generate a logical and physical data model

The default value for this option is 'Logical & physical'
ENUMERATED
Logical & physical
Logical only
Physical only
Logical & physical  
Target database Specify the target database. 'Auto Detect' means that the bridge will try to auto-detect the target database from the originating model. ENUMERATED
Auto Detect
Access 2000
Advantage Ingres 2.5
Advantage Ingres 2.6
Advantage Ingres r3
DB2/390 7
DB2/390 8
DB2/zOS 9
DB2/UDB 8.1
DB2/UDB 9
DB2 iSeries 4.x/5.x
FoxPro
Informix 7.x
Informix 9.2/9.3
MySQL 5.x
ODBC/Generic 2.0
ODBC/Generic 3.0
Oracle 8i
Oracle 9.x
Oracle 10.x
Oracle 11.x
Progress 8.x
Progress 9.x
Red Brick 5.x
SAS
SQL Server 7.0
SQL Server 2000
SQL Server 2005
SQL Server 2008
Sybase 12.5
Sybase 15
Sybase IQ 12.5
Teradata 2.x
Teradata 12
Auto Detect  
Export dimensional properties This option enables the dimensional modeling features of erwin for this model and exports the dimensional role (Fact, Dimension, Outrigger) and dimensional type (fixed vs slowly changing) of the tables. BOOLEAN   False  
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      
Validate XML Specify here if the generated XML file should be validated against the erwin XML Schema before it is converted to the *.erwin binary format.
This parameter is only used when generating a *.erwin binary file.
When generating an erwin XML file only, no validation is performed.
This parameter should be set to 'True' for most common usages.
BOOLEAN   True  
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)
"erwin 7.x Data Modeler"
Metamodel
CaErwin7Xml
Mapping Comments
     
Association Relationship  
Aggregation Identifying/ Non Identifying  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name Computed if not set
PhysicalName Physical_Name Foreign Key Constraint Name
AssociationRole Relationship  
DesignLevel Logical Only, Physical Only  
ExtraConstraint Delete, Insert, Update Rule  
Multiplicity Cardinality or Relationship_No_Nulls  
Name Child_To_Parent_Phrase or Name  
Source   Based on the multiplicity of each role and the Identifying/Non Identifying property
AssociationRoleNameMap Attribute/Index Used to connect the attributes involved in a Relationship
Attribute Attribute/Column  
Comment Comment  
Description Definition  
DesignLevel Logical Only, Physical Only  
ExtraConstraint Validation_Rule_Ref if the validation rule cannot be set on the type
Name Name  
Optional Null Option  
PhysicalName Physical_Name  
Position Order, Physical_Order  
BaseType Domain, Attribute Data Type No equivalent, We create the 5 base types Erwin requires
BusinessRule Default Values, Validation Rules  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
LowerBound Validation_Rule_Min_Value  
Name Name  
PhysicalName Physical_Name  
UpperBound Validation_Rule_Max_Value  
CandidateKey Key Group/Index (non Foreign Key)  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name  
PhysicalName Physical_Name if set by the user
UniqueKey   Create an Inversion Entry if uniqueKey is false
Class Entity/Table  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
DimensionalRole Dimensional Modeling Role  
DimensionalType Dimension Type  
Name Name  
PhysicalName Physical Name  
ClassDiagram Subject Area  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name  
DatabaseSchema Owner Table, View or Index owner
DesignLevel Logical_Only, Physical_Only  
Name Name  
DerivedType Domain, Attribute Data Type  
Comment Domain_Comment  
DataType Datatype See datatype conversion arrays
Description Domain_Definition  
InitialValue Default and Default_Value imported from the Not Mapped value tag associated to this type
Length Datatype  
Name Name  
PhysicalName Physical_Domain_Name Mapped only if the Model is generated as Physical Only
Scale Datatype  
UserDefined   Mapped as a Domain only if it is user defined
ForeignKey Key Group/Index (Foreign Key)  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name  
PhysicalName Physical_Name if set by the user
Generalization Supertype/Subtype  
DesignLevel Logical_Only, Physical_Only set to Logical Only if a transformation is created
Name Name Computed.
GeneralizationRole Supertype/Subtype Relationship  
Identity Sequence, Identity properties  
Cycle Cycle  
IncrementValue Increment By  
MaximumValue Maximum Value  
MinimumValue Minimum Value  
StartValue Starting Value  
Index Key Group/Index  
Clustered Index Clustered  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name  
PhysicalName Physical_Name  
IndexMember Key Group Member/Index Member  
DesignLevel Logical_Only, Physical_Only  
Name Name  
Position Key Group Member Position  
SortOrder Key_Group_Sort_Order  
Note Note  
Value   note value
Projection Drawing Object Graphical Information
BackgroundColor fill color  
FontColor font color  
Height height  
LineColor outline color  
Width width  
X x  
Y y  
PropertyElementTypeScope User Defined Property  
Scope UDP Class  
PropertyType User Defined Property  
DataType Type  
Description Description  
DesignLevel   UDP design level: Logical and/or Physical
InitialValue Default value  
Name Name  
NativeId   Object id
PhysicalName   Not used
Position position  
Usage   set to User
PropertyValue User Defined Property used for UDP values and column physical information specific to Teradata: COMPRESS, CASE and FORMAT
Value Value value set on an object
RelationshipProjection Drawing Object Graphical Information
BackgroundColor fill color  
FontColor font color  
LineColor outline color  
LinePoints relationship path  
X x relationship mid point
Y y relationship mid point
SQLViewAssociation View Relationship  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name Computed if needed
PhysicalName Physical_Name  
SQLTableSequence Relationship Sequence  
SQLViewAttribute View Column  
Comment Comment  
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name  
PhysicalName Physical_Name  
Position Order  
SQLViewEntity View Table View Entity
Comment Comment No equivalent, (Erwin fails to import)
Description Definition  
DesignLevel Logical_Only, Physical_Only  
Name Name  
PhysicalName Physical_Name  
WhereClause View SQL or Where clause  
Sequence Sequence  
DataType Datatype  
Length Datatype  
Name name  
NativeDataType Datatype  
Scale Datatype  
Shape Shape, Text Box  
BackgroundColor Fill Color  
Bold Font Bold  
FontColor Font Color  
FontName Font  
FontSize Font Size  
Height   Used to provide placement information
Italic Font Italic  
LineColor Line Color Object outline color
Name Name Object name as stored in MIR model
ShapeType   Type of the drawing object correspopnding to the Drawing Objects palette
Strike Font Strikeout  
Underline Font Underline  
X   Used to provide placement information
Y   Used to provide placement information
Z   Z-order of the object
StoreModel Model/Diagram The model is built using the elements contained in the ERwin file
Description Definition optional: UDP values can be added to the description
DesignLevel Logical_Only, Physical_Only  
Name Name Model Name
SystemType Target Server  
SystemTypeOld Target Server  
StoredProcedure Stored Procedure  
Comment Comment  
Description   optional: UDP values can be added to the description
DesignLevel Logical_Only, Physical_Only  
Name Name  
Semantics Template_Code  
Trigger Trigger Table Trigger
Comment Comment  
Name Name  
Semantics Trigger_Body  
TriggerType Trigger_Fire  
TypeValue Validation Rule  
Name Name  
Position Order  
Value Definition