Connect to a Microsoft SQL Server Parallel Data Warehouse (SSAS)

  • Article

This page of the Table Import Wizard enables you to specify settings to connect to a Microsoft SQL Server Parallel Data Warehouse (PDW). To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

SQL Server PDW is a highly scalable appliance that delivers performance at low cost through massively parallel processing. For more information about SQL Server PDW, see the web site SQL Server 2008 R2 Parallel Data Warehouse. You connect to the data warehouse by using SQL Server Authentication. To connect to a data source, you must have the appropriate provider installed on your computer.

Note

The credentials of the current user are used when selecting a database in this page. However, import will not succeed if the user specified in the Impersonation Information page does not have sufficient privileges to read from the selected database.

  • Friendly connection name
    Type a unique name for this data source connection. This is a required field.

  • Server name
    Type the name, or IP address, of the server to connect to.

  • User name
    Specify a user name for the database connection.

    This user name is used when constructing the connection string for the data source. These credentials are also used when previewing and filtering data in the Table Properties window and in the Import Wizard. These credentials are not used to import or refresh data; the Windows credentials specified on the Impersonation Information page are used instead.

  • Password
    Specify a password for the database connection.

  • Save my password
    Specify whether the password you have entered in the Password box is stored.

  • Database name
    Select a database from the list of databases.

  • Advanced
    Set additional connection properties by using the Set Advanced Properties dialog box. For more information, see Set Advanced Properties (SSAS).

  • Test Connection
    Attempt to establish a connection to the data source using the current settings. A message displays and indicates whether the connection is successful.