I have a couple of questions :
1- Which types of enterprise databases can be integrated with ICM ? ODBC ?
If yes, do we have to install the ODBC driver before configuring lookup tables in the Configuration Manager so that we can use the DB lookup node ?
2- Can Application Gateway make a lookup from any type of database ?
Thanks a lot.
DBWorker when installed and configured can only lookup against a Microsoft SQL Server database. You configure the SQL login information (hostname, user and password) in the registry for the Router and configure the table and request in the Config tool and script editor. There are a number of restrictions on DB Lookup.
So, no - you don't have to install any driver. The DBworker process can handle the connection and run the query you configure.
An Application Gateway is a totally different beast.
You can make one of these on Unix in C, on Windows in VB.NET and so on. The protocol between it and ICM is well defined, but the back end can do anything you like - talk to a database, a web service, read a file.
Cisco don't care what it does on that side, as long as it understands requests and responses and supports the heartbeat thread.
The third way of doing an Enterprise DB lookup is from IP IVR or CVP (I'm assuming UCCE). You can write custom Java classes to talk to any database, any web service and so on.