Creating a Database Connection

1. Click New to open the New Connection dialog box.
2. Enter the following information:

Option	Description
Name	Name of the connection. The name is not case sensitive and must be unique within the domain. The name cannot exceed 128 characters, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
ID	String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
Description	Optional description for the connection.

3. Select a database type.
Additional fields appear based on the database type you select.
4. Choose a simple connection or an advanced connection.
• - To choose a simple connection, select Simple Connection and specify the connection properties.
• - To choose an advanced connection, select Advanced Connection and specify additional database connection properties.
5. Click OK.
The Analyst tool tests the connection and displays the test status.