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 AI Database Adapter is configured as an invoke connection to retrieve table records from the Oracle AI Database.

To define a SELECT operation on database tables:
  1. Configure SOAP Adapter and Oracle AI Database 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 AI Database 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 AI Database Adapter to recognize the relation between the tables.


    Description of oic3-db-tables.png follows
    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.

  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 AI Database Adapter.