Microsoft SQL Server Integration Services (SSIS) (via DSV File) - Export - 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 Microsoft
Tool Name SQL Server Integration Services (SSIS)
Tool Version 9.0 (2005) to 14.x (2017)
Tool Web Site http://msdn.microsoft.com/en-us/library/ms174778.aspx
Supported Methodology [Data Integration] BI Design (RDBMS Source, Dimensional Target) via DSV XML File

SPECIFICATIONS
Tool: Microsoft / SQL Server Integration Services (SSIS) version 9.0 (2005) to 14.x (2017) via DSV XML File
See http://msdn.microsoft.com/en-us/library/ms174778.aspx
Metadata: [Data Integration] BI Design (RDBMS Source, Dimensional Target)
Component: MicrosoftSqlServerDsvExport.MicrosoftSqlServerIntegrationServices version 11.0.0

OVERVIEW
Exports a model containing a single schema to a Data Source View (dsv) file. If the model contains multiple schemas, export the model as an Sql Server Integration Services Project.

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 Generates an XML file with extension '.dsv' representing a single schema.
Import this file into SSIS or SSAS by right-clicking your project and choosing Add>Existing file.
FILE *.dsv   Mandatory
DSV Name Specify the DSV name to be used in the generated file.
This name must be unique for each DSV file in a project.
If nothing is specified, a name is built from the catalog and schema names.
STRING      
XML Indentation (pretty printing) Controls the pretty printing of XML, for the purpose of opening the generated file in a text editor. E.g.

'space characters'
Several space characters as indentation.

'tab key'
Tab character as indentation.

'empty'
No indentation which leads to a more compact file.
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Microsoft SQL Server Integration Services (SSIS) (via DSV File)"
Metamodel
MicrosoftSqlServerDsv
Mapping Comments
     
Association   The foreign key information is exported
AssociationRole   The foreign key information is exported
AssociationRoleNameMap SourceField, TargetField  
DesignLevel   No equivalent for Logical Only objects.
Attribute Column  
Description msprop:Description Mapped only if comment is empty.
DesignLevel   No equivalent for Logical Only objects.
Name msprop:FriendlyName Attribute Name. Computed if not set
Optional minOccurs  
PhysicalName msprop:DbColumnName Attribute Physical Name.Computed from 'name' if not set
BaseType type  
DataType Datatype See datatype 'DataType Mapping' worksheet
DesignLevel   No equivalent for Logical Only objects.
Length msdata:DataSize  
CandidateKey xs:unique  
DesignLevel   No equivalent for Logical Only objects.
PhysicalName name Class Physical Name.Computed from the 'name' if not set
UniqueKey msdata:PrimaryKey="true"  
Class Table  
Description msprop:Description  
DesignLevel   No equivalent for Logical Only objects.
Name msprop:FriendlyName Class Name. Computed if not set
PhysicalName msprop:DbTableName Class Physical Name.Computed from the 'name' if not set
DesignLevel   No equivalent for Logical Only objects.
Name xs:element.name  
DerivedType type  
DataType Datatype See datatype 'DataType Mapping' worksheet
DesignLevel   No equivalent for Logical Only objects.
Length msdata:DataSize  
ForeignKey xs:keyref  
DesignLevel   No equivalent for Logical Only objects.
Index TargetIndex  
DesignLevel   No equivalent for Logical Only objects.
Generate   if set to false the index is not exported
PhysicalName name Class Physical Name.Computed from the 'name' if not set
IndexMember TargetIndexField use linked attribute's name for the target index field name
DesignLevel   No equivalent for Logical Only objects.
Position   position in XML file
SQLViewAttribute View Column  
Description msprop:Description Mapped only if comment is empty.
DesignLevel   No equivalent for Logical Only objects.
Name msprop:FriendlyName Attribute Name. Computed if not set
PhysicalName msprop:DbColumnName Attribute Physical Name.Computed from 'name' if not set
Position   The attributes are ordered by position in the XML file
SQLViewEntity View Tables withTableType=View
Description msprop:Description  
DesignLevel   No equivalent for Logical Only objects.
Name msprop:FriendlyName Class Name. Computed if not set
PhysicalName msprop:DbTableName Class Physical Name.Computed from the 'name' if not set