Select Database Schema and Tables

When you have selected the driver, DSN and provided connection information, the mapping tool establishes the connection and then allows you to choose the particular tables you wish to use in your transformation map.

First you should select the schema ('library' in the case of an IBM i database).  To do this, click the small arrow next to the selected schema name and then make your choice from the drop-down list:

Then you can select the database tables you wish to use in your map:

When you have selected the tables and clicked OK, the database component is inserted in the workspace for the map.  You can arrange and size it as required, and expand or collapse nodes:

You can then proceed to insert further components and create connections between them. For further information, refer to Edit Transformation Map.