cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1337
Views
0
Helpful
4
Replies

How to Access IPCC UCCX database?

BureeraSabir
Level 1
Level 1

Dear All,

I am using UCCX version 8.5 and want to access its database.

reading another post i have downloaded Squirrel Sql client  But i dont know the name of the database, name of informix server, and the port number for informix.

Please help me out or suggest an appropriate way to access the database schema.

 

Your co-operation in this matter will be highly appreciated.

 

Best regards,

Bureera Sabir

4 Replies 4

Gergely Szabo
VIP Alumni
VIP Alumni

Hi,

you probably want to read this blog post: http://ninomartinez.wordpress.com/2010/06/03/connecting-to-db_cra-uccx-8/

This document helps you connect to the UCCX database using the excellent Squirrel SQL tool: https://supportforums.cisco.com/document/64301/squirrel-sql-client-setuppdf

You will have to download and install the Informix JDBC driver, available here: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

Good luck.

G.

Dear Gergely,

I have read that pdf and installed informix drivers and squirrel sql client. but still i am unable to connect to database schema because i dont know the details of parameters

db name: i have tried db_cra

port number: i put it default 1526

but this didnt helped me out :(

Best regards

Bureera Sabir

this is the exact Example url i am giving

jdbc:informix-sqli://10.1.80.15:1526/db_cra:INFORMIXSERVER=IPCCadministrator_uccx

and website URL is http://www.informix.com

and class name as described in tutorial

com.informix.jdbc.ifxDriver

so please suggest a way so that i come up with a solution

Again, please read carefully the following blog post: http://ninomartinez.wordpress.com/2010/06/03/connecting-to-db_cra-uccx-8/

It explains how to obtain the database name.

I don't know where you are getting that port, but it's certainly not 1526. IPCCAdministrator_uccx does not seem to be good, either.

I have a working example for you: jdbc:informix-sqli://10.221.92.65:1504/db_cra:INFORMIXSERVER=ivra_uccx;DELIMIDENT=y;

The server's hostname is ivra, and the IP address is 10.221.92.65.

G.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: