02-20-2014 07:55 PM - edited 03-19-2019 07:55 AM
Just wondering if anyone has been able to get ODBC access into CUCM 9.1 and CCX 9.0?
We are trying to determine if read only ODBC access into our CUCM, and CCX Servers is aloud.
We are trying to utilise Informix ODBC to gather information from the server’s database for CDR and other reporting.
I am trying to find the following information
Service
Protocol
Options
Database Name
02-20-2014 08:14 PM
CUCM = Not possible
CCX = Possible but with support implications
For CUCM you cannot connect over ODBC; however, you can execute SQL queries via the AXL API. CCX allows a read-only ODBC connection for two purposes (officially):
While the wallboard user only has access to those two tables, the uccxhruser account can query any table. It can also create stored procedures but not insert/update/drop data on the tables themselves. Beyond these limits, the product will not impose any limits on what you do, including I/O throttling. TAC may tell you to take a hike if you start having problems and you are making database calls in an unsupported fashion.
The connection details are outlined in the Cisco Unified Contact Center Express 8.5(1) Historical Reporting Administrator and Developer Guide
Please remember to rate helpful responses and identify helpful or correct answers.
02-20-2014 08:40 PM
Thanks for that Jonathan,
Any idea if i can us the AXL API for CUCM as well?
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: