IBM DB2

Use the IBM DB/2 DataSource to access DB/2 database including DB/2 databases on iSeries and AIX systems.

The following IBM DB 2 versions are supported

IBM DB 2 supported Data Types

Installing the RapidiConnector

If you want to transfer data to/from DB2 Data Sources, you have to do the following:

Install "DB2 Connect" for Windows.
Open the "Client Configuration Assistant".
Add a connection to each database that you want to transfer data to/from. Locate the database by searching the network. If your DB2 database is placed on a iSeries (AS400), you have to add a new system. When the requested database is found, you select it and fill in the database name and description.
Select "System Data Source" and test the connection.
If the result is successful, you can continue.
Now you have to "bind" "DB2 utilities". You fill in the UserID and Password. When you get the option of choosing the type of binding, you have to choose "CLI" binding.

The fields of the IBM DB/2 Data Source Card are described as follows:

Code: Give the Data Source a unique ID.
Description: Fill in a descriptive text.
Server Connect: Here you specify the name of the connection you created during the additional installation.
UserID: Here you specify the UserID.
Password: Here you specify the Password.
Schema: If you want to use a specific schema you can specify which one.

Copy Connection

Connection Test

Activate Changes

Read Design