Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Configuring a Data Source and

Data Source View

One of the many great features of Analysis Services is that, despite its being a tool that is

included when you purchase SQL Server, it does not limit you to using SQL Server relational

databases as a source. Creating this connection to your source data will be the first step you

take when designing any Analysis Services project.

CREATING A DATA SOURCE

You will make any connections required

for your project by configuring a data

source, which stores the connection

string information of your source data.

To create a data source, open the

Solution Explorer (Ctrl+Alt+L) in any

Analysis Services project, right-click the

Data Sources folder, and select New

Data Source. The Data Source Wizard

will open, which walks you through the

steps of configuring your source.

Figure 12-1 shows the Connection

Manager dialog box.

Here you will select the provider if it

is different from the default Native

OLE DB\SQL Server Native Client

10.0. This is the typical provider for

connecting to a SQL Server relational

FIGURE 121

12

889633c12.indd 105 8/16/10 9:13:18 PM

106



LESSON 12 Configuring a Data SourCe anD Data SourCe View

database. If you do choose the default data provider, you will identify the server on which your data

source is stored, as well as the d ...