This dialog is used to set up a connection to a Microsoft SQL Server Analysis Services cube, allowing you to choose whether to analyze data in-database or to import it into your analysis. Note that you need to install a driver on your computer to get access to the Microsoft SQL Server Analysis Services connector. See the system requirements at http://support.spotfire.com/sr_spotfire_dataconnectors.asp to find the correct driver. You can also view Getting Started with Connectors to learn more about getting access to connectors in Spotfire.
To add a new Microsoft SQL Server Analysis Services connection to the library:
Select Tools > Manage Data Connections.
Click Add New > Data Connection and select Microsoft SQL Server Analysis Services.
To add a new Microsoft SQL Server Analysis Services connection to an analysis:
Select File > Add Data Tables....
Click Add.
Select Connection To > Microsoft SQL Server Analysis Services.
Comment: You can also set up new connections in the Data Connection Properties dialog.
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: Example with instance name: |
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:
Working With Microsoft SQL Server Analysis Services