Client/Server Architecture and Data Access - Microsoft SQL Server 2008 Analysis Services - page 568

Analysis Services uses Microsoft IIS as a middleware component to enable access to data
via HTTP. The process of data exchange between client and the server (and illustrated in
Figure 31.2) is as follows:

1. The client sends an HTTP POST request to IIS using the IIS server name and the path
to a service component known as the pump (binary name msmdpump.dll ) as the URL.
2. IIS receives the request, authenticates the sender, and creates a security context in
which the code in the pump will be executed.
3. IIS starts the pump and uses the Internet Server API (ISAPI) to communicate with it.
4. The pump connects to Analysis Services via TCP/IP and sends the data received from
the client without any changes.

Client Client Client Client Client Client

Internet

80 Port

IIS Server

Msmdpump90.dll

TCP/IP Port

Msmdsrv.exe

FIGURE 31.2

The diagram shows the process of the client working with the server over the

Internet.