03-26-2014 12:14 AM - edited 03-14-2019 01:17 PM
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
03-26-2014 12:29 AM
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.
03-26-2014 12:53 AM
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
03-26-2014 12:56 AM
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
03-26-2014 01:23 AM
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.
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: