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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

UCCX 9.01 Database Access For a Third Party Application

Hello Folks,

I'm starting with Cisco UCCX (and Cisco Collaboration too) soo an old customer ask me for help in develop an Web Application to collect specific data from queues, agents... in the Cisco UCCX, until now everything is OK, no problem. This request was based because our customer has not adapted with the format of the data submitted for monitoring queues and agents presented by UCCX.  When we tried to collect those data from UCCX Server, we seen that UCCX have an internal Database and for collect data from this one is not possible by default by a Third Party Application. For this kind of solution, we'll need our UCCX server connecting directly with external Database (Like SQL, Oracle..) and a specific license is needed (Unified IP IVR or Unified CCX Premium). Then, our Application would collect data from this DB.

is that right?

Please feel free to share any suggestion and experience about.

Best Regards,

Rodolpho Pereira

4 REPLIES
New Member

UCCX 9.01 Database Access For a Third Party Application

Hi,

Thats correct.UCCX starting from 8.x use  IBM Informix database which is not directly integrated with external database like SQL or Oracle.You have create a seperate system installed with SQL or Oracle and then download a Informix Database driver and installed that driver on SQL system.Create DSN and check the connection.

you can download JDBC driver from http://www.ciscounitytools.com/Applications/CxN/InformixODBC/InformixODBC.html

Regards,

Mukesh Singh

UCCX 9.01 Database Access For a Third Party Application

Rodolpho,

you don't need a special license if you want to pull information from the UCCX internal database. All four variants of UCCX support external data connections. For more details, check the SRND for your particular UCCX version.

You can use either ODBC or JDBC, both are valid options.

It's really up to you if you choose to pour information to a separate database server or not.

Mukesh,

with all due respect, it's not a good idea to link something in  from a source not directly associated with the particular object.  Ciscounitytools may be a good source, but not for a JDBC driver. Also,  you wrote it's a JDBC driver, but in fact, you linked the ODBC driver.  Please be careful next time.

G.

Cisco Employee

UCCX 9.01 Database Access For a Third Party Application

Hi Rodolpho,

You need a PREMIUM license, in case you wish to integrate to an external DB (SQL, Oracle, etc). This is used in case of reading values from an external DB or writing values to the same using the DB Read and DB write steps.

From my understanding, your customer needs to have a reporting capability through their third party application. This is generally termed as Wallboard.

For more information on how to how to configure Wallboard, please check the Administrator guide for UCCX:

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/configuration/guide/UCCX_BK_U767AC77_00_uccx-admin-guide.pdf

Basically, the UCCX has a uccxwallboard user whose password can be changed from the UCCX admin page to be used to integrate with the third party software. This user has access to the Real Time Statistics tables on the UCCX and can be used to pull out the necessary data.

Hope this helps!

Regards,

Arundeep

New Member

UCCX 9.01 Database Access For a Third Party Application

Guys,

Many thanks for support!

Arundeep,

Very useful your information, now we're collecting data from Informix DB. For Specific data from DB, we are using DB Schema Guide for UCCX 9.0.1.


Best Regards!

797
Views
9
Helpful
4
Replies