Select SE - 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 | Select Software |
| Tool Name | Select SE |
| Tool Version | 7.0 |
| Tool Web Site | http://www.selectbs.com/analysis-and-design/select-architect |
| Supported Methodology | [Data Modeling] Data Store (Logical Data Model) via 001 Export File |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Select Software / Select SE version 7.0 via 001 Export File
See http://www.selectbs.com/analysis-and-design/select-architect
Metadata: [Data Modeling] Data Store (Logical Data Model)
Component: SelectSe version 11.2.0
OVERVIEW
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at MIMB Known Limitations or bundled in Documentation/ReadMe/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 | |||||||||||||||||||||||||
| File | Consult the SelectSE documentation in order to generate a DIF file from the tool (file has the extension '.001'). The bridge will use the generated DIF file as input. |
FILE | *.001 | Mandatory | ||||||||||||||||||||||||||
| Model name | A Select SE DIF File may contain more than one Data Model. This option allows to specify the name of the Data Model to import. | STRING | ||||||||||||||||||||||||||||
| Create constraint default value | A Select SE DIF File may not always define wether a constraint must be created or not. This option allows to specify wether these constraints must be created or not. | BOOLEAN | True | |||||||||||||||||||||||||||
| Encoding | Specifies the character set encoding of the model to be imported . 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) |
"Select SE" Metamodel SelectSe |
Mapping Comments |
| Association | $Relation | |
| Aggregation | True if one of the role is part of a primary key | |
| Name | %MasName | |
| PhysicalName | %TNameKeyCst (%EntObjKey) | |
| AssociationRole | $Relation | |
| Description | %MasDetDesc, %DetDetDesc | |
| ExtraConstraint | %IntDelParent, %IntUpdParent, %IntInsParent, %IntDelChild, %IntUpdChild, %IntInsChild | |
| Multiplicity | %MasOccursMax, %MasOccursMin, %DetOccursMax, %DetOccursMin | |
| Name | %MasName, %DetName | |
| Source | True for the role associated with the MastEntity | |
| AssociationRoleNameMap | $EntObjKey - $EntKeyAttr | |
| Attribute | $DIEntity ($DataItem - $DataItemRole) | |
| Description | %BriefDesc - %DetDesc ($DataItem - $DataItemRole) | All descriptions will be appended |
| InitialValue | %StoDefltVal | |
| Name | %RoleName - %Name | |
| Optional | %Optional | |
| PhysicalName | %TargetName | Prefixed by $Entity.%AttriPrefix if any |
| Position | %PositionNo | |
| BaseType | $DataItem (%StoFormat) | |
| DataType | %StoFormat | See datatype conversion array |
| Name | based on the data type | |
| PhysicalName | based on the data type | |
| CandidateKey | $EntObjKey - $EntKeyAttr | |
| Description | %BriefDesc | |
| Name | %Name | |
| PhysicalName | %TNameKeyCst | |
| UniqueKey | %KeyType | True for Primary Key |
| Class | $Entity | |
| CppClassType | Set to ENTITY | |
| CppPersistent | Set to True | |
| Description | %DetDesc | |
| Name | %Name | |
| PhysicalName | %TargetName | |
| ClassDiagram | $Subset | A main class diagram "Logical View" will be created to contain all entities/relations |
| Description | %DetDesc | |
| Name | %Name | |
| DerivedType | $DataItem (%StoFormat) | |
| DataType | %StoFormat | See datatype conversion array |
| InitialValue | %StoDefltVal | |
| Length | %StoLength | |
| LowerBound | %ValidMinVal | |
| Name | based on the data type | |
| PhysicalName | based on the data type | |
| Scale | %StoDecPrec | |
| UpperBound | %ValidMaxVal | |
| DesignPackage | No equivalent in Select SE. A main package "Main" will be created to contain all entities/relations | |
| ForeignKey | $EntObjKey - $EntKeyAttr | |
| Description | %BriefDesc | |
| Name | %Name | |
| PhysicalName | %TNameKeyCst | |
| Name | %Name | |
| Index | $EntObjKey - $EntKeyAttr | Associated with each key |
| Description | %BriefDesc | |
| Name | %Name | |
| PhysicalName | %TNameIndex | |
| IndexMember | $EntObjKey - $EntKeyAttr | Associated with each attribute in a key |
| Position | %PositionNo ($EntKeyAttr) | |
| SortOrder | %KeyAtOrder ($EntKeyAttr) | |
| SQLViewAssociation | $DStrPcdEnt | |
| SQLViewAttribute | $DITransRec ($DataItem - $DataItemRole) | |
| Description | %BriefDesc- %DetDesc ($DataItem - $DataItemRole) | All descriptions will be appended |
| Name | %RoleName - %Name | |
| PhysicalName | %TargetName | Prefixed by $TransRec.%AttriPrefix if any |
| Position | %PositionNo | |
| SQLViewEntity | $TransRec | |
| Description | %DetDesc | |
| Name | %Name | |
| PhysicalName | %TargetName | |
| StoreModel | Smodel | |
| Description | %DetDesc | |
| Name | %Name | |
| PhysicalName | %TargetName | |
| TypeValue | $DataItem - $ValidValLst | |
| Name | %ValidValLst | |
| Position | In the order of the list | |
| Value | %ValidValLst |