Amr Gaber – Technical Library

Netwrok & Information Security Library

Create an ODBC Connection to connect to Cisco UCCX server

Step 1: Go to Control Panel > Administrative Tools > Data Sources.

Step 2: Select the System DSN tab. ODBC Data Source Administrator window is displayed.

Step 3: Click on Add to create a new DSN.

Step 4: The Create New Data Source window is displayed. From the list of available data sources, select IBM INFORMIX ODBC DRIVER. Click Finish.

Step 5: The ODBC Driver Setup window is displayed. Enter a unique DSN name. Enter a suitable description. Click Apply.

Step 6: Select the Environment tab. Select the Use Server Database locale check box. Ensure that the entry for Fetch Buffer size field is 32767. If default entry is other than 32767, then manually change it to 32767. And change Client locale to value (en_us.819), Click Apply.

Step 7: Select the Connection tab. In the server name field, enter the instance name of Informix server of the set up. The following naming conventions must be followed when creating an instance name:

•Add the letter “i” as a prefix to the instance name, if the host name starts with a number.

•Enter the instance name after converting all upper case letters to lower case.

•Replace hyphens with underscore.

•Append the letters “_uccx” to the instance name.

For example, if the host name is “802UCCX-Ha-Node1“, then you should enter “i802uccx_ha_node1_uccx” in the server name field.

In the host name field, enter either host name or IP address of UCCX server. In service field, enter 1504 which is the TCP port number. In the ‘Protocol’ field, choose ‘onsoctcp’. In the database field, enter ‘db_cra’ which is the database name that stores historical data. In the userId field, enter ‘uccxhruser’ which is the default Historical Reporting user. The password for this user can be set at ‘Password Management’ page of the Unified CCX Administration web interface. The password management page appears under ‘tools’ menu of appadmin. In the password field of ODBC Driver set up page, enter the password which is set at ‘Password management page’ by administrator. Click Apply & Test connection.

Step 8: Ensure that the Test Connection was successful message is displayed. You can view the newly created DSN in the list of DSNs. Close the window.

About these ads

42 responses to “Create an ODBC Connection to connect to Cisco UCCX server

  1. Rick Bramblett May 3, 2011 at 3:25 PM

    Many, many, thanks! Couldn’t find this in the Cisco/IBM doc.

  2. ThankfulUser September 22, 2011 at 10:28 AM

    You are literally a hero!
    Thanks a lot for your help. This should get a higher google rank.
    So:
    Cisco ACD UCCX ODBC setup link informix server name ol_

  3. Vinodh October 28, 2011 at 9:44 AM

    Hi,
    We have got the IBM INFORMIX ODBC DRIVER installed in the client window PC.

    Now to create the DSN in the UCCX server, it is looking for a driver file. Could you pls suggest a driver file to upload in the uccx server.

    Vinodh

  4. Vinodh Kumar October 29, 2011 at 6:29 PM

    Hi,

    Thanks for info, we have got this driver installed in windows pc and made the settings as suggested.

    Could you please share the info on creating DSN in the uccx server. We have no drivers in the drop down list for creating a new Datasource in the uccx server.

    Vinodh.

  5. Daniel January 31, 2012 at 12:25 PM

    Many thanks for this post, extremely useful

  6. fahad March 5, 2012 at 2:40 PM

    Dear Amr,
    I have perfomed the above mentioned steps but it is giving error while configuring the dsn=
    Test connection was NOT successful, [Informix] [Informix ODBC Driver][Informix] Incorrect password or user is not known on the database server. Any suggestions?

    • AmrGaber (CCIE Security) March 5, 2012 at 7:38 PM

      Dear Fahad,
      You are right, there is one more additional step from UCCX side, which is as follows:
      Navigate to the UCCX menu “Tools” > “Password Management” > “Historical Reporting User:
      and Change the Value twice then press The “Save” button.
      and Enjoy reporting.

      • fahad March 6, 2012 at 1:18 AM

        I did and getting the following error now:
        INformix server does not match either DBSERVERNAME OR DBSERVERALIASES..can you tell what to do???

        database name is db_cra

      • AmrGaber (CCIE Security) March 6, 2012 at 5:54 AM

        You probably need to review the part talking about the server name if the host name is “802UCCX-Ha-Node1“, then you should enter “i802uccx_ha_node1_uccx” in the server name field, and check your basic reachability to the UCCX server by using ping the IP-Address of the server, if it doesn’t work, you need to tell me the UCCX version and Informix ODBC Client Version.

      • fahad March 7, 2012 at 2:31 PM

        Thanks. It worked

  7. PhillD April 11, 2012 at 3:55 PM

    Hi, I have a question, we mistakenly added the server name in the connection tab with upper case letters. When we set it to lower case and click apply/test it works fine. When you ok and go back to the connection tab later, it shows the server name in upper case. This is breaking the connection. Is there a way to clear the old name out of memory? I tried uninstalling and reinstalling the ODBC driver, but I got the same problem. Thanks in advance

    • AmrGaber (CCIE Security) April 11, 2012 at 10:43 PM

      Hello PhillD, It seems that your problem is related with the *.dsn file that you are trying to save. Try to locate your DSN Directory and Delete the OLD dsn file, and create another one, and remember to save it in System DSN tab.

      • PhillD April 12, 2012 at 2:08 PM

        Thanks for that. What I find though is that when I delete the DSN from the System DSN tab, and then recreate it, the server name is already populated. And I can edit the name all I like in terms of lower case letters, and it succeeds if you test, but then when you close the tab and re-enter it, the upper case letters are back. I’ve done a search on the server for ‘*.dsn’ and it comes up with no results! Am I missing something obvious?
        Thanks again

      • Troy June 4, 2012 at 10:32 AM

        Hi,
        I would like to use this functionality, but I am unsure what the result will be on the standard crystal reports that come with Cisco Unified CCX Historical Reports.
        Can you confirm, a change of password won’t affect any standard functionality in the program.
        Regards,
        Troy.

      • AmrGaber (CCIE Security) June 5, 2012 at 8:55 AM

        Hello Troy,
        You need to know that “Historical Reporting User” under the Tools menu in UCCX is NOT related with Standard Plugin Came with UCCX “Cisco Unified CCX Historical Reports”, So i’m confirming that the change of Password will NOT affect the standard Functionality in the Historical Program Plugin “Cisco Unified CCX Historical Reports”.

  8. PaulM May 9, 2012 at 3:45 PM

    This only works on a 32bit system. using these steps in a 64bit system using the Informix 64bit driver do not work.

  9. Ruben June 20, 2012 at 5:00 PM

    Hi we have a working IBM Informix ODBC Driver Setup but when we open the Wallboard application the following message appears: odbc query returned no data
    The wallboard data is not loaded. Any ideas?

    • AmrGaber (CCIE Security) June 20, 2012 at 10:27 PM

      Hello Ruben,
      Please make sure of the following:
      1. 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.
      2. Go To Tools -> Real Time Snapshot Config and make sure you have Checked the following:
      a. Data Writing Enable (Checked)
      b. Data Writing Interval (You may set to minimum = 5 seconds).
      c. Cisco Unified CCX CSQs Summary (Checked)
      d. Cisco Unified CCX System Summary (Checked)
      e. (Lastly and very Important) Wallboard System Server Name (Type the IP of the machine Will Use the Wallboard) if Multible use Comma Seperated.
      3. And After you Finish Configuring the ODBC Using the “uccxwallboard”,
      make sure you use this Query “SELECT * FROM rticdstatistics”.
      4. Plus Make sure also that you update your Datasource Frequently when using any Server side scripting (ASP, ASP.NET, PHP, etc).

      I Hope this could Help,
      And Enjoy Wallboarding.
      Amr Gaber

      • Ruben June 21, 2012 at 6:56 PM

        Hi Amr,

        Thank you for the quick response, after ckecking the settings in the Real Time Snapshot Config
        the wallboard is working!!
        Kind Regards,
        Ruben

      • FNBJason October 29, 2013 at 7:18 AM

        Amr,

        After struggling for days to try and get an ODBC connection for a UCCX wallboard application working, the instructions above have fixed it! Thank you so much for this blog post and continually updated comment thread. :-)

        Regards,
        Jason

      • AmrGaber (CCIE Security) October 29, 2013 at 7:49 AM

        You are welcome anytime, Enjoy Wall-boarding :)

  10. Raj November 16, 2012 at 6:06 AM

    Hi Amr, Very useful information, Thanks.
    I have one query related to database used by UCCX. Do you know if UCCX cache the agent,skill,etc information stored in CDS database or access database for every request? I’m exploring if I could edit database directly instead of using Admin GUI. I understand this approach has its own caveats but just want to try and want to know your opinion as well.

    Many thanks,
    Raj

    • AmrGaber (CCIE Security) November 17, 2012 at 3:14 PM

      Hello Raj, I’m Glad that my Article helped you. Unfortunately there is no evidence that The UCCX Cashe the Agent or Skills by any means, But what i believe that Cisco has Avoided editing Directly in the Database After Seeing what has been Done with UCCX Version7.
      They only allowed Specific Account with Specific Roles and Permissions as well, May be i’m wrong but this is what i found after long Investigation, Starting with Version 8.0 till 8.5.
      Wishing you the Best,
      Amr

      • Raj November 19, 2012 at 11:54 PM

        Thanks a lot for your efforts to look into this closely. Appreciate it. Just wanted to make sure if I understood you correctly, say I have user permissions (assuming my customer could get from Cisco) and make database edits affecting agent profile, skill, team, call routing,etc, will that change take effect immediatly i.e. UCCX would use this info for next incoming call. Right?

        Thanks,
        Raj

  11. Asif January 29, 2013 at 1:56 PM

    Hi Amr, In my scenario i have a secondary UCCX which is not accessible from some user’s location but whenever that secondary node is up the UCCX historical reporting tool is trying to access the db_cra database from that node. I want to change this behavior. Can you tell me from where I can change this setting?
    Thanks
    Asif

    • AmrGaber (CCIE Security) January 31, 2013 at 11:21 AM

      Hello Asif, Unfortunately i Don’t have a Direct Solution for your Case, But it seems that your “Historical Report” App that you Installed, you Downloaded it from the Other Node ?
      The Easiest way to resolve this Issue is to Uninstall the Existing App and re-Install it From the first Node.
      I Hope This could be Helpful.

  12. Wcardenase January 29, 2013 at 6:05 PM

    I did and getting the following error now:
    INformix server does not match either DBSERVERNAME OR DBSERVERALIASES..can you tell what to do???

    The CCX System version: 8.5.1.11003-32
    The IBM Informix ODBC 3.50 TC9

    Thanks for your help

  13. muhamhus April 28, 2013 at 5:13 PM

    Hi AmrGaber,

    I have installed the Informix ODBC Driver ver 3.00 and I am running UCCX 8.5.

    Followed your steps as mentioned and read other people comments. In server name field, I am putting “i” before the hostname and converted into lowercase with underscore and appending it with “_uccx1″ which is my DSN.

    I can ping the machine with the hostname but For some reason, I am still getting the “DBSERVERNAME OR DBSERVERALIASES …… ” error.

    I am here kind of stuck and have tried in different ways to be sure about. Is there anything you can look into for me ?? I would appreciate your assistance.

    Thanks

    Regards
    M Taha

    • AmrGaber (CCIE Security) April 29, 2013 at 8:44 AM

      Hello M Taha,
      What i suspect that you have added “i” before the name that is not Beginning with Letters, and try to double check that you Appended the name with “_uccx” not “_uccx1″ as you typed.
      I hope that worked with you. If you found it easier to send me the name to verify it, i’m good with that amro_gaber at hotmail.
      Wishing you the best,
      Amr Gaber

  14. Jawad Hassan November 1, 2013 at 3:46 PM

    Hi,
    Can anybody help me, how i develop real time report with UCCX Informix DB using SSRS as front end?
    What i have done so far is created a DSN using IBM informix ODBC driver, tested the connectivity and it’s ok. But still I am unable to get data in real time report whose query is based on RtCSQsSummary table of UCCX Informix DB. I used the same DSN connection at the backend of report.

    Appreciate a quick response.

    Regards,

    • AmrGaber (CCIE Security) November 7, 2013 at 8:08 AM

      Salam Jawad,
      You have to use another UCCX user called “uccxwallboard” Instead of uccxhruser.
      and use the table name of “rticdstatistics”.
      Kindly see my reply to Ruben on June 20, 2012 at 10:27 PM. It has all your answer.
      My Sincere Regards,

  15. Steve November 6, 2013 at 10:08 PM

    Anyone have luck getting this to work in a 64 bit system? It works like a charm on XP but can’t get it to work on my Win 7 machine. I downloaded a newer 64bit driver 4.10.FC2DE. Please let me know if anyone has had any luck.

  16. aj November 12, 2013 at 11:03 PM

    Hi, I can’t make the ODBC connection. I get this error ““DBSERVERNAME OR DBSERVERALIASES …… ” error.” I am using IBM Informix ODBC driver 4.10FC2DE, Windows 7 64bit, CCX ver. 9.0. Please help.

  17. free annual credit report May 4, 2014 at 12:50 PM

    Thanks a lot for sharing this with all folks you actually
    know what you are speaking approximately! Bookmarked.
    Kindly additionally talk over with my site =).
    We can have a link trade contract among us

  18. Sherri May 6, 2014 at 7:15 PM

    Hi, I followed all your instructions and get the following error: ‘Test connections was NOT successful. Incorrect password or user user@(ip_address of local server) is not known on the database server. Where should this user and credentials be set?

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: