Creating a Data Source (Data Mining Tutorial)

Creating a Data Source (Data Mining Tutorial)

Updated: 17 November 2008

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).

The name of the database is AdventureWorksDW. If you have not already installed this database, see Samples and Sample Databases.

  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.

Release History

17 November 2008

Changed content:
  • Updated the link to sample databases.
  • Corrected the description of authentication options.

Community Additions

© 2015 Microsoft