Obtaining and Installing the XML/A SDK
Microsoft has released the first version of the XML/A SDK for Analysis Server. This entire SDK consists of one DLL, msxisapi.dll
, and several configuration files. The msxisapi.dll
requests encapsulated in SOAP packets, wraps the response XML in a SOAP packet and sends it back to the client. To use the DLL, you need to create a Web site, map it to the msxisapi.dll
and start sending and receiving SOAP packets (see Figure 2
|Figure 2: The msxisapi.dll handles sending and receiving SOAP packets to and from clients.|
Now that you have some idea of what XML/A is and how it works, it's time to set it up on your computer. Here are the steps to install XML/A:
- Download the XML/A SDK.
- Install it in the desired directory. I recommend that you accept the default installation path.
- Open IIS and create a virtual directory named "xmla" and map it to the directory that contains the msxisapi.dll file. Typically, you'll find that file in the ISAPI subdirectory of your XML for Analysis SDK installation.
After installing you can use the local URL http://localhost/xmla/msxisapi.dll
(substitute your server's domain name for localhost
if you didn't install XML/A on your local machine) to accept SOAP packets and run queries