JDBC Connection URL to UCCX 8.X Historical DB

Answered Question
Aug 25th, 2011

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

I have this problem too.
0 votes
Correct Answer by Aaron Harrison about 2 years 7 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
Average Rating: 5 (3 ratings)
Nathan Luk Sun, 08/28/2011 - 21:20

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

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..

paulwoelfel Wed, 03/28/2012 - 09:15

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

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

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

Login or Register to take actions

This Discussion

Posted August 25, 2011 at 5:52 PM
Stats:
Replies:8 Avg. Rating:5
Views:3767 Votes:0
Shares:0
Tags: No tags.

Discussions Leaderboard