About Oracle Java CAPS Adapter for Sybase

This topic provides information about Oracle Adapter for Sybase.

About Sybase

Sybase Adaptive Server Enterprise (ASE) is a powerful data management platform for high performance business applications.

Sybase ASE’s highly reliable data management technology provides a powerful data management platform that supports the demanding needs of mission critical enterprises, accelerating application development, securing critical company and customer data, and easing data administration tasks.

About the Sybase Adapter

The Sybase Adapter enables Oracle Java CAPS ESB Projects to exchange data with external Sybase databases. This user’s guide describes how to install and configure the Sybase Adapter.

The Sybase Adapter uses JCDs (Java Collaboration Definitions) and BPEL (Business Process Execution Language to perform the following:

• Query or Update a database

• Automatically generate a graphical user interface (GUI) tree representation of database access objects

• Populate the structure with the actual data values during run time.

Though SQL coding is not required, the Sybase Adapter also supports a full set of SQL functions for advanced users.

The Sybase Adapter also uses the same GUI structure as the rest of the Oracle Java CAPS ESB system to describe data flow through the entire enterprise. This feature enables business analysts to define the relationships between a database and relevant applications by dragging and dropping elements between graphical tree structures.