Grandite Silverrun-RDM 2.4.4 to 2.8.6 - Import - 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 Grandite (Silverrun)
Tool Name Silverrun-RDM
Tool Version 2.4.4 to 2.8.6
Tool Web Site http://www.silverrun.com/rdm.html
Supported Methodology [Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing) via TXT Export File
Data Profiling
Remote Repository Browsing for Model Selection
Incremental Harvesting
Multi-Model Harvesting

SPECIFICATIONS
Tool: Grandite (Silverrun) / Silverrun-RDM version 2.4.4 to 2.8.6 via TXT Export File
See http://www.silverrun.com/rdm.html
Metadata: [Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing)
Component: SilverrunRdm version 11.0.0

OVERVIEW
This bridge imports a relational data model from Silverrun RDM in TXT file format.

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
Version Select here the version of Silverrun RDM you want to use. ENUMERATED
2.8.4/2.8.5
2.7.2
2.6.2
2.4.4
2.8.4/2.8.5  
Role Name Location Silverrun is a data modeling tool intended to be used with ER Methodology/Notation.
The following example assumes an entity A called "Car", and entity B called "Person" connected with an "AB" relationship called "Ownership"

Link Origin (ER Modeling Style)" (DEFAULT VALUE) means:
- The "AtoB" role name is located on the source (close to "A")
- The "AtoB" role name is supposed to be a "verb" qualifying the role from entity "A", causing the AtoB role name to be next the source A object.

Link Destination (UML Modeling Style):
- The "AtoB" role name is located on the destination (close to "B")
- The "AtoB" role name is supposed to be a "noun" qualifying the entity "B", causing the AtoB role name is next the destination B object.
ENUMERATED
Link Origin (ER Modeling Style)
Link Destination (UML Modeling Style)
Link Origin (ER Modeling Style)  
File When a model is currently loaded in Silverrun RDM 2.4.4:
1. Choose 'Import-Export' from the 'Util' menu.
2. Choose 'Export' from the created 'Import-Export' menu.
3. Type the file name for the model you are saving in the 'File Name' text box. Press the browse button to select a specific directory.
4. Click 'Save'.

When a model is currently loaded in Silverrun RDM 2.6.2 or 2.8.4:
1. Choose 'Import-Export' from the 'File' menu.
2. On the created 'Transfer Parameters' dialog box, choose 'Export' from the 'File' menu.
3. Type the file name for the model you are saving in the 'File Name' text box. Press the browse button to select a specific directory.
4. Click 'Save'.

The bridge will use the generated TXT file as input.

Please do not change the settings for 'Separators' and 'Transfer Content'.
The bridge relies on default settings to import the generated TXT file.
FILE *.txt   Mandatory
Open Mode By default the file will open in Binary mode on Windows. Depending on your version of Silverrun or the way you export the data from the tool, you may need to instruct the bridge to open the file in Text mode. ENUMERATED
Binary
Text
Binary  
Encoding Specifies the character set encoding of the model to be imported or exported. If there are multiple choices for a language, the actual encoding will be indicated between parentheses. ENUMERATED
Central and Eastern European (iso-8859-2)
Central and Eastern European (windows-1250)
Chinese Traditional (big5)
Chinese Simplified (GB18030)
Chinese Simplified (GB2312)
Cyrillic (iso-8859-5)
Cyrillic (windows-1251)
DOS (ibm-850)
Greek (iso-8859-7)
Greek (windows-1253)
Hebrew (iso-8859-8)
Hebrew (windows-1255)
Japanese (shift_jis)
Korean (ks_c_5601-1987)
Thai (TIS620)
Thai (windows-874)
Turkish (iso-8859-9)
Turkish (windows-1254)
UTF 8 (utf-8)
UTF 16 (utf-16)
Western European (iso-8859-1)
Western European (iso-8859-15)
Western European (windows-1252)
Locale encoding
No encoding conversion
windows-1252  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Grandite Silverrun-RDM 2.4.4 to 2.8.6"
Metamodel
SilverrunRdm
Mapping Comments
     
Association Connector  
Aggregation   Based on the cardinality of the role
Description Comment  
ExtraConstraint Delete, Update, Insert Rule  
Name Name  
PhysicalName Coded Name  
AssociationRole Direction  
Description Comment  
Multiplicity Minimum Connectivity, Maximum Connectivity  
Name Name  
PhysicalName Coded Name  
Source Child False if child is N
AssociationRoleNameMap CombinationColumn Link  
Attribute Column  
Description Comment  
Name Name  
Optional Null Value Possible  
PhysicalName Coded Name  
Position Sequence  
BaseType Domain, Datatype  
DataType Data Type Name See datatype conversion array
Description Comment  
Name Name  
PhysicalName Coded Name  
CandidateKey Combination  
UniqueKey   True for Primary Key
Class Table  
CppClassType   Set to ENTITY
CppPersistent   Set to True
Description Comment  
Name Name  
PhysicalName Coded Name  
ClassDiagram   A main class diagram "Main" will be created to contain all entities/references. Only one schema is exported by Silverrun
DerivedType Domain, Datatype, Common Item  
DataType Data Type Name See datatype conversion array
Description Comment  
InitialValue Domain Validation Method Default Value  
Length Length  
LowerBound Domain Validation Method Minimum Value  
Name Name  
PhysicalName Coded Name  
Scale Number of decimals  
UpperBound Domain Validation Method Maximum Value  
UserDefined   True for Common Item
DesignPackage   No equivalent in Silverrun. A main package "Logical View" will be created to contain all entities/references
ForeignKey Combination Based on Primary Key and association role
Generalization Choice  
Description Comment  
Name Name  
PhysicalName Coded Name  
GeneralizationRole Choice  
Index Combination Associated with each key
IndexMember   Associated with each attribute in a key
Position   Computed
SQLViewEntity Table With the view property set to True
Description Comment  
Name Name  
PhysicalName Coded Name  
StoreModel Project  
Description Comment  
Name Name  
PhysicalName Coded Name  
Synonym Table (Alias property)