x

On Windows, you only need to install MDAC 2.6 or higher.

The Adapter for Microsoft SQL Server 2000 Analysis Services (MS OLAP) provides read-only access to analytical data stored in Analytical Engine cubes. The adapter is an OLE DB for OLAP consumer. It employs Multi-dimensional Data Retrieval (MDX) language to access aggregated or rolled-up data used for decision-support processing.

You can use any server front-end technology with the WebFOCUS reporting engine to access the OLAP data retrieved by the server for Windows. This makes your OLAP data available to your entire enterprise. Additionally, data from Analytical Engine cubes can be joined with data from any other supported data source, providing additional information to your analytical process.

x

There is only one method by which you can be authenticated when connecting to Microsoft SQL Server 2000 Analysis Services (MS OLAP):

Operating System (Trusted Mode). The user ID and password used to log on to the operating system are automatically used to connect to the Analytical Engine. The server data access agent impersonates an operating system user according to the server deployment mode. The agent process establishes a connection to a Analytical Engine based on the impersonated operating system user credentials.

The Adapter for Microsoft SQL Server 2000 Analysis Services (MS OLAP) recognizes the security restrictions that the OLAP Database Administrator specifies and applies them to catalogs and cubes using Analytical Engine Services. This includes the role of security on the database and the application level. Although the Server for Windows establishes the connection to the Analytical Engine, an impersonation of the client is used to maintain access rights.

• Security off. If the server is running with security off, the user ID and password of the interactive user (the person logged onto a Windows or Workstation) is passed to the Analytical Engine in order to establish a connection and access rights. This is the logon ID specified for the Windows or Windows Workstation after it is first started.
• Security on. If the server is running with security on, the user ID and password of the client connecting to the server is passed to the Analytical Engine in order to establish a connection and access rights. This process is called impersonation.

x

Using the standard rules for deploying OLE DB, the server supports connections to a:

• Local Microsoft SQL Server 2000 Analysis Services (MS OLAP).
• Remote Microsoft SQL Server 2000 Analysis Services (MS OLAP). To connect to a remote Analytical Engine, it is recommended that you have MDAC 2.6 or greater installed.