cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
454
Views
0
Helpful
4
Replies

CUIC

j.huizinga
Frequent Contributor
Frequent Contributor

Hello all,

We have a customer with UCCX 11.5 and CUIC (the one that came with UCCX). Customer wants to get data directly from the CUIC database and create own reports. I did some checking, but I could not find API documentation for CUIC.

Is there a way to get data from CUIC and create own reports?

 

Thanks

 

JH

4 Replies 4

Ratheesh Kumar
Advisor
Advisor

Hi there

 

I dont think CUIC expose API for 3rd party applications. 

 

However you can post to the below community as well, as there are so many active CUIC/Web developers.

https://communities.cisco.com/community/developer/reporting

 

 

 

Hope this Helps

Cheers
Rath!


***Please rate helpful posts***

Hi all

 

Thanks for the information. I have done some reading at I think I have to use stored procedures with CUIC (standard). I used RazoSQL and with the stored procedures that I got from the CUIC program I can get the same data.

Can I use SQL statements to get specific data from CUIC? From the UCCX I can get the data, but it seems not from CUIC

Is this correct?

 

JH

 

 

In UCCX we have separate database instances for recording the historical data : 'db_cra' and CUIC db. Currently we can Customize reports by modifying the stored procedures which is run against the db_cra not CUIC.

 

The user which you must have used to establish connection with the CCX db has complete access to the tables in db_cra. However there is a different user which is used by the CUIC itself to access its DB which cannot be used to establish connection with the third party clients. 

 

You can checkout the below CLI reference guide which lists different SQL commands which can be run from Platform CLI for CCX. 

 

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_10_5/maintain_and_operate/guide/UCCX_BK_CEE84C5F_00_cisco-unified-contact-center-express-operations-guide-10-5/UCCX_BK_CEE84C5F_00_cisco-unified-contact-cente...

 

Report Customization : https://communities.cisco.com/docs/DOC-48759

 

 

Regards,

Nikhil

 

 

***Please rate helpful posts***

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: