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 Data Warehouse 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 Data Warehouse 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 Data Warehouse 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 Data Warehouse Adapter to recognize the relation between the tables.

   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.

8. If you want to edit the automatically created SQL query, click Edit in the Review and edit SQL Query section.
9. Use this field to add any necessary arguments or parameters.
10. Click Continue.
11. View your selections on the Summary page. Links to the tables you selected to import and SQL query you specified are provided.
12. Click Done to exit the Adapter Endpoint Configuration Wizard.
13. Complete the integration by performing mapping and tracking tasks.
14. Activate the integration.
15. Copy the link to invoke the integration from under the How to Run link.
16. Invoke the integration from a tool such as the SOAP UI.
17. Review the values returned by the Oracle Autonomous Data Warehouse Adapter.