Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the SAP ASE (Sybase) Adapter:

Ensure that you have write permissions on the database.
Ensure that you have the required permissions to run stored procedures and packages and SQL statements against the SAP ASE database.
Know the database hostname or IP address and the port number.
Know the database name.
Know the username and password for connecting to the database.
Install the connectivity agent. The connectivity agent is required to connect Oracle Integration with an SAP ASE (Sybase) on-premises database. See Configure an Agent Group.
Download a Java Database Connectivity (JDBC) .jar file and place it in the third-party lib folder while configuring the connectivity agent. A JDBC driver enables a Java application to interact with a database. See SAP ASE JDBC Driver.

Prerequisites to Use Trigger Polling

Perform the following prerequisite before you use trigger polling.

You must use the following ROWLOCK command in the database configuration at table level. ROWLOCK tells the SAP ASE server to only use row-level locks to ensure data consistency. This is a one-time setup.
```
alter table table_name lock datarows
```
You must use the following command at the schema or database level. This is a one-time setup.
```
sp_configure "select for update", 1
```