UCCX 10 How to access tables to get data for 3rd party report tool

[lleweyiss]

I have UCCX 10.6  , HA environment.  I have downloaded the Schema that provides information about the tables.  I have located in the GUI the user name Cisco created: uccxhruser  and I have set the password on both servers.  This is not my area of expertise, but I have Developers that want to be able to pull data from the tables so they can create reports.    Since this is no longer a Windows box , I dont know "how" they get access - when / where do they put that  ' username / pswd ' information to be able to get to the tables.

I assume they could write some sql queries to get the data, I just dont know how to tell them to get there.

We do use CUIC and the reports that that come with it, I have copied a Live Data and made a custom report.  So for the most part I am ok there.

They have several other statics from other aspects of the call center that they want to add to some of the information they want to pull from the cra database tables to make an overall view for management.

[jbushong2]

Search for the Cisco Unified CCX Database Schema Guide. The information in the guide should enable your SQL guru to run queries against the proper tables.

[Graham Old]

The CUIC that comes with CCX is the standard version, that means you can't write new reports. There is no option to upload new SQL queries.

You can get an premium CUIC as a standalone system and this will allow you to create new reports which you can export and import into your CCX CUIC. The premium system is expensive but you used to be able to get a 90 day demo license.

The CCX database is IBM Informix and you can download a free IBM driver for Informix. Once you have that installed you can create an ODBC connector and read the CCX database directly.

If you go the IBM Informix route search the support forums for how to set it up

Graham

[lleweyiss]

jbushong2 - My initial inquiry says I got the Schema guide, it doesn't tell you how to set it up (or I missed it ).

Graham, thanks for the information.   We did get the premium, and thus far I have copied /revised /exported / imported reports to some degree.   So I am ok with that portion.

The developers want to pull stats that they will combine with other stats from other systems to give our managers one place for an overall look at that the call center. 

So we will go the IBM Informix route with the ODBC connector ... this post was asking for "how" to set that up. Thus far I could not find it in forums ... hoping someone will respond to this post with some guidance on that part .

[Graham Old]

See this link in the administration guide, its for a wallboard but if you change the user ID you can access all the DB.

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_10_5/config/guides/UCCX_BK_U9F91527_00_unified-ccx-administration-guide-release-10-5/UCCX_BK_U9F91527_00_unified-ccx-administration-guide-release_chapter_010010.html#UCCX_TK_C6EA6FEE_00

For the user ID use the "uccxhruser" and its password not the "uccxwallboard"

Graham

[lleweyiss]

Graham,

thanks so much , greatly appreciated, I will check it out !