IBM Rational Rose 7.x (2000e and newer) - 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 IBM
Tool Name Rational Rose
Tool Version 7.x (2000e and newer)
Tool Web Site http://www.ibm.com/software/awdtools/developer/rose/
Supported Methodology [Object Modeling] Data Store (Object Model UML Class Diagrams, Physical Data Model, Stored Procedure Expression Parsing), Graphical Layout via MDL File

SPECIFICATIONS
Tool: IBM / Rational Rose version 7.x (2000e and newer) via MDL File
See http://www.ibm.com/software/awdtools/developer/rose/
Metadata: [Object Modeling] Data Store (Object Model UML Class Diagrams, Physical Data Model, Stored Procedure Expression Parsing), Graphical Layout
Component: IbmRationalRoseDm version 11.0.0

OVERVIEW
This bridge generates a IBM Rose Data Model file.

REQUIREMENTS
n/a

FREQUENTLY ASKED QUESTIONS
n/a

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
File Generates a Rational Rose native MDL file. To load the converted model:

1. 'Open' from the 'File' menu of Rational Rose Data Modeler.
2. Navigate to the file you want to open.
3. Select the Class diagram you want to display.
4. Choose 'Layout Diagram' from the 'Format' menu.
5. Choose 'Autosize all' from the 'Format' menu.
FILE *.mdl   Mandatory
Select object model data types Import attribute or argument types:

'Rose C++'

'Rose Java'

'Rose Data Modeler'
ENUMERATED
Rose C++
Rose Java
Rose Data Modeler
Rose Data Modeler  
Select object and/or data models Specify if the imported model will contain:

'Object model only'

'Data model only'

'Object model and data model'
ENUMERATED
Object model and data model
Data model only
Object model only
Object model and data model  
Select data model target database The target database that will be used for the data model.

'Auto detect'
Auto-detect the target database from the originating model.
ENUMERATED
Auto detect
ANSI SQL 92
IBM DB2 5.x
IBM DB2 6.x
IBM DB2 OS390 5.x
IBM DB2 OS390 6.x
Microsoft SQL Server 6.x
Microsoft SQL Server 7.x
Oracle 7.x
Oracle 8.x
Sybase Adaptive Server 12.x
Auto detect  
Export Foreign key attributes Export Foreign key attributes:

'True'

'False'
The Foreign key attribute will not be created.
BOOLEAN   False  
Generate Qualifiers (for object model only) Generate qualifier to represent Foreign key attributes.

'True'
Superseeds the 'Export Foreign key attributes' option.

'False'
BOOLEAN   False  
Show constraint in diagram Show Association and Association Role constraints in diagram. BOOLEAN   False  
Use graphical information Use the graphical information when available to display the classes. BOOLEAN   True  
X Scale (in %) for object model diagram When graphical information is imported from another tool, it may be useful to adjust the scale of diagrams to better suit the destination tool diagramming conventions.

Controls the horizontal scaling (by percentage) applied to X coordinates in diagrams.

The default value is 100% (i.e no change), 200% doubles the size, 50% halves the size.
NUMERIC   100  
Y Scale (in %) for object model diagram When graphical information is imported from another tool, it may be useful to adjust the scale of diagrams to better suit the destination tool diagramming conventions.

Controls the vertical scaling (by percentage) applied to Y coordinates in diagrams.

The default value is 100% (i.e no change), 200% doubles the size, 50% halves the size.
NUMERIC   100  
X Scale (in %) for data model diagram When graphical information is imported from another tool, it may be useful to adjust the scale of diagrams to better suit the destination tool diagramming conventions.

Controls the horizontal scaling (by percentage) applied to X coordinates in diagrams.

The default value is 100% (i.e no change), 200% doubles the size, 50% halves the size.
NUMERIC   100  
Y Scale (in %) for data model diagram When graphical information is imported from another tool, it may be useful to adjust the scale of diagrams to better suit the destination tool diagramming conventions.

Controls the vertical scaling (by percentage) applied to Y coordinates in diagrams.

The default value is 100% (i.e no change), 200% doubles the size, 50% halves the size.
NUMERIC   100  
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.
BOOLEAN   True  
Export graphical information By default, this bridge will create graphical information for all the objects.
When exporting large models, in order to reduce the size of the generated model do not export the graphical information.
BOOLEAN   True  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"IBM Rational Rose 7.x (2000e and newer)"
Metamodel
IbmRationalRoseDm
Mapping Comments
     
Name Name  
Argument Parameter Parameters of Stored Procedures are mapped
DefaultValue Default Value  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Kind Direction  
Name Name  
Position Ordinal  
Association Relationship n-ary associations are not mapped. `many to many' associations are not mapped.
Aggregation Type Identifying/Non-Identifying
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name   Not mapped unless Physical name is empty
PhysicalName Name  
Stereotype Stereotype  
AssociationRole Relationship  
DesignLevel   No equivalent for Logical Only objects in the schema.
ExtraConstraint Referential IntegrityConstraint  
Multiplicity Cardinality  
Name   Not mapped unless Physical name is empty
PhysicalName Parent/Child Role  
Source Parent/Child  
Attribute Column, Check Constraint  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
ExtraConstraint Check Constraint Check Constraint on Table
InitialValue Default Value  
Name   Not mapped unless Physical name is empty
Optional Not Null  
PhysicalName Name  
Position Ordinal  
BaseType Column, Check Constraint  
DataType Datatype See datatype conversion array
DesignLevel   No equivalent for Logical Only objects in the schema.
Length Length/Precision  
Scale Scale  
CandidateKey Key Constraint  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name   Not mapped unless Physical name is empty
PhysicalName Name  
UniqueKey Type "Unique Constraint" if true, "Index" otherwise
Class Table  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name   Not mapped unless Physical name is empty
PhysicalName Name  
ClassDiagram Data Model Diagram  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name Name  
DatabaseSchema Schema All Model Elements are exported in their respective Schema. If they do not have a Schema, they are exported in a default Schema.
DesignLevel   No equivalent for Logical Only objects in the schema.
Name Name  
PhysicalName   No equivalent for Logical Only objects in the schema.
DerivedType Domain, Column, Check Constraint The hierarchy of type is not reproduced
Comment Comment  
DataType Datatype See datatype conversion array
DesignLevel   No equivalent for Logical Only objects in the schema.
InitialValue Default Value  
Length Length/Precision  
LowerBound Check Constraint BETWEEN or >= statement
Name Domain Name  
Scale Scale  
UpperBound Check Constraint BETWEEN or <= statement
UserDefined   mapped to Domain if true, mapped to attribute properties otherwise
DesignPackage   A main package "Logical View" is created if it doesn't exist.
DesignLevel   No equivalent for Logical Only objects in the schema.
ForeignKey Key Constraint Type is set to "Foreign Key Constraint"
Comment Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name   Not mapped unless Physical name is empty
PhysicalName Name  
Index Key Constraint If connected to a Key
Clustered Clustered  
DesignLevel   No equivalent for Logical Only objects in the schema.
IndexMember Key Constraint  
DesignLevel   No equivalent for Logical Only objects in the schema.
Position   Order in the file
Projection ClassView Graphical information
BackgroundColor fill color  
FontColor font color  
FontName font  
FontSize font size  
Height height  
Width width  
X x  
Y y  
PropertyElementTypeScope Type Type of a Model Property
Scope Type  
PropertyType Model Property  
Description   Not used
DesignLevel   No equivalent for Logical Only objects in the schema.
Group   Not used
Name Name  
PhysicalName   Not used
Position   Order in the file
Usage   Not used
RelationshipProjection AssociationView Graphical information
LineColor line color  
LinePoints Vertices  
X x  
Y y  
SQLViewAssociation Dependancy  
Description Documentation  
DesignLevel   No equivalent for Logical Only objects in the schema.
PhysicalName Name  
SQLViewAttribute Attribute  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Expression Type  
PhysicalName Name  
Position   Order in the file
SQLViewEntity Class Stereotype is set to "View"
Description Documentation  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name   Not mapped unless Physical name is empty
PhysicalName Name  
WhereClause SelectClause Generated if it not a "CREATE VIEW" statement
DesignLevel   No equivalent for Logical Only objects in the schema.
Name Name  
StoredProcedure Stored Procedure  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
Name   Not mapped unless Physical name is empty
PhysicalName Name  
Semantics Action Body  
Trigger Trigger  
Description Comment  
DesignLevel   No equivalent for Logical Only objects in the schema.
FireOnDelete Trigger Event  
FireOnInsert Trigger Event  
FireOnUpdate Trigger Event  
Name   Not mapped unless Physical name is empty
PhysicalName Name  
Semantics Action Body  
TriggerType Trigger Type  
TypeValue Check Constraint The check constraint is applied to the Table
DesignLevel   No equivalent for Logical Only objects in the schema.
Position   Order in the IN statement
Value Value Value of each field in the IN statement