Microsoft SQL Server Analysis Services (SSAS) (Repository) - 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 Analysis Services (SSAS)
Tool Version 9.0 (2005) to 11.0 (2012)
Tool Web Site http://msdn.microsoft.com/en-us/library/ms174778.aspx
Supported Methodology [Business Intelligence] BI Design (RDBMS Source, Dimensional Target) via DSV XML File

SPECIFICATIONS
Tool: Microsoft / SQL Server Analysis Services (SSAS) version 9.0 (2005) to 11.0 (2012) via DSV XML File
See http://msdn.microsoft.com/en-us/library/ms174778.aspx
Metadata: [Business Intelligence] BI Design (RDBMS Source, Dimensional Target)
Component: MicrosoftSqlServerDsvExport.MicrosoftSqlServerAnalysisServices 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 Analysis Services (SSAS) (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