SAP ASE (Sybase) Adapter Capabilities
The SAP ASE (Sybase) Adapter enables you to integrate the SAP ASE database residing behind the firewall of your on-premises environment with Oracle Integration through use of the on-premises connectivity agent. You can configure the SAP ASE (Sybase) Adapter as a trigger or an invoke connection in an integration in Oracle Integration. Use the SAP ASE (Sybase) Adapter to poll for new and updated records for processing in Oracle Integration.
The SAP ASE (Sybase) Adapter provides the following capabilities:
-
Support for polling new and updated records for processing in the SAP ASE database. The SAP ASE (Sybase) Adapter supports distributed polling. Distributed polling provides high availability and improves performance.
-
Support for a logical delete polling strategy. This strategy involves updating a special field on each row once it is processed.
-
Support for processing message payloads up to 10 MB in size. In the case of polling, you must set the Rejected Value property to REJECTED on the Polling Strategy and Options page. If the incoming message is greater than 10 MB, that particular record is updated to REJECTED instead of READ. If the message payload is greater than 10 MB, a fault response is sent to the calling clients.
- Support for invocation of stored procedures in the SAP ASE database.
- Support for execution of DML statements and SQL queries:
- Select
- Insert
- Update
- Delete
- Support for performing a Select operation against database tables.
- Support for bulk data import and extract by selecting the Select operation from the Perform an Operation On a Table list on the Basic Info page of the Adapter Endpoint Configuration Wizard.
The SAP ASE (Sybase) Adapter is one of many predefined adapters included with Oracle Integration. You can configure the SAP ASE (Sybase) Adapter as a trigger or invoke connection in an integration in Oracle Integration.
Supported Data Types for SQL Stored Procedures
The SAP ASE (Sybase) Adapter supports the following data types for SQL stored procedures.
- int
- smallint
- tinyint
- bigint
- unsigned int
- unsigned smallint
- unsigned bigint
- univarchar
- nvarchar
- varchar
- char(n)
- nchar
- unichar(n)
- text
- unitext
- money
- smallmoney
- bit
- binary
- varbinary
- numeric
- decimal
- float
- real
- double precision
- bigdatetime
- smalldatetime
- datetime
- bigtime
- date
- time