WebSphere Adapter for Siebel

Setting up event table columns

The first step in creating an event table is setting up the columns.

Before you begin

You must be familiar with the tools found in the Siebel application.

About this task

Before you start the adapter, you must create an event table in the Siebel event component to track events that occur in the Siebel enterprise information.

Steps for this task

  1. Create an IBM® project and lock your project, according to the Siebel instructions. Except for event triggers, you must complete all Siebel customization under the new project.
  2. If you are installing multiple connectors, create multiple tables with different names.
  3. Using the new object wizard, create a standalone table named CX_IBM_Events.
  4. Create columns in your new table with the following names:
    • Column Name/User Name
    • Type
    • Length
    • Physical type
    • Required
    • Nullable
    • Status

The example below shows some typical column titles and along with the associated information.

Column example

Column name/ user name Type Length Physical type Required Nullable Status
DESCRIPTION Data (public) 255 Varchar No Yes Active
EVENT_ID Data (public) 30 Varchar Yes N/A Active
EVENT_TIME STAMP Data (public) 7 Date Time Yes N/A Active
EVENT_TYPE Data (public) 20 Varchar Yes N/A Active
OBJECT_KEY Data (public) 255 Varchar Yes N/A Active
OBJECT_ NAME Data (public) 255 Varchar Yes N/A Active
PRIORITY Data (public) 10 Number No Yes Active
STATUS Data (public) 20 Number Yes N/A Active

Terms of use |

Last updated: Thu 12 Oct 2006 03:37:04

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)