Select SE - Import - Cloud

Talend Cloud Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Catalog

Note: This bridge is not available in Talend Cloud Data Catalog by default. You need to set up a remote harvesting agent to import metadata from this source. For more information, see Deploying a remote harvesting agent in Talend Cloud Data Catalog Administration guide.

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

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.0.0

OVERVIEW
REQUIREMENTS
n/a

FREQUENTLY ASKED QUESTIONS
n/a

LIMITATIONS
Refer to the current general known limitations at http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html or bundled in Documentation/ReadMe/MIMBKnownLimitations.html

SUPPORT
Provide a trouble shooting 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
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