Page 91 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes
Did u know? A data source reference is an association to another Analysis Services project or
data source in the same solution. You can remove the reference by clearing the check box
which will end the synchronization between the objects.

Add Multiple Data Sources to a Model

You can create more than one data source object to support connections to additional data
sources. To combine data from multiple data sources:
1. Create the data sources in your model.

2. Create a data source view, using a SQL Server relational database as the data source.
3. In Data Source View Designer, using the data source view just created right-click anywhere
in the work area and select Add/Remove Tables.
4. Choose the second data source and then select the tables you want to add.
5. Find and select the table you added. Right-click the table and select New Relationship.
Choose the source and destination columns that contain matching data.

Supported Data Source Types

Types of data sources that you can use in a multidimensional model are shown in Table 6.1.
Table 6.1: Types of Data Sources

Source Versions File type Providers
Access Microsoft Access 2003, 2007, .accdb or Microsoft Jet 4.0 OLE DB provider
databases 2010. .mdb
SQL Server Microsoft SQL Server 2005, (not OLE DB Provider for SQL Server
relational 2008, 2008 R2, 2012, applicable)
SQL Server Native Client OLE DB
databases Windows Azure SQL Provider
Database
SQL Server Native 11.0 Client
OLE DB Provider
.NET Framework Data Provider
for SQL Client

SQL Server 2008 R2; 2012 (not OLE DB provider for SQL Server
Parallel applicable) PDW
Data
Warehouse
(PDW)
Oracle Oracle 9i, 10g, 11g. (not Oracle OLE DB Provider
relational applicable) .NET Framework Data Provider
databases for Oracle Client
.NET Framework Data Provider
for SQL Server
MSDAORA OLE DB provider
OraOLEDB
MSDASQL
Contd....

86 LOVELY PROFESSIONAL UNIVERSITY