1. Using the SAP ASE (Sybase) Adapter with Oracle Integration Generation 2
  2. Understand the SAP ASE (Sybase) Adapter
  3. SAP ASE (Sybase) Adapter Capabilities

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:

For trigger endpoints:

  • 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.

For invoke endpoints:
  • Support for invocation of stored procedures in the SAP ASE database.
  • Support for execution of DML statements and SQL queries:
    • Select
    • Insert
    • Update
    • Delete
    Select Run a SQL Statement on the Basic Info page of the Adapter Endpoint Configuration Wizard to execute simple SQL queries. For complex SQL queries, use stored procedures by selecting Invoke a Stored Procedure on the Basic Info page of the Adapter Endpoint Configuration Wizard. Stored procedures can reduce the complexity of a SQL query.
  • 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