Databases Reference
In-Depth Information
CHAPTER
17
IN THIS CHAPTER
.
Loading Data
Loading Data from a
Relational Database
.
Data Source Objects
W
hen you have defined all your dimensions and
measure groups, you are ready to populate your model with
data. In this chapter, we discuss how Analysis Services loads
data from a relational database; in other words, how it
determines where data for a multidimensional object comes
from. We also examine how Analysis Services accesses rela-
tional databases.
Loading Data
Analysis Services loads data into its multidimensional stores
by issuing SQL queries to relational databases and process-
ing the response. To determine where relational data is
located and which flavor of the SQL language to use,
Analysis Services uses three types of objects:
DataSource
,
DataSourceView
, and
Binding
:
.
DataSource
objects define the physical location of
relational data. Typically, the object contains a
connection string that Analysis Services uses to estab-
lish a connection to the relational database.
.
DataSourceView
objects define the logical layout of
the relational tables and columns used to populate the
multidimensional data model. The object defines data
types of the columns, and enables you to specify addi-
tional joins between tables.
.
Binding
objects define which tables or columns
defined in
DataSourceView
or directly in relational
database Analysis Services should use to populate mul-
tidimensional object.
Search WWH ::
Custom Search