Skip to content

creating-a-data-source-basic-data-mining-tutorial.md

Latest commit

 

History

History
62 lines (41 loc) · 3.66 KB

creating-a-data-source-basic-data-mining-tutorial.md

File metadata and controls

62 lines (41 loc) · 3.66 KB
title Creating a Data Source (Basic Data Mining Tutorial) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic conceptual
ms.assetid d7107c32-69ed-49a8-9b6e-32753eebf42c
author minewiskan
ms.author owend
manager kfile

Creating a Data Source (Basic Data Mining Tutorial)

A data source is a data connection that is saved and managed in your project and deployed to your [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] database. The data source contains the names of the server and database where your source data resides, in addition to any other required connection properties.

Important

The name of the database is [!INCLUDEssSampleDBDWobject]. If you have not already installed this database, see the Microsoft SQL Sample Databases page.

To create a data source

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

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

  3. On the Select how to define the connection page, click New to add a connection to the [!INCLUDEssSampleDBDWobject] database.

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

  5. In the Server name box, type or select the name of the server on which you installed [!INCLUDEssSampleDBDWobject].

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

  6. In the Log onto the server group, select Use Windows Authentication.

    [!IMPORTANT]
    Whenever possible, implementers should use Windows Authentication, as it provides a more secure authentication method than SQL Server Authentication. However, SQL Server Authentication is provided for backward compatibility. For more information about authentication methods, see Database Engine Configuration - Account Provisioning.

  7. In the Select or enter a database name list, select [!INCLUDEssSampleDBDWobject] and then click OK.

  8. Click Next.

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

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

  10. Click Finish.

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

Next Task in Lesson

Creating a Data Source View (Basic Data Mining Tutorial)

Previous Task in Lesson

Creating an Analysis Services Project (Basic Data Mining Tutorial)

See Also

Create a Data Source (SSAS Multidimensional)
Defining a Data Source
Set Impersonation Options (SSAS - Multidimensional)