# Select SE - Import Availability-note[AWS](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-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** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.1/Content/Resources/images/cross.png) | | **Incremental Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.1/Content/Resources/images/cross.png) | | **Multi-Model Harvesting** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.1/Content/Resources/images/cross.png) | | **Remote Repository Browsing for Model Selection** | ![](https://help.qlik.com/talend/en-US/talend-data-catalog/8.1/Content/Resources/images/cross.png) | **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 12.0.0 **OVERVIEW** **REQUIREMENTS** n/a **FREQUENTLY ASKED QUESTIONS** n/a **LIMITATIONS** Refer to the current general known limitations at [MIMB Known Limitations](https://help.qlik.com/talend/en-US/talend-data-catalog/8.1/Subsystems/ModelBridgeGuide/Content/MIMB-Known-Limitations.htm) **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 whether a constraint must be created or not. This option allows to specify whether these constraints must be created or not. | BOOLEAN |
False
True
| 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 |
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)** | **"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 | |