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 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
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.