When connecting to an SAP Sybase ASE database from the Syniti Knowledge Platform (SKP), provide the following connection properties to establish a secure and reliable connection. This article explains each property to understand what information is required and how it is used.
Property | Description | Notes |
|---|---|---|
Name | Name of the SAP Sybase ASE connection unique to the SKP. | NA |
Description | Enter a description that briefly states the purpose of this connection. | NA |
Hostname | Hostname is the network name or IP address of the SAP Sybase ASE machine you want to connect to. | * The server name, for example, ASEPROD01. * An IP address, for example, 192.168.10.50. * An URL |
Port | The port number your SAP Sybase ASE uses to accept connections. | By default, the SAP Sybase ASE port is 30015. If you are not sure, you can use this default port. |
Database | The name of the specific SAP Sybase ASE database you want to connect to. | SAP Sybase ASE can have many databases; this tells the SKP which one to use. |
Username | The login name used to sign in to the SAP Sybase ASE. | This login name should be an account that your administrator has created for database access. |
Password | The password for the username above. | Authenticates your connection to the database. |
Character Set | The character set for the connection. Use utf8 (default) for full Unicode support. | Other options include: * iso_1 (ISO 8859-1/Latin-1) * cp850 (DOS Latin-1) * cp437 (US DOS). Must match or be compatible with the server's configured character set. |
Packet Size | The TDS network packet size in bytes. Range: 512–16384. | Larger packets (e.g. 8192) improve throughput for bulk data transfers. Must not exceed the server's max network packet size setting. |
Enable SSL | Enable SSL/TLS encryption for the connection. The ASE server must be configured to accept SSL connections. When enabled, ensure the server's certificate is trusted by the client. | Default value is disabled. |
Connection Timeout | The maximum number of seconds the system will wait when trying to connect before stopping and showing an error. | Default value is 60 seconds. If your server is slow or far away, you can raise this number. |
Connection Pooling | Connection pooling allows the system to reuse existing database connections instead of creating a new one every time the SKP performs an operation. | * Enabled (Default): The SKP keeps a group (pool) of open database connections ready to use. This reduces the time spent opening and closing connections. * Disabled: A new connection is created and closed for each operation. This is simpler and uses fewer system resources but can be slower for frequent operations. |
Minimum Pool Size | The minimum number of connections that the system will always keep open when pooling is enabled. | Even if the SKP is idle, it will maintain at least this number of ready-to-use connections. Useful when you expect regular activity and want faster response times. For example, If Minimum Pool Size = 2, the SKP always keeps at least 2 connections open. |
Maximum Pool Size | The maximum number of connections the SKP is allowed to open when pooling is enabled. | This prevents the system or database from being overloaded with too many connections. When the pool reaches this limit, new requests must wait until a connection is released. For example, If Maximum Pool Size = 10, the SKP never opens more than 10 connections at the same time. |