 |
|
|||||||
 |
   
|
|
||||||
|
|
|||||||
|
|
|
||||||
| Vendor | Microsoft |
| Tool Name | SQL Server Data Source View (DSV) |
| Tool Version | 9.0 (2005) to 10.0 (2008) |
| 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, Expression Parsing) via DSV XML File |
Import tool: Microsoft SQL Server Data Source View (DSV) 9.0 (2005) to 10.0 (2008) (http://msdn.microsoft.com/en-us/library/ms174778.aspx)
Import interface: [Data Modeling] Data Store (Physical Data Model), BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing) via DSV XML File from Import bridge: 'MicrosoftSqlServerDsv' 6.1.0 - Mar 2 2010 19:12:45
This bridge imports an XML file with DSV or XMLA extension.
| Parameter Name | Description | Type | Values | Default | Scope | ||
| File | This bridge imports an XML file with DSV or XMLA extension. The file represents a data source view definition for Microsoft SQL Server 2005 Analysis Services. Two options are available to retrieve such a file: A) From SQL Server Business Intelligence Development Studio: Each project contains one or more files with dsv extension.Such file can be selected and exported with the command: "File->Save .dsv As ..." to generate the DSV file. Or the file can be found in the project directory. Each project contains one or more files with dsv extension.Such file can be selected and exported with the command: "File->Save .dsv As ..." to generate the DSV file. Or the file can be found in the project directory. B) From SQL Server Management Studio: SQL Server Management Studio can connect to an existingAnalysis Services server, which contains a list of data source views. Choose a data source view to be saved and use the command:"Script Database as->CREATE To -> File..." to generate a file with xmla extension. |
FILE |
|
Mandatory | |||
| Create dimensional layer | Select whether to create a dimensional layer or a purely physical layer. 'True' - A dimensional layer will be created 'FALSE' - No dimensional layer will be created |
BOOLEAN | True | Mandatory | |||
| __Incremental harvesting date | If a date is set, only metadata created or updated since the date will be imported. Use the ISO 8601 date format: yyyy-MM-dd HH:mm:ss | DATE | Hidden |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Data Source View" Metamodel |
Mapping Comments |
| AssociationRole | Element Content | |
| Multiplicity | Based on Source information and KeyType attribute | |
| Source | Based on Foreign Key information | |
| AssociationRoleNameMap | SourceField, TargetField | |
| Attribute | Column | |
| Description | msprop:Description | Mapped only if comment is empty. |
| Name | msprop:FriendlyName | Attribute Name. Computed if not set |
| Optional | minOccurs | |
| PhysicalName | msprop:DbColumnName | Attribute Physical Name.Computed from 'name' if not set |
| BaseType | SourceField, TargetField | BaseTypes are created to serve as parents for the simpleTypes defined in the file. |
| CandidateKey | xs:unique | |
| PhysicalName | name | Class Physical Name.Computed from the 'name' if not set |
| UniqueKey | parent key attribute information | |
| Class | Table | where msprop:TableType="Table" |
| CppClassType | Set to ENTITY | |
| CppPersistent | Set to True | |
| Description | msprop:Description | |
| Name | msprop:FriendlyName | Class Name. Computed if not set |
| PhysicalName | msprop:DbTableName | Class Physical Name.Computed from the 'name' if not set |
| DatabaseCatalog | Database | Inferred from Table definition |
| DatabaseSchema | Database schema | Inferred from Table definition |
| DerivedType | SimpleType | In case of an Union, only the first item is used |
| Length | length, totalDigits, maxLength, minLength | |
| LowerBound | maxExclusive, maxInclusive | |
| Name | name | either explicitely in the file, or computed based on its usage |
| Scale | fractionDigits | |
| UpperBound | maxExclusive, maxInclusive | |
| UserDefined | True for simpleTypes defined in the file, False for those defined in the Schema specification | |
| DesignPackage | No equivalent in XML. A main package "Logical View" is created to contain all elements. | |
| Dimension | DataTable, Named Query | Represents the definition of logical table views, including calculated columns |
| Name | Name | |
| DimensionAttribute | Column, Calculated Column | |
| Name | Name | |
| Position | position | |
| ForeignKey | SourceField, TargetField | |
| Index | TargetIndex | |
| Name | Name | |
| IndexMember | TargetIndexField | |
| Position | position in XML file | |
| Join | Relationship | |
| Name | name | |
| JoinRole | Relationship | 2 roles are created for each join Relationship |
| Model | Schema | The model is built using the elements contained in the file. |
| Name | Computed from the file name. | |
| OlapSchema | Data Source View | An OLAPSchema is created to represent the collection of objects available in this DSV file available to Cube builders |
| 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 |
Last updated on Tue, 2 Mar 2010 19:24:12
