Setting up the database

To set up the JDBC provider you must have created an integration node. To create an integration node you must run the Default Configuration wizard, see Creating the Default Configuration in the IBM Integration Bus documentation.

To run the Simplified Database Routing sample you require a database with two tables which are populated with sample data as part of the setup. To connect and interact with the database by using JDBC, you must also create a user defined JDBCProvider definition as an entry in the registry of the integration node.

Complete the following tasks to set up the database environment by following the instructions that are relevant to your database manager:

1. Create and populate the database.
   • Setting up DB2
   • Setting up Oracle
2. Create the JDBCProvider definition.
   • Creating a JDBC provider entry for a DB2 database
   • Creating a JDBC provider entry for an Oracle database

Back to sample home