Access UCCX 8.0 database via php

[SubhashBhimalingam]

Could you provide details on how to access the uccx 8.0 informix database with the help of php. I want retreive data with the help of sql queries.

Awaiting your reply.

Thanks.

[Anthony Holloway]

I have not done this exact thing before, but I have done each one of these things at some point or another.  Here is a point in the right direction.

Step 1 - Obtain the Informix ODBC Drivers for your web server

http://www14.software.ibm.com/webapp/download/search.jsp?rs=ifxdl

Step 2 - Create an DSN connection to the database

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

*See Page 4-2

Step 3 - Write PHP code that leverages the DSN and accesses the database

http://www.webcheatsheet.com/PHP/odbc_connection.php

Optional - Get familiar with the database schema

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/user/guide/uccx70dbschema.pdf

*There is only a schema guide for 7.0 and then 8.5, so you'll use the 7.0 version in 8.0

[SubhashBhimalingam]

Hi Anthony,

Thanks for your help. I am now able to connect to the UCCX informix database via php.

Regards,

Subhash

[Anthony Holloway]

Glad you were able to get it working.  Please don't forget to rate helpful posts.  And not just ones that help you directly, but also those posts that you a reading in passing, and think to yourself, "wow, that was really helpful."