Details on Microsoft SQL Server Analysis Services Connection


This dialog is used to set up a connection to a Microsoft SQL Server Analysis Services cube, where you can analyze data from the cube without bringing it into your analysis. Note that the Microsoft Adomd.NET driver must be installed on the machine running the Microsoft SQL Server Analysis Services connector. See the system requirements at http://support.spotfire.com/sr.asp for details.

  1. Select Tools > Manage Data Connections.

  2. Click Add New > Data Connection and select Microsoft SQL Server Analysis Services.

  1. Select File > Add Data Tables....

  2. Click Add.

  3. Select Connection To > Microsoft SQL Server Analysis Services.

  4. Comment: You can also set up new connections in the Data Connection Properties dialog.

data_microsoft_sql_server_analysis_services_connection_d.png

Option

Description

Server

The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. To include an instance name, add it directly after the server name preceded by backslash.

Example with port number:
myDatabaseServer:1234

Example with instance name:
MyDatabaseServer\InstanceName

Connect

Connects you to the specified server and populates the lists of available databases and cubes below. Microsoft SQL Server Analysis Services only supports Windows authentication.

Database

Select the database of interest from the drop-down list.

Cube

Select the cube of interest from the drop-down list.

See also:

Data Overview

Adding Data Connections to an Analysis

Working With Microsoft SQL Server Analysis Services

SQL Server Data Types