Creating a Data Source (Data Mining Tutorial)

A data source is a data connection that is saved and managed within your project and deployed to your Microsoft SQL Server 2005 Analysis Services (SSAS) database. The data source contains the server name and database where your source data resides, in addition to any other required connection properties. For more information about data sources in Analysis Services, see Working with Data Sources (Analysis Services).

To create a data source

1. In Solution Explorer, right-click the Data Sources folder and select New Data Source.

   The Data Source Wizard opens.

2. On the Welcome to the Data Source Wizard page, click Next.

3. Click New to add a connection to the Adventure Works database.

   The Connection Manager dialog box opens.

4. In the Provider list in Connection Manager, select Native OLE DB\Microsoft OLE DB Provider for SQL Server.

5. In the Server name list, select the server on which AdventureWorksDW is hosted.

6. Enter your credentials.

   For example, select localhost if the database is hosted on the local server.

7. In the Select or enter a database name list, select AdventureWorksDW, and then click OK.

8. Click Next to go to the next page of the wizard.

9. On the Impersonation Information page, select Use the service account, and then click Next.

10. On the Completing the Wizard page, note that, by default, the data source is named Adventure Works DW.

11. Click Finish.

    The new data source, Adventure Works DW, appears in the Data Sources folder in Solution Explorer.

Next Task in Lesson

Creating a Data Source View (Data Mining Tutorial)

Change History