Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCE - ICM script - Database Lookups

I have never had occasion to use ICM/UCCE's ability to access external databases from an ICM script.

I am looking at this for the first time for a customer requirement, where they want to

be able to access several databases depending on the script, and the DBs

don't all reside on the same SQL server. Some of the DBs reside on their own separate SQL servers.

At some point in the past, someone made the statement to me that ICM/UCCE

was restricted to using the DB Lookup node against one single SQL server.

In looking now, I can find nothing in the Cisco documentation to suggest such a limitation - quite

the opposite. Everything I have read suggests this should be fine, and I can see

how I think this ought to be done in ICM config and in the DB Lookup node.

So, should this work OK, or is there a limitation hidden away somewhere in the the doco that I haven't stumbled on yet?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

UCCE - ICM script - Database Lookups

Hi,

Yes you can have multiple external DB for ICM db lookup. The table used for db lookup should be part of the separate database, preferably on a separate server, in order not to overload the ICM with all the queries you will send to it.

Regards,

Gnaneswaran.

-Pls rate helpful posts

4 REPLIES
Cisco Employee

UCCE - ICM script - Database Lookups

Hi,

Yes you can have multiple external DB for ICM db lookup. The table used for db lookup should be part of the separate database, preferably on a separate server, in order not to overload the ICM with all the queries you will send to it.

Regards,

Gnaneswaran.

-Pls rate helpful posts

UCCE - ICM script - Database Lookups

Hi,

this whole DBLookup thing looks like a bad joke.

1. You can use Microsoft SQL server only.

2. By default, the user account that connects should be 'sa' with a blank password. C'mon, you guys.

3. There are even more restrictions - check this thread:

https://supportforums.cisco.com/thread/265274 Thanks God we've got geoff@hp.com.

So if you happen to have a customer willing to do some changes in his databases - you're lucky.

If not, you still have two options:

a, use IP IVR/CVP scripts/applications in order to get some information from a database;

b, use Application Gateways - these require a thin layer of middleware but if you take a look around, you'll find many implementations.

Good luck.

G.

Green

UCCE - ICM script - Database Lookups

Although ICM DB Lookup has many restrictions, if you can make it work it has a number of advantages. It is fast, simple and easy to code.

Regards,

Geoff

New Member

Hi Geoff,have a query on this

Hi Geoff,

have a query on this context. Can we have this external DB set it up in AW\HDS server ? is that approach is supported by Cisco or will have any challenges from Cisco's best practice perspective ?

 

regards

Sooraj Gopi

1603
Views
5
Helpful
4
Replies
CreatePlease login to create content