Amr Gaber – Technical Library
Cyber 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.
Many, many, thanks! Couldn’t find this in the Cisco/IBM doc.
LikeLike
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_
LikeLike
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
LikeLike
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.
LikeLike
Hello Vindho,
Can you please let me know how you need to install a New DSN Datasource in the UCCX Server, and which version you are Using ?
LikeLike
Hi AmrGaber,
Thanks for your reply….
In the UCCX server under Subsystem — Database — Datasource. we are trying to add new, since there is no drivers available in the dropdown trying to upload a driver in the server.
Subsystem — Database — Drivers.
Need to know which verison of driver file need to be uploaded and from where I can download a driver file..
Vinodh..
LikeLike
Hi Vinodh,
Here you can find the ODBC Driver for IBM Informix to Download
http://www.ciscounitytools.com/Applications/CxN/InformixODBC/InformixODBC.html
Enjoy reporting.
LikeLike
Many thanks for this post, extremely useful
LikeLike
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?
LikeLike
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.
LikeLike
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
LikeLike
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.
LikeLike
Thanks. It worked
LikeLike
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
LikeLike
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.
LikeLike
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
LikeLike
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.
LikeLike
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”.
LikeLike
This only works on a 32bit system. using these steps in a 64bit system using the Informix 64bit driver do not work.
LikeLike
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?
LikeLike
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
LikeLike
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
LikeLike
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
LikeLike
You are welcome anytime, Enjoy Wall-boarding 🙂
LikeLike
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
LikeLike
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
LikeLike
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
LikeLike
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
LikeLike
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.
LikeLike
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
LikeLike
Hello Wcardenase, you have to double check the Entries in the
“Server Name” & “Host Name” and If you used a Name in the Host Name check your DNS Record and Reverse DNS as well.
LikeLike
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
LikeLike
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
LikeLike
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,
LikeLike
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,
LikeLike
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.
LikeLike
I’m having problems with this too. The 64 bit drivers installed correctly but I couldn’t access Informix using Visual Studio. When I uninstalled the 64bit drivers and installed the 32 bit drivers the INFORMIX driver is no longer visible in the ODBC DSN tool of Windows.
LikeLike
It Should be Okay Peter on Windows 2008 With 64-bit, i’ve just Tried and Configured the ODBC to UCCX without having Problems,
Please Follow Simple Step below:
1. Surf http://www14.software.ibm.com/webapp/download/search.jsp?q=&pf=&S_TACT=&S_CMP=&status=Active&sr=1&cat=&q0=&k=ALL&b=&pn=&pid=&rs=ifxdl&fpf=Windows+%2864bit%29&fdt=&flang=&sb=rd&ibm-search.x=18&ibm-search.y=7&ibm-search=Search
2. This is the Important Part, Choose (Windows (64bit) from the Limit-to Drop Box.
3. Download Informix Downloads (Informix Client Software Development Kit for Windows x86_64, 64-bit) Version (3.50.FC9)
4. After Installing it on Windows 2008, Choose the 32-Bit Informix Driver when you Create the Entry in the ODBC Console.
5. Follow the Same Steps above, you should be Okay.
Best of luck
LikeLike
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.
LikeLike
Sucess!!. I unticked the Use Server Database Locale and re ticked it and it worked.
LikeLike
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?
LikeLike
Can anyone tell me if the CISCO snapshot has to point to the CCX server or can it point to any server?
LikeLike
Yes you can point to any server.
LikeLike
Can it be configured on the back up uccx server or does it have to be the master?
LikeLike
It Always can be Configured on the Backup, but you need to Configure the Wallboard IP on the Active one First, then you Configure your ODBC to point to any of them.
LikeLike
Ok so my IT team has been have been trying to configure a wallboard for a few months now and it seems like we are close but might be missing some things.
When we run a query we can pull all the table headers but all the fields are “0” I can see the SQL snapshot database on the wallboard server and it is being updated as the date modified for the file is always recent.
My confusion comes from not understanding how the wallboard pulls the data from the ODBC database since the snapshot is pointing to the wallboard sever and the ODBC database is configured to the UCCX server? We configured the ODBC database with the uccxwallboard and the test confirmed the connection
This is what comes up when we run the SELECT * FROM RtCSQsSummary
[csqname] = “EUS-Approve”
[loggedinagents] = “0”
[availableagents] = “0”
[unavailableagents] = “0”
[totalcalls] = “0”
[oldestcontact] = “0”
[callshandled] = “0”
[callsabandoned] = “0”
[callsdequeued] = “0”
[avgtalkduration] = “0”
[avgwaitduration] = “0”
[longesttalkduration] = “0”
[longestwaitduration] = “0”
[callswaiting] = “0”
[enddatetime] = “5/3/2015 1:14:23 AM”
[workingagents] = “0”
When I look at the database tables on the wallboard server I can tell they are being updated real time as the modified date is recent. This configuration has been driving me bonkers. Any assistance would be truly appreciated. Which I could share screenshots.
LikeLike
Hello Mario,
I Think you should Use Table “rticdstatistics” to pull the Wallboard Data From.
I Included a sample .asp File here, so you may have an idea about what to be pulled.
btw: the below code is live .asp file connected to a Wallboard ODBC which i use till now.
———————————————————-
strsql = “SELECT * FROM rticdstatistics”
Set objRS = objCN.Execute(strsql)
While Not objRS.EOF
Response.Write “
”
Response.Write “
”
Response.Write “
”
Response.Write “
”
queuedcalls = objRS(“callsWaiting”)
If queuedcalls > queuelimit Then
Response.Write “
”
Else
Response.Write “
”
End If
‘ Response.Write “
”
oldinqueue = objRS(“convoldestContact”)
If oldinqueue > oldinqueuelimit Then
Response.Write “
”
Else
Response.Write “
”
End If
Response.Write “
”
Response.Write “
”
Response.Write “
”
Response.Write “
” & “
” & VbCrLf
lastupdate = objRS(“endDateTime”)
objRS.MoveNext
Wend
objRS.Close
objCN.Close
Set objCN = Nothing
Set objRS = Nothing
LikeLike
Hi, I have a Data Source created in SSRS that is connected to the UCCX server via the Informix ODBC driver (32 bit). My report in SSRS is built to display agents and their skill levels. This report will run and return data in SSRS. But, when I deploy the report to the report server I get the following error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘Cisco_UCCX’. (rsErrorOpeningConnection)
Informix ODBC Driver (32 bit) has been installed on the report server and a System DSN created with successful connection test..
Could the post above that talks about using a different username other than uccxhruser be the problem?
LikeLike
I’m getting the following error.
“Test connection was NOT successful.[Informix][informix ODBC Driver][informix]Database not found or no system permission.”
The UCCX instance name is “POC-UCCX” refer below for confirmation.
admin:show network cluster
10.3.2.184 poc-uccx.cop.int poc-uccx Publisher authenticated
Server Table (processnode) Entries
———————————-
POC-UCCX
Successful
So I entered “poc_uccx_uccx” as the server name without quotes. Am I doing anything wrong?
LikeLike
Hello Shayan, in some cases you need to verify that the IP that you are connected from is typed in Menu -> Tools -> Password Management -> Wallboard System Server Name.
And try again, that might be your problem.
Because you didn’t mention which user you are using to connect to the DB?
LikeLike
Hi AmrGaber,
How can we connect to Informix Database Server on UCCX via db admin rights on the database server ? Sometimes, we need to get backup or create some additional reporting user which has readonly accounts. As far as I know,there is a “informix” account whcih sysadmin on Informix but we do not have its password.
I can connect to Informix with uccxhruser but it has only readonly rights.
thanks,
Sedat Duztas
LikeLike
Unfortunately Sedat it is not allowed by Cisco to connect as admin.
LikeLike
I am trying to connect a wallboard solution with uccx 10.0.(1), and provided the below information while creating the ODBC
Server name : handbscsvrccx03_uccx
Host Name : 10.148.3.30
Service :1504
protocol : onsoctcp
database name : dba_cra
userid : uccxwallboard
password :actual password
But i am getting an error that invalid userid or passoword, I am using informix ODBC driver 4.10 (clientsdk.4.10.FC6DE.WIN)
Santhosh
LikeLike
Hi Santhosh,
Please read the Amr post again specifically step 7.
I believe, In the connection setting you need to use uccxhruser as userid and The password for this user can be set at ‘Password Management’ page of the Unified CCX Administration web interface.
HTH
LikeLiked by 1 person
Hello Santhosh,
Most probably you need to review the steps of your configuration, i highly recommend looking at the reference Admin Guide Page (328) at the following link
Click to access UCCX_BK_W1AF9DDD_00_uccx-admin-guide-10-0.pdf
Section (Create System DSN for Wallboard),
Wishing you all the Best,
Amr Gaber
LikeLike
This guide is helpful, but I cannot make connection. I followed every step and tried setting up ODBC in both 64bit and 32bit using a windows 10 machine. I keep getting error message : Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix] Cannot connect to database server (iuccx1_uccx)
LikeLike
Can some one please help , the ODBC screen procedure explains creating connection using uccxhruser but all the details below are talking about uccxwallboard user? which account should be used . And what select statement should be used if we use uccxhruser?
LikeLike
You need to use uccxhruser for making an ODBC connection and use the statement inside the LDAPList.asp file attached
And to build the Query String you need to do it in the following format:
sProperties = “givenName,sn,ipPhone”
‘sQuery = “(&(objectclass=user)(givenName=” & sFirstName & “*)(sn=” & sLastName & “*));”
sQuery = sQuery & sProperties & “;subtree”
Regards,
Amr Gaber
LikeLike
We are trying to gather historical data.
LikeLike