Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository) - Import - 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.

  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor Microsoft
Tool Name SQL Server Analysis Services (SSAS)
Tool Version 7.0 to 8.0 (2000)
Tool Web Site http://msdn.microsoft.com/en-us/library/ms133828.aspx
Supported Methodology [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via DSO COM API
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

Import tool: Microsoft SQL Server Analysis Services (SSAS) 7.0 to 8.0 (2000) (http://msdn.microsoft.com/en-us/library/ms133828.aspx)
Import interface: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via DSO COM API from Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository) Import bridge: 'MicrosoftSqlServerDso' 10.1.0

This bridge relies on the Decision Support Objects (DSO) COM/OLE API in order to import Microsoft SQLServer Analysis Services OLAP metadata. Therefore, Microsoft SQLServer Analysis Services DSO API must be properly installed on the machine executing this bridge.

The DSO server relies on the Windows authentication service. To connect to DSO server, add the local user to the remote server as an OLAP administrator.

FREQUENTLY ASKED QUESTIONS

Q: How can I connect to a remote OLAP Server?
A: First you need to install the DSO API on the client computer. Please follow the instructions detailed on this MSDN page:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/prabout_499v.asp

Then, specify the name of the windows server you want to connect to in the appropriate bridge option.


Bridge Parameters

Parameter Name Description Type Values Default Scope
Version Select here the version of Microsoft SQL Server Decision Support Objects (DSO) you want to use. ENUMERATED
7.0
8.0
9.0
9.0  
Server name Specify here the name of the OLAP server to connect to.

If this bridge is installed and executed directly on the OLAP server computer, you can use localhostas value.

If this bridge is installed and executed on a client computer, while the OLAP server is running on a remote computer, the DSO API needs to be installed first on the client computer.

See the bridge tooltip for details about installing DSO.
STRING   localhost  
Import default All level This option controls weither or not the default Level of each Dimension is imported.

These default Levels are usually named 'All' and do not participate in the metadata lineage.
'True' - The default 'All' Levels are imported.
'False' - The default 'All' Levels are not imported.

By default, these default 'All' Levels are not imported.
BOOLEAN   False  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository)"
Metamodel
MicrosoftSqlServerDso
Mapping Comments
     
AliasClassifier AliasTable  
Name Name  
AliasFeature AliasColumn  
Name Name  
Attribute Column  
Name Name  
BaseType Datatype  
Class Table  
CppClassType   set to ENTITY
CppPersistent   Set to True
Name Name  
ClassDiagram Diagram Diagrams graphically represent the table layout of each Cube, like the Analysis Services client tool loes.
ClassifierMap   Used to connect and store lineage of Dimensions and Cubes to their tables
Cube Cube  
Description Description  
Name Name  
CubeDimensionAssociation   defines which Dimensions are used in the Cube
DatabaseSchema Database Schema  
Name Name  
DerivedType Datatype  
DataType datatype  
Length length  
Name   Derived from the datatype
DesignPackage   Packages represent the logical organization of Dimensions, Cubes, Connections
Name   set to Logical View
UserDefined   Set to FALSE
Dimension Dimension  
Description Description  
Name Name  
Type Type set to TIME or REGULAR
DimensionAttribute Dimension Member  
Name Name  
FeatureMap   Used to connect and store lineage of DimensionAttributes and Measures to their tables
Operation expression  
Hierarchy Hierarchy  
Description Description  
Name Name  
HierarchyLevelAssociation Level  
Position Depth  
Level Level  
Description Description  
Name Name  
LevelAttribute Level MemberColumn  
Name Name  
Measure Cube Measure  
Description Description  
Name Name  
OlapSchema OLAP Database  
Name Name  
PropertyElementTypeScope ADODB::Properties DSO::_Properties Generic object properties
Scope   set to MODEL, OLAP_SCHEMA, DATABASE_SCHEMA, DESIGN_PACKAGE, DIMENSION, CUBE, LEVEL_ATTRIBUTE or MEASURE
PropertyType ADODB::Properties DSO::_Properties Generic object properties
Name Name  
PropertyValue ADODB::Properties DSO::_Properties Generic object properties
Value Value value set on an object
StoreModel Server Represent the OLAP objects deployed on the Analysis Server
Name name