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.
Note: This feature is available in the Toad Data Point Professional Edition only.
Before connecting to SQL Server Analysis Services from Toad Data Point, 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.
To create a SQL Server Analysis Services connection
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
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:
|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.