Define a Select Operation on Database Tables

You can define a SELECT operation to perform against database tables. This section provides a high level overview of creating an integration in which an Oracle Autonomous Transaction Processing Adapter is configured as an invoke connection to retrieve table records from the Oracle Database.

To define a SELECT operation on database tables:

1. Configure SOAP Adapter and Oracle Autonomous Transaction Processing Adapter connections.
2. Select Application in the Create integration panel.
3. Add and configure the SOAP Adapter as a trigger connection in the integration.
   The SOAP Adapter is configured to accept an input and return the response received from the invoke connection.
4. Add the Oracle Autonomous Transaction Processing Adapter as an invoke connection in the integration.
   This invokes the Adapter Endpoint Configuration Wizard.
5. On the Basic Info page, select Perform an Operation On a Table as the type of operation to perform and Select as the operation to perform on the table.
6. On the Operate On Table page, specify the schema and tables to import, and click Import Tables. For this example, the following values are specified.

   • Schema: HR

   • Table Type: TABLE

   • Table Name: %TAB

   • Selected Tables: EMPLOYEE_TAB and DEPARTMENT_TAB. The tables are imported together for the Oracle Autonomous Transaction Processing Adapter to recognize the relation between the tables.

   
   

   
   Description of the illustration oic3_db_tables.png

   
   
   The page is refreshed for you to select the parent (root) database table.
7. Select the parent table (for this example, DEPARTMENT_TAB is selected).
   This page enables you to:

   • View the automatically created table relationships and create new ones.

   • View and deselect attributes.

   • View and edit the automatically created SQL query.

   
   

   
   Description of the illustration oic3_db_tables2.png

   
   
8. View your selections on the Summary page. Links to the tables you selected to import and SQL query you specified are provided.
9. Click Done to exit the Adapter Endpoint Configuration Wizard.
10. Complete the integration by performing mapping and tracking tasks.
11. Activate the integration.
12. Copy the link to invoke the integration from under the How to Run link.
13. Invoke the integration from a tool such as the SOAP UI.
14. Review the values returned by the Oracle Autonomous Transaction Processing Adapter.