Oracle Integration Cloud (OIC) is a cloud-based integration platform provided by Oracle. It allows users to connect and integrate various applications, systems, and data across their organization. The platform offers a range of pre-built adapters that simplify the integration process.

One of the adapters available in Oracle Integration Cloud is the “Oracle Database Adapter.” This adapter enables you to connect and interact with Oracle databases securely and efficiently. With the Oracle Database Adapter, you can perform various operations on the database, such as reading data, writing data, executing SQL queries, and invoking stored procedures.

Here are some key features and capabilities of the Oracle Database Adapter in Oracle Integration Cloud:

1. Connectivity: The adapter provides a secure and reliable connection to Oracle databases, allowing you to access data stored in the database from within your integration workflows.

2. SQL Operations: You can use the adapter to execute SQL statements directly on the connected database. This allows you to retrieve data based on specific criteria, update existing records, insert new data, and delete records.

3. Polling and Triggering: The adapter supports polling and database event triggering. This means you can set up integration flows to monitor changes in the database or periodically poll the database for new or updated records.

4. Error Handling: The adapter includes error handling capabilities, allowing you to manage exceptions and errors that may occur during integration processes.

5. Data Transformation: You can use the adapter’s mapping capabilities to transform data between different formats, ensuring compatibility between the source and target systems.

6. Security: The adapter follows security best practices to ensure the confidentiality and integrity of data transmitted between Oracle Integration Cloud and the Oracle database.