Databases Reference
In-Depth Information
SQL Server
Partition
SQL Server
SQL Server
Dialect
SQL Server
Dialect
Abstract Query
Abstract Query
Cartridges
Dialect
SQL Server
Oracle
Abstract Query
Abstract Query
…
Partition
Teradata
Oracle Dialect
Oracle Dialect
Abstract Query
Abstract Query
Oracle
Partition
FIGURE 17.2
The internal query is translated to a query with provider-specific semantics.
In Figure 17.2, you can see the process of transforming the abstract query to one that the
data source can read. Analysis Services uses XML to build the internal query based on the
partition's binding and the DSV. To transform the query to the SQL format, Analysis
Services uses an XSL (Extensible Stylesheet Language) transformation (cartridge). The
specific cartridges are stored as files in the
cartridges
folder located in the installation
directory, under the
bin
folder. If you look in that folder, you will find a file named
sql70.xsl
. That is the cartridge used to transform an abstract internal XML query into a
query in syntax of SQL Server 7.0.
NOTE
If you are using an OLE DB or .NET provider that is not on the list of the supported
providers, Analysis Services will try to use the
sql2000.xsl
cartridge. A query to an
unknown provider issues in the SQL Server 2000 format.
After all this, Analysis Services passes the query to the specific client library responsible for
establishing a connection to the external database. Such a library, for example, could be
the OLE DB provider for SQL Server or the Oracle OLE DB provider. The
DataSource
object
keeps the information that specifies which client library to use and the connection string
properties for establishing a connection.
Search WWH ::
Custom Search