Creating the Message Connector Tables
Before you can deploy the IBM® Interact Message Connector, you must first create the tables in the database where the Interact runtime data is stored. You'll create one table for each audience level you have defined. For each audience level, Interact will use the tables you create to record information about Message Connector transactions.
Use your database client to run the Message Connector SQL script against the appropriate database or schema to create the necessary tables. The SQL scripts for your supported database are installed automatically when you install the Interact runtime server. See the worksheets you completed in the IBM® Interact Installation Guide for details about connecting to the database that contains the Interact runtime tables.
Run the appropriate script in the <Interact_home>/msgconnector/scripts/ddl directory. The following table lists the sample SQL scripts you can use to manually create the Message Connector tables:
Microsoft SQL Server
Note that these scripts are provided as samples. You may use a different naming convention or structure for audience ID values, so you may need to modify the script before running it. In general, it is a best practice to have one table dedicated to each audience level.
The tables are created to contain the following information:
Note the following about this table:
When the script has finished running, you have created the necessary tables for the Message Connector.
You are now ready to deploy the Message Connector web application.