Creating a Sybase IQ Connection Profile

Create a Sybase IQ connection profile to supply the runtime connection information for a Sybase Adaptive Server IQ database server endpoint.

Prerequisites

If you plan to use a JDBC driver other than the default Sybase IQ driver provided by Sybase WorkSpace, verify that you have defined your driver before creating a connection profile.

You have the following options:

Define a connection profile that exposes a single database.
Simultaneously define connection profiles for multiple databases.

Note: If you change the connection properties of a connection profile that is already connected, the connection profile immediately disconnects from the resources and automatically attempts to reconnect using the updated information.

In Enterprise Explorer, right-click the server type or enterprise resource for which you want to create a connection profile and select New.
On the Wizard Selection page, select the appropriate connection profile type and click Next.

Enter a name and description for the connection profile, and click Next.

Table 1. Create Connection Profile page
Field	Description
Name	Enter a unique and descriptive name for the connection profile.
Description	(Optional) Enter a profile description that helps you distinguish it from others.
Auto-Connect at Startup	(Optional) Connect automatically to the server and display its contents in Enterprise Explorer when Sybase WorkSpace starts.

In the Specify a Driver and Connection Details page, enter the rest of the connection profile details.

Table 2. Connection Tab
Field	Description
Select a Driver From the Drop-Down	Select the appropriate version. The other fields populate with system defaults.
Host	Enter the host name.
Database Name	If exposing a single database, enter the database name. If exposing multiple databases, leave blank.
Port	Enter the port number.
User Name	Enter the name of the authorized user.
Password	Enter the password for the database server login, if required.
Save Password	Save the password for this connection profile. Passwords persist for the current WorkSpace session. If you do not save your password and exit WorkSpace, you have to enter it when trying to connect to the database server via the connection profile for the new WorkSpace session. Note: Whether you want to save your password depends on your organization's security policy. Passwords are saved into the ServerProfiles.dat file with minimal encryption.

Table 3. Other Properties tab
Field	Description
Other Properties	Specify connection properties using the KEY=value format, or choose from the drop-down list, and click Add. For example, `DYNAMIC_PREPARE=true`. Use the Up, Down, Remove, and Clear All buttons to delete or change the order of the connection properties.

Click Test Connection to ping the server and to verify that the connection profile is working.
(Optional) If your database server exposes multiple databases, and you create connection profiles for multiple databases simultaneously, click Next.
1. Select Check for Multiple Databases to display a list of available databases.
2. Select the databases for which you want to create connection profiles.
Click Finish to create the connection profile.
The connection profile displays under the appropriate category in the Enterprise Explorer.

If you created connection profiles for multiple databases, WorkSpace creates an individual connection profile for each database and names the connection profile using the following convention: <connection profile name>.<database name>.