Cisco Cisco Unified Contact Center Enterprise 9.0(2) Release Note

The following example shows login credentials for two external databases: 

.

How to Categorize a Contact by External Data

You use the DB Lookup node (in the General tab of the Palette) to query a specific row of data
from an external database. You can then reference columns from that row.

Figure 37: DB Lookup Icon

Following is the Properties dialog box of the DB Lookup node:

Figure 38: DB Lookup Properties

Define the DB Lookup node properties as follows:

1. Select the database Table you want to query. (The drop-down list contains the enterprise

names of all lookup tables defined in ICM software.)

Note: Define all integer fields in tables accessed by a DBLookup node as NOT NULL.
Only the following data types are supported for SQL databases: SQLINT1 (tinyint),
SQLINT2 (smallint), SQLINT4 (int), SQLCHAR (char), SQLVARCHAR (varchar),

ICM Scripting and Media Routing Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)