Select SE - 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 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
Remote Repository Browsing for Model Selection
Data Profiling
Multi-Model Harvesting
Incremental Harvesting

Import tool: Select Software Select SE 7.0 (http://www.selectbs.com/analysis-and-design/select-architect)
Import interface: [Data Modeling] Data Store (Logical Data Model) via 001 Export File from Select SE Import bridge: 'SelectSe' 10.1.0

Please enter a description


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. By default, the first one is imported. 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. By default, these constraints are created. BOOLEAN   True  
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)
"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