To record data to an Oracle database, create the database
tables and configure an ODBC definition. Configure your integration node so
that it can connect to the database.
Before you begin
Read the following topics:
Procedure
- Use the script that is provided with IBM® Integration Bus to create and
configure the Oracle database tables in the default table space, which is where your recorded data
will be stored. Note that the script creates some tables that are not currently used, and are
reserved for future use, such as WMB_EVENT_FIELDS and WMB_EVENT_TYPES.
- Locate the script for your operating system:
- Windows: install_dir\server\ddl\oracle\DataCaptureSchema.sql
- Linux® or UNIX:
install_dir/server/ddl/oracle/DataCaptureSchema.sql
install_dir is the location of your
IBM Integration Bus installation.
- On Oracle, enter the following command to run the script:
sqlplus user/password @DataCaptureSchema.sql
- Create an ODBC definition for the database.
If
you used the supplied script to create your database without modifications,
create an ODBC definition for the database called MBRECORD, with MBRECORD
as the data source name (DSN). For more information,
see Enabling ODBC connections to the databases.
- Use the mqsisetdbparms command
to set a user identifier and password for the integration node to use when connecting
to the database; for example:
mqsisetdbparms integrationNodeName -n dataSourceName -u userID -p password
- integrationNodeName is the name of your integration node
- dataSourceName identifies the database to which
you want to record data
- userID and password specify
the user identifier and the password that the integration node uses to connect
to the database
- To ensure that the changes to the mqsisetdbparms command
take effect, restart the integration node.
- Test the connection to your database by using the mqsicvp command.
What to do next
Continue to follow the steps for recording
data; for more information, see Recording data.