Microsoft SQL Server Integration Services (SSIS) (via DSV File) - Export - 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 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

Export tool: Microsoft SQL Server Integration Services (SSIS) 9.0 (2005) to 14.x (2017) (http://msdn.microsoft.com/en-us/library/ms174778.aspx)
Export interface: [Data Integration] BI Design (RDBMS Source, Dimensional Target) via DSV XML File to Microsoft SQL Server Integration Services (SSIS) (via DSV File) Export bridge: 'MicrosoftSqlServerDsvExport.MicrosoftSqlServerIntegrationServices' 10.1.0

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.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File The bridge 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) This option controls the pretty printing of the XML, for the purpose of opening the generated file in a text editor.

For example, specify here a tabulation character, or some space characters.

By default, there is 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