Sybase
Sybase is a relational database management system (RDBMS) known for its high performance and support for large-scale enterprise applications, later acquired by SAP and rebranded as SAP ASE (Adaptive Server Enterprise).
Prerequisites
The following prerequisites must be met in order for a user to create and test a successful connection.
- The Sybase server must be accessible from iceDQ server.
- Valid credentials to access the database.
- Sybase version 7.0 or above (SAP ASE or SAP IQ).
Authentication Mechanism
The following authentication mechanism is supported.
- Username & Password
Connection Properties
Username and Password Authentication
Use the following properties create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Sybase_Prod_conn |
| Driver * | Driver used to establish the connection. By default, one driver is available. | Sybase JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format : jdbc:sybase:Tds:<host>:<port>/<database> | jdbc:sybase:Tds:142.176.25.76:5000/my_database |
| Host * | IP address or hostname of the database server. | sybase.acme.com or 142.176.25.76 |
| Port * | Port is the address on which the server listens. Default value is 5000 for Sybase ASE server. | 5000 |
| Database * | Name of the target database. | my_database |
| Type * | The connection type – either System Connection or User Connection. Refer Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | password@123 |
Custom Properties
Custom properties are additional optional connection parameters supported by the Sybase driver. Users can define these to customize various aspects of the connection, such as timeouts, proxy settings, and more. The following are frequently used properties:
| Property | Description | Note |
|---|---|---|
| DEFAULT_QUERY_TIMEOUT | Default Query Timeout for this connection | Default value is 0 |
| QUERY_TIMEOUT_CANCELS_ALL | Cancel all statements when timeout encountered | Default is False |
| USE_METADATA | Creates and initializes a Database MetaData object to establish a connection | Default is True |
| AUTOCOMMIT | Automatically commit the changes to the database | Default is True |
| TRUSTSERVERCERTIFICATE | To trust the server certificate. | Default is False |
This External Sybase official website link lists the parameters of the JDBC driver and their default value.
The availability and behaviour of custom connection properties may vary depending on the version of the Sybase JDBC driver in use.
Unsupported Datatypes
The following data types are not supported.
- UNSIGNED SMALLINT
- UNITEXT
- NATIVE JAVA DATATYPES
- UNITEXT