Grandite Silverrun-RDM 2.4.4 to 2.8.6 - 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 | 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 |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
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.2.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 https://www.metaintegration.com/Products/MIMB/Help/#!Documents/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 | |||||||||||||||||||||||||
| Version | Select here the version of Silverrun RDM you want to use. | ENUMERATED |
|
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) | ||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| 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 |
|
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) |