Databases Reference
In-Depth Information
ods to retrieve schema (tables, relationships, columns within tables and data
types) information. If the data source is a relational database then by default it
uses the standard SQL to query the database. Analysis Services uses a cart-
ridge mechanism that allows you to specify extensions and customization in
SQL that are used by a specific relational database. This allows Analysis Ser-
vices to efficiently query data from the relational database.
The major data sources for Analysis Services databases are the relational
databases Microsoft SQL Server, IBM's DB2, Teradata and Oracle.
Figure 4-3
shows various data sources supported by Analysis Services 2005 on one of
the machines that has SQL Server 2005 installed. For a specific data source
you need to install the client components of the data provider so that the OLE
DB provider and/or .Net provider for that specific data source is installed on
your machine. These client components should not only be supported on your
development machine where you use BIDS to design your database but also
on the server machine where an Analysis Services instance will be running.
For relational databases DB2 and Oracle it is recommended you use the
Micorosoft's OLE DB data provider for Oracle or DB2 instead of the OLE DB
providers provided those databases. Please make sure appropriate con-
nectivity components from Oracle and IBM's DB2 are installed on your ma-
chine in addition to the OLE DB providers from Microsoft.
Search WWH ::
Custom Search