Introduction to Data Warehousing and Analysis Services 2005 - Professional SQL Server Analysis Services 2005 with MDX - page 20

Chapter 12 . In addition to the above-mentioned tools, Analysis Services 2005
provides two more tools: the Migration Wizard and the Deployment Wizard.
The Migration Wizard helps in migrating Analysis Services 2000 databases to
Analysis Services 2005. The Deployment Wizard helps in deploying the data-
base files created using BIDS to Analysis Services 2005.
The SSMS provides efficient, enterprise-class manageability features for Ana-
lysis Services. Key aspects of an enterprise class service are availability and
reliability. Analysis Services 2005 supports fail-over clustering on Windows
clusters through an easy setup scheme and fail-over clustering certainly helps
provide high availability. In addition, Analysis Services 2005 has the capability
of efficiently recovering from failures. You can set up fine-grain security so
that you can provide administrative access to an entire service or administrat-
ive access to specific databases, process permissions to specific databases,
and read-only access to metadata and data. In addition to this, certain fea-
tures are turned off by default so that the Service is protected from hacker at-
tacks.
Analysis Services 2005 natively supports XML for Analysis specification
defined by the XML/A Advisory Council. What this means is that the commu-
nication interface to Analysis Services from a client is XML. This facilitates
ease of interoperability between different clients and Analysis Services 2005.
The architecture of SQL Server Analysis Services 2005 includes various
modes of communication to the service as shown in Figure 1-8 . Analysis
Server 2005 provides three main client connectivity components to commu-
nicate to the server. The Analysis Management Objects (AMO) is a new ob-
ject model that helps you manage Analysis Server 2005 and the databases
resident on it. The OLE DB 9.0 is the client connectivity component used to
interact with analysis services 2005 instances s for queries that conforms to
the OLE DB standard. The ADOMD.Net is dot Net object model support for
querying data from Analysis Services 2005. In addition to the three main cli-
ent connectivity components, two other components are provided by Analysis
Services 2005. They are DSO 9.0 (Decision Support Object) and HTTP con-
nectivity through a data pump. DSO 8.0 is the extension of the management
object of Analysis Server 2000 so that legacy applications can interact with
migrated Analysis Server 2000 databases on Analysis Server 2005. The data
pump is a component that is set up with IIS (Internet Information System) to
provide connection to Analysis Services 2005 over HTTP (Hypertext Transfer
Protocol).