« Back to Cius Developer Questions

How to access UCCX 8.0 informix database?

Combination View Flat View Tree View
Threads [ Previous | Next ]
How to access UCCX 8.0 informix database?
Answer
8/10/11 1:03 PM
I want to access the UCCX 8.0 informix database to retreive data and show it in my cius android application. Right now I am using 'sample data' on mysql via php to test it but now I want to fetch actual data from the uccx database. I am stuck at this point. Your inputs will mean a lot.
 
Regards,
Subhash
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/10/11 6:36 PM as a reply to Subhash B.
The UCCX database schema is here http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/user/guide/uccx85dbschema.pdf It does not contain contain info on connecting to an Informix f database from an Android app. I think that information would come from IBM or Google.
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/10/11 8:40 PM as a reply to Subhash B.
How are you accessing the MySQL database? If you can provide me what your app is using to connect, perhaps I can feed you back the Informix specific matching pieces.

Regards,
Jack Parker
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/11/11 7:46 AM as a reply to Richard Parker.
I have setup mysql in my local server and I am accessing it with the help of php. My app calls the php in the local server. Could you please tell me how is it possible to do it for uccx 8.0 informix database?
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/11/11 1:56 PM as a reply to Subhash B.
You can use uccxhruser (user used for historical reporting purposes for reading data) for connecting the express DB and read data. Reading data puts load on the DB and the performance impact can vary depending on the type of queries. Accessing an Informix database from PHP requires a driver from IBM.
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/11/11 2:19 PM as a reply to David Lender.
The Informix JDBC driver can be downloaded from here.

http://www-01.ibm.com/software/data/informix/downloads.html


the version we use is 3.50.JC6W1.
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/11/11 3:36 PM as a reply to David Lender.
A much better answer than mine.

Regards,
Jack Parker
Flag

RE: How to access UCCX 8.0 informix database?
Answer
8/16/11 7:50 AM as a reply to David Lender.
Thanks for the help.

I am now able to connect to uccx informix database via php.

Regards,
Subhash Bhimalingam
Flag

RE: How to access UCCX 8.0 informix database?
Answer
12/14/12 9:46 AM as a reply to Subhash B.
Hi,
is it possible that you post the example PHP-code to connect to informix database via php.
regards
Pablo Morales01
 
 
Flag