OIC - About ATP Integration | Can we poll data from ATP as Trigger | ATP adapter Capabilities

About ATP:

• Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical transaction processing and mixed workload applications. 
• The Oracle Autonomous Transaction Processing Adapter enables you to integrate the Oracle Autonomous Transaction Processing database with Oracle Integration through use of a wallet for direct connectivity. 
• The Oracle Autonomous Transaction Processing Adapter is one of many predefined adapters included with Oracle Integration. You can configure the Oracle Autonomous Transaction Processing Adapter as a connection in an integration in Oracle Integration.

ATP provides the following capabilities:

1. Support for using a wallet for direct connectivity to connect to the Oracle Autonomous Transaction Processing - Shared (ATP-S) database in place of using the on-premises connectivity agent.
2. Support for accessing an Oracle Autonomous Transaction Processing – Dedicated (ATP-D) database with a wallet-based connection that uses the connectivity agent.
3. Support for invocation of stored procedure, run SQL statements, support for DML operation on table like Insert, update, merge, select etc.
4. Support for the bulk data import operation. This feature is supported for the following scenarios:
1. When using direct connectivity (that is, without use of the connectivity agent)
2. When using the Oracle Autonomous Transaction Processing - Shared (ATP-S) database
3. With the comma-separated value (CSV) data format only.
5. Mm

How to create ATP connection:

To create a connection to Oracle ATP CS instance, you must select Oracle ATP adapter and then specify the connection properties given below.

         1. Service Name. <<For example, myatp_tp. You can get the service name from the wallet or administrator can provide you>>

And specify the security properties given below:

          1. Wallet : <<Download the wallet from ATP and upload it here>> Please look at the steps given below to download the wallet from ATP.

          2. Wallet Password: <<Provide wallet password>>

          3. Database Service Username : <<Provide database service username>>

          4. Database Service Password: <<Provide database service password>>

Can we poll data as trigger using ATP DB:

• For direct connections (configured without using the connectivity agent), the Oracle Autonomous Transaction Processing Adapter can only be used for making outbound invocations as an invoke connection. This type of Oracle Autonomous Transaction Processing Adapter-specific connection cannot be configured as a trigger connection in an integration. Use cases related to inbound polling must be implemented using the scheduled orchestration integration pattern.
• If we create or configure ATP connection using Connectivity agent, then only we can poll data as trigger  from ATP Database.

Follow my below blog for atp polling usecase:

https://soalicious.blogspot.com/2024/06/oic-atp-polling-data.html

Reference:

https://docs.oracle.com/en/cloud/paas/integration-cloud/atp-adapter/oracle-autonomous-transaction-processing-adapter-capabilities.html