Configuring the Infranet application

To set up the Infranet application for use by the connector, you must define a user account for the connector, and create the event and archive tables in the Oracle database used by Infranet.

Setting up an Infranet account

Using the Infranet Administrator, define a Customer Service Representative (CSR) User with all rights. This user is used by the connector and identifies the connector. This user ID is set in the event module configuration file crossworlds.cnf and in the connector configuration parameters. The Custom Event Facilities module checks this value before inserting events, to prevent events sent into the application by the connector from being redistributed back to the connector. This scenario is also referred to as "ping-ponging."

Creating the event and archive tables in the database

Event and archive tables are used to queue events for pickup by the connector. The event notification mechanism for the connector requires that three event tables be created inside the Oracle database instance used by Infranet. These tables are:

The first two tables specify the information that will be recorded for each Infranet event that the connector is interested in. The archive table holds all events that have been processed by the connector.

To create the event and archive tables, load the file EventTable.sql in %ProductDir%\connectors\Portal\dependencies\config_files.

Description of event and archive table schema

The event table contains the following columns. This table layout is also used for the archive table.

Table 1. Event and archive table schema

Name Type Description
Event_id integer Unique key for the event. The key value is generated in the XWORLDS_Current_Event_ID table.
Object_name char 80 Name of the application-specific business object.
Object_verb char 80 Verb associated with the event.
Object_key VARCHAR Primary key for the object (POID).
Event_time Date time Time at which the event occurred.
Archive_time Date time Archive table only. Time at which the event was received by Portal Infranet.
Event_status Integer Status of the event: READY_FOR_POLL 0 SENT_TO_INTERCHANGE 1 UNSUBSCRIBED_EVENT 2 IN_PROGRESS 3 ERROR_PROCESSING_EVENT -1 ERROR_SENDING_EVENT_TO_INTERCHANGE -2
Event_comment char 255 String used to provide extra information about the event. The user can define this comment in the event module configuration file.
Event_priority Integer Priority associated with the event. The lower the number, the higher the priority. The user can define this priority in the event module configuration file.

Copyright IBM Corp. 1997, 2003