Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (via ODBO) - Unsupported EOL Bridge - Import
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/ms714903.aspx |
| Supported Methodology | [Business Intelligence] BI Design (OLAP Source) via ADOMD COM API |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Microsoft / SQL Server Analysis Services (SSAS) version 7.0 to 8.0 (2000) via ADOMD COM API
See http://msdn.microsoft.com/en-us/library/ms714903.aspx
Metadata: [Business Intelligence] BI Design (OLAP Source)
Component: MicrosoftAdomd version 11.2.0
OVERVIEW
This bridge relies on the ActiveX Data Objects Multi-Dimensional API (ADOMD) version 2.5 and OLE DB for OLAP (ODBO) to connect to an OLAP database and import the metadata definition of OLAP cubes.
These APIs are part of the Microsoft Data Access Components (MDAC) architecture.
See the parameter description for examples of connection strings.
REQUIREMENTS
To enable access to the OLAP system via ADOMD, the OLAP database vendors provides an ODBO compliant data Provider that plugs into this architecture. Please make sure this data provider has been properly installed and configured.
FREQUENTLY ASKED QUESTIONS
How do I connect to my OLAP database?
Provide the OLE DB connection string in the appropriate bridge option. An OLE DB Connection String utilizes a Universal Data Link (UDL) file which contains all connection parameters or an OLE DB for OLAP data provider and its specific options.
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:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with -backup option, although this common option is not implemented on all bridges for technical reasons).
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope |
| Connection String | NOTE: As you can see below, this parameter may contain password information. This parameter is passed as clear text within this API based interface and within the bridge itself. Please be cognizant of any security concerns relating to passing passwords via clear text within your organization Provide here the OLE DB connection string used to connect to the OLAP Server. Please refer to your OLAP vendor documentation for details. Importing from Microsoft SQL Server 2000 Analysis Services: To connect to a cube running on a local computer, the connection string would look like: Provider=msolap;Data Source=localhost;Initial Catalog=FoodMart 2000 Provider=msolap;Data Source=localhost;Initial Catalog=Bobs Video Store To connect to a Cube running on a distant server, the connection string would look like: Provider=msolap;Data Source=ServerName;Initial Catalog=Bobs Video Store You can also directly connect to a cube file using the connection string format: Provider=msolap;Location=C:\MSDASDK\samples\oledb\olap\data\bobsvid.cub Importing from MicroStrategy MDX Adapter: To connect to a cube using the MDX Adapter user interface, the connection string would look like: Provider=MSTRODBO; To connect to a cube directly, the connection string would look like: Provider=MSTRODBO;Cache Authentication=False;Mask Password=False;Persist Encrypted=True;Persist Security Info=True;User ID=Administrator;Data Source=MicroStrategy BI Developer Kit (Direct);Initialization Mode=Read|Share Deny None;Extended Properties="PRMT=N/UID=Administrator/PWD=/PRJ=MicroStrategy Tutorial/CUBE=Tutorial/FILTER=/S/N" Importing from SAS OLAP Server To connect to a local SAS OLAP Server, the connection string would look like: Provider=sas.OLAPProvider.9.1;Data Source=_LOCAL_ To connect to a remote SAS OLAP Server, the connection string would look like: Provider=SAS OLAP Data Provider 9.1;User ID=sas; Password=sas;Data Source=;Mode=Read;SAS Cell Cache Size=10000;SAS Machine DNS Name=psassrv1;SAS Port=5451;SAS Protocol=2;SAS Server Type=2 Provider=sas.OLAPProvider.9.1;Data Source=lambchop.unx.sas.com;SAS Port=1359;SAS Protocol=2;User ID=fred;Password=banana Importing from SAP Business Warehouse: To connect to SAP BW, the connection string looks like: Provider=MDrmSap;DataSource=JXX;UserID=MyName;Password=MyPassword;SFC_CLIENT=005;SFC_LANGUAGE=DE |
STRING | Mandatory |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (via ODBO) - Unsupported EOL Bridge" Metamodel MicrosoftAdomd |
Mapping Comments |
| Cube | ADOMD:CubeDef | |
| Description | Description | |
| Name | Name | |
| CubeDimensionAssociation | ADOMD::Cube | defines which Dimensions are used in the Cube |
| DesignPackage | one default Package is created to store all the cubes and dimensions. | |
| Name | set to Logical View | |
| UserDefined | Set to FALSE | |
| Dimension | ADOMD::Dimension | |
| Description | Description | |
| Name | Name | |
| PhysicalName | UniqueName | |
| Type | set to TIME or REGULAR if available via data provider | |
| DimensionAttribute | ADOMD::Level | |
| Name | Name | |
| Hierarchy | ADOMD::Hierarchy | |
| Description | Description | |
| Name | Name | |
| PhysicalName | UniqueName | |
| HierarchyLevelAssociation | ADOMD::Level | defines which Levels are used in the Dimension Hierarchy |
| Position | Depth | |
| Level | ADOMD::Level | |
| Description | Description | |
| Name | Name | |
| PhysicalName | UniqueName | |
| LevelAttribute | ADOMD::Level | |
| Name | Name | |
| Measure | ADOMD::Member | The measures are imported from the Cube members |
| Description | Description | |
| Name | Name | |
| PhysicalName | UniqueName | |
| PropertyElementTypeScope | ADO::Property | |
| Scope | set to DIMENSION, HIERARCHY, LEVEL or MEASURE | |
| PropertyType | ADO::Property | Data provider specific properties for Dimensions, Hierarchies, Levels and Measures |
| Name | Name | |
| Usage | DataProvider Name | |
| PropertyValue | ADO::Property | |
| Value | Value | value set on an object |
| StoreModel | ADOMD::Catalog | The model is built using the OLAP metadata accessible via the ADOMD data provider. |
| Name | name |