Configuring the Adapter for Microsoft SQL Server 2000 Analysis Services (MS OLAP)

In this section:

x

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.

Top of page
x
Declaring Connection Attributes

How to:

Reference:

The SET CONNECTION_ATTRIBUTES command allows you to declare a connection to one Microsoft SQL Server 2000 Analysis Services (MS OLAP).

You can declare connections to more than one Analytical Engine by issuing multiple SET CONNECTION_ATTRIBUTES commands. The actual connection takes place when the first query referencing that connection is issued. You can include SET CONNECTION_ATTRIBUTES commands in an RPC or a server profile. The profile can be encrypted.

If you issue multiple SET CONNECTION_ATTRIBUTES commands, the first SET CONNECTION_ATTRIBUTES command sets the default Microsoft SQL Server 2000 Analysis Services (MS OLAP) to be used.
x
Procedure: How to Declare Connection Attributes

You can configure the adapter from either the Web Console or the Data Management Console.

  1. From the Web Console menu bar, click Adapters.

    or

    From the Data Management Console, expand the Adapters folder.

    The Adapters folder opens.

  2. Expand the Available folder, if it is not already expanded.
  3. Expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Right-click the adapter name and/or version and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Enter values for the parameters required by the adapter, as described in the connecton attributes reference.
  6. Click Configure. The configured adapter is added to the Adapters list in the navigation pane.
x
Reference: Connection Attributes for Microsoft SQL Server 2000 Analysis Services (MS OLAP)

The MS OLAP Services adapter is under the OLAP group folder.

The following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.

Server

Name of the machine where Microsoft SQL Server 2000 Analysis Services (MS OLAP) is running. The value for this field is used to describe connection attributes for the Microsoft SQL Server 2000 Analysis Services (MS OLAP).

Select profile

Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.

If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (The extension is added automatically).

Store the connection attributes in the server profile (edasprof).
x
Syntax: How to Declare Connection Attributes Manually

For Trusted mode authentication 

ENGINE MSOLAP SET CONNECTION_ATTRIBUTES datasource_name/

where:

MSOLAP

Indicates the adapter. You can omit this value if you previously issued the SET SQL ENGINE command.

datasource_name

Is the server name used as a connect descriptor to an Analytical Engine across the network. If omitted, the local database server will be set as the default.

iWay Software