Grandite Silverrun-RDM 2.4.4 to 2.8.6 - Import - 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 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
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: Grandite (Silverrun) Silverrun-RDM 2.4.4 to 2.8.6 (http://www.silverrun.com/rdm.html)
Import interface: [Data Modeling] Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing) via TXT Export File from Grandite Silverrun-RDM 2.4.4 to 2.8.6 Import bridge: 'SilverrunRdm' 10.1.0

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


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 and 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 is 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 tell 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. The default is 'Western European (Windows 1252)' on Windows and 'Western European (ISO 8859-1)' on other platforms. 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)