1. Using the MySQL Adapter with Oracle Integration Generation 2
  2. Add the MySQL Adapter Connection to an Integration
  3. Table Operation Page
  4. Import Tables Page

Import Tables Page

Filter and select the tables to import based on the selected schema. These tables are used to generate a SQL statement based on the operation selected.

You can import the following number of tables:

  • A maximum of three tables for insert, update, and insert or update actions

  • A maximum of five tables for the select - operation on table feature

  • A maximum of five tables for the polling feature

Element Description

Schema

Select the schema to use. The page is refreshed to display the tables available for selection.

Name Filter

Filter the display of tables.

Available

Select the tables on which to insert or update records.

Selected

Displays the selected tables.