Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

UCCX database Access

Hi,

Is it possible to access the database of the UCCX reports? If it is how can we access the database? are there any procedures? Reason for the access on the database is for the customization of reports generated on the UCCX Historical Reports.

Hope somene can help me.

Thanks,

Bryan

8 REPLIES

Re: UCCX database Access

Hey Bryan,

Before creating custom reports from UCCX, we must export the UCCX DB to external data warehouse. Following are the relevant details..

Appending details from "

Cisco Unified Contact Center Express 8.5(1) Historical Reporting Administrator and Developer Guide

"

 

Q. How to export Historical Data to your own Data Warehouse?

A. Use third-party database administration tools such as SQuirreL SQL Client or AGS Server Studio to export Unified CCX historical data to your own data warehouse. Use "uccxhruser" as the username to connect to db_cra database.

Procedure can be found here https://supportforums.cisco.com/docs/DOC-15133

Hope it helps ?

GP.

Pls rate helpful posts !!

UCCX database Access

Hi Bryan,

Please refer the Chapter 4, Creating Custom Historical Reports for Cisco Unified CCX, in the below link.

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

Hope it helps.

Thanks,

Anand

Please rate helpful posts..

Community Member

Re: UCCX database Access

Hi GP and anhand,

appreciate your quick response, Is this also applicable on version 7.0(2)?

Thanks,

Bryan

Community Member

Re: UCCX database Access

Hi GP,

I will look in to the notes and give feedback.

Thanks,

Bryan

Super Bronze

Re: UCCX database Access

Also note that the instructions in the docs aren't correct re how you set up Crystal.

https://supportforums.cisco.com/thread/272601

https://supportforums.cisco.com/thread/272449

https://communities.cisco.com/message/34036

Regards

Aaron Harrison

Principal Engineer at Logicalis UK

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Community Member

Re: UCCX database Access

Hi Aaaron,

Have you tried Powerbuilder for the customization of the reports?

Thanks,

Bryan

Super Bronze

Re: UCCX database Access

Hi Bryan

No, I've not..  we generally want to deliver the reports in the standard HRC client so we do them using a SQL SP and Crystal.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
889
Views
0
Helpful
8
Replies
CreatePlease to create content