Creating a Data Source View (Basic Data Mining Tutorial)

A data source view is built on a data source and defines a subset of the data that populates a data warehouse. This enables you to modify the structure of the data to make it more relevant to your project. By using data source views, you can select the tables that relate to your particular project, establish relationships between tables, and add calculated columns and named views without modifying the original data source. For more information, see Designing Data Source Views (Analysis Services).

To create a data source view

  1. In Solution Explorer, right-click Data Source Views, and select New Data Source View.

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

  3. On the Select a Data Source page, under Relational data sources, select the AdventureWorks** DW2008** data source that you created in the last task. Click Next.

    Note

    If you want to create a new data source, click New Data Source to start the Data Source Wizard.

  4. On the Select Tables and Views page, select the following objects, and then click the right arrow to include them in the new data source view:

    • ProspectiveBuyer (dbo) - table of prospective bike buyers

    • vTargetMail (dbo) - view of historical data about past bike buyers

  5. Click Next.

  6. On the Completing the Wizard page, by default the data source view is named Adventure Works DW2008. Change the name to Targeted Mailing, and then click Finish.

    The new data source view opens in the Targeted Mailing.dsv [Design] tab.