Sybase Adaptive Server Enterprise Data Sources

IBM® Cognos® software supports the following Sybase Adaptive Server Enterprise data sources: CT-Lib and CT-15.

You specify connection parameters when you create a data source or modify a data source connection.

Table 1. Sybase Adaptive Server Enterprise data source parameters



Server name

Enter the name of the server.

Database name

Enter the database name.

Select Master if you want the Sybase server to determine the default database. To override the default, enter a valid database name.

Application name

Enter the application name. If you leave this blank, the default is the name of the Cognos executable, for example, BiBustkservermain or DataBuild.

Collation sequence

Enter the collation sequence to be included in the database connection string. Collation sequences are required only in rare cases where there may be sorting discrepancies between IBM Cognos software and a database.

Packet size

Enter the packet size. For CT-Lib, the default is 512. For CT-15, the default is 2048. Increase the packet size to reduce the number of packets that must be sent. Decrease the packet size if larger packet size is an issue. The size that you can request can not be larger than the Sybase server allows. Contact your database administrator for more information.

Asynchronous levels

Select the asynchronous level.

Polling time slice

Enter the polling time slice. The default is 100.


Specify the time in seconds within which you want the database to connect or wait for your reply before timing out. Valid entries are zero to 32,767. To have the database wait indefinitely, enter zero, which is the default.


For more information on signon, see Create or Modify a Data Source Signon

If a user ID or password are required in the connection string, select the User ID check box.

If a password is required, select the Password check box and enter the password in the Password and Confirm password boxes.

To create a user ID and password that automatically connects to the data source, select Create a signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes.