Sybase ASE
Create a Sybase ASE datastore to connect to a Sybase ASE database.
Sybase ASE datastores support a number of specific configurable options. Configure the datastore to match your Sybase ASE configuration.
Option |
Possible values |
Description |
|---|---|---|
Sybase version |
<version number> |
The version of your SAP ASE client. This is the version of SAP Sybase that this datastore accesses. |
Database server name |
Computer name |
Enter the name of the computer where the SAP ASE instance is located. Note For LINUX Agents, when logging in to a SAP Sybase
repository in the UI, the case you type for the database server name
must match the associated case in the SYBASE_Home\interfaces file.
If the case does not match, you might receive an error because the
Agent cannot communicate with the repository. |
Database name |
Refer to the requirements of your database |
Enter the name of the database to which the datastore connects. |
User name |
Alphanumeric characters and underscores |
Enter the user name of the account through which the software accesses the database. |
Password |
Alphanumeric characters, underscores, and punctuation |
Enter the user's password. |
Overflow file directory |
Directory path |
Enter the location of overflow files written by target tables in this datastore. A variable can also be used. |
Rows per commit |
Positive integer Default: 1000 |
Enter the maximum number of rows loaded to a target table before saving the data. This value is the default commit size for target tables in this datastore. You can overwrite this value for individual target tables. |
Language |
SAP-supported ISO three-letter language codes or <default> |
Select the language from the possible values in the drop-down list. The <default> option sets the language to the system language of the SAP Data Services Agent host system. |
Code page |
- |
Specify the character encoding of character data in the datastore. |
Server code page |
- |
Specify the character encoding of character data in the datastore. |
Additional session parameters |
A valid SQL statement or multiple SQL statements delimited by semicolon |
A valid SQL statement or multiple SQL statements delimitated by semicolon. |
Aliases |
- |
Enter the alias name and the owner name to which the alias name maps. |