doing table joins between ContactCallDetail and Resource tables to get the “resourceID” reading the name or userID of the Agent answering calls, etc). I’d also recommend doing some reading up on SQL commands, so that you can get more meaningful results (i.e. To get a description of all the tables and fields available, you want to look for the Unified CCX DB Schema Guide for the corresponding version of UCCX.
The queries can be as simple or as complicated as you need. So that finishes up just a simple introduction. As this is just in my test lab, there were many days with no calls at all. Enjoy real-time analytics, reporting and business intelligence (BI. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. Printing the results, we can see just a simple date and number of calls, and these will only be for the business hours (8:00 to 18:00) specified in the query. Progress DataDirect’s JDBC Driver for IBM Informix offers a high-performing, secure and reliable connectivity solution for JDBC applications to access IBM Informix data. Here I followed the guide Create an ODBC Connection to connect to Cisco UCCX serverThe built in user account is “uccxhruser”, and the password for this can be set under CCX Admin > Tools > Password Management.To build my File string, I went to File DSN > Add and then specified the filename, and followed the guide above, and finally saved the result.You then get a file that looks something like this:ĭRIVER=) Installing the whole SDK worked fine though. There’s another standalone executable, but this wouldn’t install for me and had just a cryptic error message that was very unhelpful. I used “Informix Downloads (Informix Client SDK Developer Edition for Windows x86_64, 64-bit)” Easy enough to find on Google and you can choose for which platform.
0 kommentar(er)
