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 |