SAP Sybase Adaptive Server Enterprise (ASE): Add Database Connection

To define a new connection from the Connection parameter in an SAP Sybase Adaptive Server Enterprise (ASE) format:

  • Select Add Database Connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections The new connection can be made visible only to the current user, or can be shared among multiple users.

Note: To select an existing, previously defined connection, see the section Reusing a Database Connection in Using Database Connections

Database Connection

SAP Sybase Adaptive Server Enterprise (ASE)

Name

Enter a name for the new connection.

Connection Parameters

Host

The host name of the SAP Adaptive Server Enterprise database. In Sybase, this is often referred to as the Server Name.

Port

When connecting remotely, this specifies the port on which to connect to the database service. The default port is 5000.

Database

The name of the SAP Adaptive Server Enterprise database.

Username and Password

Enter the username and password to access the service.

Advanced – Specify JDBC Connection

When enabled, this parameter will allow the JDBC connection string and properties to be specified directly, in order to connect to the database.

Option

Description

Connection String

The connection string for the database to which you are connecting.

Mask Connection String

When this option is checked (set to Yes), connection strings for database connections are masked in translation and error logs.

Connection strings may contain sensitive information (for example, passwords). A masked connection string appears as:

jdbc:<subprotocol>:************

When this option is unchecked (set to No), connection strings are logged in plain text.

Connection Property and Value

Name/value pairs entered here will be set in the order specified, then passed on in a Properties object when connecting to the database.

They do not require manual encoding of characters that are not safe in Connection Strings.