Adapters

It is a JCA Binding component, which is a lightweight implementation that uses JCA standards for inbound and outbound communications. It provides an interaction layer between the integration server and another application. This enable interoperability with heterogeneous applications, provided by different vendors, based on different technologies and platforms. The JCA Binding component allows composite application to integrate with a service exposed through the adapter as if it were a Web service. i.e. These adapters help us to connect to external system for both inbound and outbound interactions.

Types of Adapters:

1. Oracle Technology adapters
2. Legacy Adapters
3. Packaged Application
4. Oracle Application

Files/FTP:

These adapters are used to connect to file and FTP system. File adapter is used to read both flat & XML files from local file system. FTP adapter is used to read both flat & XML files from remote machine. We can perform below operations in these adapters.

a. Read file
b. Write file
c. Sync Read
d. File Listing

JMS/AQ/MQ:

These adapters are used to read the messages from JMS, AQ & MQ. JMS is open/Java standard, AQ (Advanced Queue) is oracle standard and MQ (Message Queue) is IBM standard. We can perform below operations in these adapters.

a. Read
b. write
c. Sync Read & Write

Database:

This adapter is used to interact with database. we can connect to different databases (like Oracle, DB2, SQL etc) using this adapter. In case we need to connect to non-oracle databases then we need to import require drivers as these drivers are there by default. We can perform below operations in this adapter.

a. Call stored procedure
b. CRUD operations
i. Select
ii. Delete
iii. Update
iv. Insert
v. merge
c. Poll for new or changes records
d. Execute pure SQL