Importing Table Structures from a Database

Use

You want to use a table structure as an external message in an operation.
You want to import a table structure to define a JDBC lookup graphically in a message mapping (see: Defining JDBC Lookups Graphically ).

Prerequisites

The table must be defined in the database.
To access the table of the database, a JDBC adapter instance and the relevant database must be running.
To use the JDBC adapter to access the table, you must have configured a receiver JDBC channel (see: Configuring the Receiver JDBC Adapter ).

Procedure

Create an external definition (see: Creating a New Object ).
Select dbtab as the Category and From Table Definitions as the mode.

Note

Only use the mode Do Not Extract if you want to save the definition centrally in the ES Repository without making any further use of it.
To import a table structure, choose the pushbutton to the right of the Communication Channel input field.
Follow the instructions in the wizard and save your changes.

Result

You can use the table definition as an external message in the operation of a service interface, or to define a graphical JDBC lookup in a message mapping.