Cisco Unified CCX System Summary (Checked)Į. Cisco Unified CCX CSQs Summary (Checked)ĭ. Data Writing Interval (You may set to minimum = 5 seconds).Ĭ. Go To Tools -> Real Time Snapshot Config and make sure you have Checked the following:ī.
The Client Accessing the UCCX Database Server is using the password configured under the Menu -> Tools -> Password Management -> Change Password for user Wallboard user which will be “uccxwallboard” in your ODBC Connection.Ģ. You can view the newly created DSN in the list of DSNs. Step 8: Ensure that the Test Connection was successful message is displayed.
In the password field of ODBC Driver set up page, enter the password which is set at ‘Password management page’ by administrator. The password management page appears under ‘ tools’ menu of appadmin. The password for this user can be set at ‘ Password Management’ page of the Unified CCX Administration web interface. In the userId field, enter ‘ uccxhruser’ which is the default Historical Reporting user. In the database field, enter ‘ db_cra’ which is the database name that stores historical data.
In the ‘Protocol’ field, choose ‘ onsoctcp’. In service field, enter 1504 which is the TCP port number. In the host name field, enter either host name or IP address of UCCX server.
Step 3: Click on Add to create a new DSN. ODBC Data Source Administrator window is displayed. There are many clients available on the web, on this guide I will use the Server Studio from AGS which is a free client and you can download it here.Step 1: Go to Control Panel > Administrative Tools > Data Sources. Click on “Apply and Test Connection” and ensure the connection is successful. Password: Password of the username (reset from the password management page)ģ.UserID: The wallboard user or uccxhruser.Hostname: The actual hostname or IP address of the UCCX.The servername will be “i1_uccx116pub_uccx” Hostname: UCCX116PUB-1 = Servername will be “uccx116pub_1_uccx” Hostname: UCCX116PUB = Servername will be “uccx116pub_uccx” Add “_uccx” to the end of the hostname.If the hostname of the UCCX begins with a number, add “i” in fornt of it.Any hyphens to be converted to underscore.All upper-case letters to be converted to lower case.
There are specific rules for entering the name and they have to be followed:
By default 64 bit Windows runs the ODBC Administrator Utility 64 bit instead of the the one that we just installed (32 bit), this causes the IBM INFORMIX ODBC DRIVER option NOT to be visible, you can find the ODBC Administrator Utility 32 bi tat ‘ C:\Windows\SysWOW64\odbcad32.exe‘.Ģ.
In order to keep things simple you can download the IBM Informix Client SDK Install 4.10 TC7right here, remember to run the installer executable with windows “admin” rights.
You can find the latest SDK directly from the IBM website but you will find an unpleasant registration process. First we need to download the IBM Informix Client SDKthat will allow the client to establish the ODBC connection with the CCX DB.uccxwallboard: This user has access to real-time database tables that contain snapshots of real-time statistics, specifically to tables RTCSQsSummary and RTICDStatistics.įor the purpose of this configuration we are going to use the uccxhruser.uccxworkforce:This user has access to the Team, Resource, and Supervisor tables and it’s used for Cisco Unified Quality Management (QM).uccxhruser: This user has access to many configuration and historical tables in the UCCX database and should only be used only for custom historical reporting and Cisco Unified Workforce Management (WFM).UCCX provides three different users that can be used to access the database directly in order to extract information for the purposes of wallboard applications, Quality Management, Workforce Management, and custom historical reporting.