Microsoft SQL Server Repository 2.1b (via XIF) - Unsupported EOL Bridge - Import - Cloud

Talend Cloud Data Catalog Bridges

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Catalog
Last publication date
2024-03-17

Note: AWS

Bridge Requirements

This bridge:
  • is only supported on Microsoft Windows.

Bridge Specifications

Vendor Microsoft
Tool Name SQL Server Repository
Tool Version 2.1b
Tool Web Site http://msdn.microsoft.com/library/default.asp?url=/library/en-us/reposad/raoverview_3t87.asp
Supported Methodology [Metadata Management] Metadata Repository, Data Store (Physical Data Model) via XIF XML File
Data Profiling
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection

SPECIFICATIONS
Tool: Microsoft / SQL Server Repository version 2.1b via XIF XML File
See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/reposad/raoverview_3t87.asp
Metadata: [Metadata Management] Metadata Repository, Data Store (Physical Data Model)
Component: MicrosoftSqlServerRepoXif version 11.2.0

OVERVIEW
n/a

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 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 The generated Microsoft "XML Interchange Format" (XIF) is loaded into the Microsoft Repository via its "Repository Browser" tool.

You can open an existing repository using the menu "File / Open Repository". If you don't have an existing repository, you can create one, using the menu "File / New Repository / Microsoft Access". Remember to also create a DSN entry for it using the "ODBC Data Sources" tool in your control panel. You also need to install the required metamodels in the repository (UML.rdm, DTM.rdm, etc.) using the menu "File / Install model File...".

Finally, you can create a new model in the Microsoft Repository using the menu "File / Import XML File..." and selecting the generated XIF file.
FILE *.xml   Mandatory
Auto correct The XIF file sometimes contain a slightly incomplete or incorrect model. This option allows you to specify whether the bridge should attempt to fix it or not.
'True'
Attempt to fix the model. This may involve deleting some elements.

'False'
Do not modify the model in any way. If the model is invalid, it will be rejected during the validation process.
BOOLEAN   True  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Microsoft SQL Server Repository 2.1b (via XIF) - Unsupported EOL Bridge"
Metamodel
MicrosoftSqlServerRepoXif
Mapping Comments
     
Argument UML:Parameter  
Comment xif:ShortDescription  
DefaultValue UML.Parameter:DefaultValue  
Description xif:Comments  
Kind UML.Parameter:Kind  
Name xif:Name  
Position   Order in the XIF file
Stereotype UML:Element.Stereotype  
Association UML:Association  
Aggregation   True if one of the AssociationRoles has UML.AssociationRole:IsAggregate set to true
Comment xif:ShortDescription  
Description xif:Comments  
Name xif:Name  
Stereotype UML:Element.Stereotype  
AssociationRole UML:AssociationRole  
Comment xif:ShortDescription  
CppScope UML.Element:Visibility  
Description xif:Comments  
Multiplicity UML.AssociationRole:Multiplicity  
Name xif:Name  
Navigable UML.AssociationRole:IsNavigable  
Ordered UML.AssociationRole:IsOrdered  
Source   Based on the multiplicity of each role
Stereotype UML:Element.Stereotype  
Attribute UML:Attribute  
Comment xif:ShortDescription  
CppScope UML.Element:Visibility  
Description xif:Comments  
InitialValue UML.Attribute:InitialValue  
Name xif:Name  
Position   Order in the XIF file
Stereotype UML:Element.Stereotype  
Class UML:Class  
Comment xif:ShortDescription  
CppAbstract UML.GeneralizableElement:IsAbstract  
CppScope UML.Element:Visibility UML.Element:Visibility
Description xif:Comments  
Name xif:Name  
Stereotype UML:Element.Stereotype  
ClassDiagram UML:ClassDiagram Only the diagram object is imported
Comment xif:ShortDescription  
Description xif:Comments  
Name xif:Name  
Stereotype UML:Element.Stereotype  
DerivedType UML.Attribute:TypeExpression or UML.Parameter:TypeExpression  
DesignPackage UML:Package  
Comment xif:ShortDescription  
Description xif:Comments  
Name xif:Name  
Stereotype UML:Element.Stereotype  
Generalization UML:Generalization  
Comment xif:ShortDescription  
CppScope UML.Element:Visibility  
Description xif:Comments  
Name xif:Name  
Stereotype UML:Element.Stereotype  
GeneralizationRole UML:Generalization  
Note UML:Note  
Operation UML:Operation  
Comment xif:ShortDescription  
CppAbstract UML.Operation:IsAbstract  
CppVirtual UML.Operation:IsPolymorphic  
Description xif:Comments  
Name xif:Name  
Stereotype UML:Element.Stereotype  
StoreModel UML:Model  
Comment xif:ShortDescription  
Description xif:Comments  
Name xif:Name