Microsoft SQL Server Data Source View (DSV) - Export
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | Microsoft |
| Tool Name | SQL Server Data Source View (DSV) |
| Tool Version | 9.0 (2005) to 10.5 (2008 r2) |
| Tool Web Site | http://msdn.microsoft.com/en-us/library/ms174778.aspx |
| Supported Methodology | [Data Modeling] Data Store (Physical Data Model), BI Design (RDBMS Source, Dimensional Target, Transformation Lineage) via DSV XML File |
SPECIFICATIONS
Tool: Microsoft / SQL Server Data Source View (DSV) version 9.0 (2005) to 10.5 (2008 r2) via DSV XML File
See http://msdn.microsoft.com/en-us/library/ms174778.aspx
Metadata: [Data Modeling] Data Store (Physical Data Model), BI Design (RDBMS Source, Dimensional Target, Transformation Lineage)
Component: MicrosoftSqlServerDsv version 11.2.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 MIMB Known Limitations 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 | 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 Data Source View (DSV)" 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 |