JDBC Connection URL to UCCX 8.X Historical DB

Answered Question
Aug 25th, 2011
User Badges:
  • Bronze, 100 points or more

Hi guys,


I'm trying to setup a JDBC connection to the UCCX db_cra database using the uccxhruser. I'm trying the JDBC URL:


jdbc:jtds:sybase://uccxhostname:1504/uccxhostname_uccx


But can't seem to connect. I think I have the DB name bit wrong. Anyone else setup a connection that can advise what they used?


Cheers,

Nathan

Correct Answer by Aaron Harrison about 5 years 6 months ago

Hi


It's Informix... assuming you have the informix JDBC drivers set up:


jdbc:informix-sqli://uccxhostname:1504/db_cra:INFORMIXSERVER=uccxhostname_uccx


Regards


Aaron


Please rate helpful posts..

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (3 ratings)
Loading.
Nathan Luk Sun, 08/28/2011 - 21:20
User Badges:
  • Bronze, 100 points or more

Hi Shalu,


Thanks for that but I'm trying to connect to the UCCX sybase historical reporting database not an external SQL server as per that post. Do you have what the connection URL should look like for this?


Cheers,

Nathan

Correct Answer
Aaron Harrison Mon, 08/29/2011 - 04:53
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi


It's Informix... assuming you have the informix JDBC drivers set up:


jdbc:informix-sqli://uccxhostname:1504/db_cra:INFORMIXSERVER=uccxhostname_uccx


Regards


Aaron


Please rate helpful posts..

Nathan Luk Mon, 08/29/2011 - 05:28
User Badges:
  • Bronze, 100 points or more

Ahhh right. Wrong type. That worked a treat thanks for that!

Paul Woelfel Wed, 03/28/2012 - 09:15
User Badges:

Hi,


I've tried to connect to the Historical DB of UCCX 8.5, but I'm getting an exception "No connect permission" if I try to login with the os admin.


Caused by: java.sql.SQLException: No connect permission.      at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3609)      at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3934)


If I use a normal Administrator account, I get an "Incorrect password or username" exception:

Caused by: java.sql.SQLException: Incorrect password or user com.informix.asf.IfxASFRemoteException: username is not known on the database server.      at com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1205)


Which user could be used to connect to the database?

anchoudh Wed, 03/28/2012 - 09:24
User Badges:
  • Red, 2250 points or more

Hi,



In  regards to the historical user queries in 8.x the user ID is  "uccxhruser" and the password of this user can be changed through UCCX  administrator - tools - paswword managent page.


Section "Creating a System DSN for Wallboard" also provides some pointers on how to create a DSN connection to UCCX database

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_0/configuration/guide/uccx801ag.pdf


Hope this helps.


Anand


Please rate helpful posts..

anchoudh Wed, 03/28/2012 - 19:30
User Badges:
  • Red, 2250 points or more

Hi Paul,


Glad to know that its working :-).


Please don't forget to rate the helpful posts, by clicking on the stars below the right answers.


Thanks,

Anand

Actions

This Discussion