Setting up the database

You need a database with two tables and an ODBC definition to run the DatabaseInput Node sample. To access the database the integration node must be configured with a user identifier and password.

Set up the database tables

Complete the following tasks to setup the database tables:

1. Create the database

   Follow the instructions that are relevant to your database manager:

   • Setting up DB2
   • Setting up Oracle
   
   
2. Create the tables within the database, see Setting up the database tables by using SQL scripts.

Set up the database environment for the integration node

Complete the following tasks to setup the database environment for the integration node:

1. Create an ODBC definition for the DBINPUT database with DBINPUT as the data source name (DSN).

   For instructions, see Enabling ODBC connections to the databases in the IBM Integration Bus documentation.

2. Specify the user identifier and password that are associated with the data source name DBINPUT.

   Use the mqsisetdbparms command to specify a user identifier and password that the integration node can use with the DBINPUT data source. This user identifier must be the same user identifier that you used when you created the database in the previous step. The user identifier determines the database schema name, and the integration node must use the same user identifier when accessing the table. For example, if your user identifier is USERID, the fully-qualified name of the CUSTOMER table name is USERID.CUSTOMER.

   1. Open a command console window in which you can run IBM Integration Bus commands. Enter the following command to specify the user identifier and password:

      mqsisetdbparms IB9NODE -n DBINPUT -u <user ID> -p <password>

   2. Enter the following command to reload the integration server:

      mqsireload IB9NODE -e DatabaseInput

Back to sample home