[cisco-voip] uccx db access for wall boards?

[Ryan LaFountain (rlafount)]

Hi,

Connecting to the UCCX DB from an external source is documented in the HR Admin and Developer Guide. It’s there because we use the external DB connection most often for custom historical reports. Use the 8.5 Guide so you don’t get mixed up with CUIC custom reports since you’re just looking to connect to the DB. The settings for the driver, what you name the database connection and how to build the connection string are all in there. Sounds like you’re most of the way there if it tests ‘ok’. I would also consider checking out the DB schema guide to make sure you’re looking for the right tables.

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

Also, the wallboard user (I assume you’ve configured the password in AppAdmin on both nodes independently) only has access to RTCSQSummary and RTICDSummary. uccxhruser has access to all tables.

Let me know if you have questions.

Thank you,

Ryan LaFountain
Unified Contact Center
Cisco Services
Direct: +1 919 392 9898
Hours: M - F 9:00am - 5:00pm Eastern Time

On Jan 29, 2014, at 4:17 PM, Brett Looney <brett at looney.id.au<mailto:brett at looney.id.au>> wrote:

Check out the CCX CTI Protocol Developer Guide. I’ve used the CTI API that to create a wallboard we deploy for our customers – no connection to the database required.

B.

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Countryman, Edward
Sent: Thursday, 30 January 2014 04:48
To: 'Cisco VoIP'
Subject: [cisco-voip] uccx db access for wall boards?

There are several free wallboard apps around but they require a connection to the uccx Informix database.

I’ve downloaded and installed the cisco recommended ODBC driver and configured the connection.  Although it test’s Ok, I just cant seem to connect to the DB.

Does anyone know if a Cisco guide for this or if there is anything that has to be enabled on the uccx server 1st?

Has anyone tried using the shareware wall board programs with any success??
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140129/b30b2987/attachment.html>