Create SQL Server Analysis Services Connections
Through Toad you can create a connection to a Microsoft SQL Server Analysis Services (SSAS) data source. An SSAS connection in Toad allows you to access the multi-dimensional cubes from the data source.
See also, About SQL Server Analysis Services Data Sources.
Configure HTTP Access
Before connecting to SQL Server Analysis Services from Toad Data Studio, you must configure the IIS Web server (to be used for connecting) for HTTP access to SSAS. See the following instructions from Microsoft: http://msdn.microsoft.com/en-us/library/gg492140(v=sql.105).aspx.
Connect to SQL Server Analysis Services
To create a SQL Server Analysis Services connection
- Click
on the Connections toolbar (ALT+F+N).
- Select Microsoft SQL Server Analysis Services (SSAS) from the Group list.
-
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
URI Enter the URL for the Analysis Services data source to which you want to connect.
Note: Toad connects to Analysis Services via http access. The URL should have the following format:
format—http://<server path>/msmdpump.dll
example—http://server01/olap/msmdpump.dll
Database Enter the name of the Analysis Services database to which you want to connect. Username Enter the user name for the user account to be used in this connection. Password Enter the password for the user account specified in Username. Category (Optional) Select an existing category or create a new one. Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature.
- Click Connect to connect immediately and also save the connection information. Optionally, you can click Save to save the connection without connecting.
- Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.
Tips:
- Read about the considerations and limitations of working with Analysis Services in Toad in About SQL Server Analysis Services Data Sources.
- Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
- You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.