Creating SQL Server Data Connections

Creating an SQL Server Data Connection

1. Log in to the DLV console.
2. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.
   Figure 1 Creating a data connection
   

3. In the New Data Connection dialog box, set Data Source Type to SQL Server and set the related parameters.
   Figure 2 Creating an SQL Server data connection
   

   Table 1 SQL Server data connection parameters

   Parameter	Description
   Name	Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).
   Domain Name	IP address of the database.
   Port	Port of the database.
   Username	Username of the database. The database user must have permission to access data tables and metadata.
   Password	Password of the database user.
   Agent	Select an available connection agent.
   Database	You can select a database from the Database drop-down list.

4. Click OK.

Using SQL Server Data Sources

You can configure and use SQL Server data sources by referring to the instructions in Using DWS Data Sources.