Creating an ODBC connection with UCCX

Hey everybody,

Today  I want to show you how to create an ODBC connection with UCCX, which can be mainly used for Wallboards/Dashboards.

To be able to access and pull information out from its Database, UCCX already provides some users with some specifics rights. They are:

  • uccxwallboard: Has access to real-time database tables that contain snapshots of real-time statistics, more specifically to tables RTCSQsSummary and RTICDStatistics.
  • uccxhruser:  Has access to many configuration and historical tables in the UCCX database. It can only be used for custom historical reporting and Cisco Unified Workforce Management (WFM).
  • uccxworkforce: Has access to the Team, Resource, and Supervisor tables and it’s used for Cisco Unified Quality Management (QM).

For this connection we are creating now, we are going to use uccxhruser.
Let’s start off going to UCCX >> Tools >> Password Management to set a new password (in case you don’t know)

image

Once done, let’s now focus on the ODCB configuration!

First of all, you need to download the IBM Informix Client SDK. It will allow the client to stablish a ODBC connection with your Database on UCCX.
You can download the SDK here.

  • Go to Control Panel >> Administrative Tools >> ODBC Data Sources (64-bit).
  • Chose the tab System DNS and hit Add.

image

  • You see now a list of available data sources. Select IBM INFORMIX ODBC DRIVER. Click Finish.
  • Time to create a new DNS. In the Tab General, give a name to your connection.

  • Go to the Tab Environment, and fill the information following the rules below:
    • Server Name: Instance name of Informix server of the set up.  Please pay attention because there are tricky rules for entering the name such as:
      1. Name MUST be in lower case (even if your server name are in upper case)
      2. Any hyphens MUST be converted to underscore
      3. If your server name begins with a number, add “i” in front of it.
      4. Add “_uccx” to the end of the hostname.

    For example: If your server name is 1-EMEA-UCCX, you have to enter i1_emea_uccx_uccx

    • Hostname: The actual hostname or IP address of the UCCX
    • Service: 1504
    • Protocol: onsoctcp
    • Options: leave it blank
    • Database name: db_cra
    • UserID: uccxhruser
    • Password: Password of uccxhruser

    image

    • Go now to the Tab Environment.

          Fields Client Locale and Database Locale must be as: en_US.UTF8

    3

    • Go back to the Tab Connection. It’s now time to test if it’s working.

    Click on Apply and Test Connection. You must see that message:

    6

    That’s it for now! I hope this post can be useful !!

    See ya!!

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out /  Change )

    Google photo

    You are commenting using your Google account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s