How to access the db_cra stored procedures in UCCX 8.5?

Version 1
    This document was generated from CDN thread

    Created by: Carlos Trivino on 16-11-2011 11:54:28 PM
    Based on the document 'Cisco Unified Contact Center Express 8.5(1) Historical Reporting Administrator and Developer Guide' on page 4-16 Viewing Stored Procedures for Existing Historical Reports: You can view the existing Historical Reporting stored procedures using third-party tools such as SQuirreL SQL Client or AGS Server Studio. Use ¿uccxhruser¿ as the username to connect to db_cra database.
     
    I have setup SQuirreL SQL to access the db_cra DB but when I connect to the DB I can only see the tables but the stored procedures. Could someone please tell me what has to be done to have access to the Historical Reporting stored procedures through SQuirreL SQL?
     
    Thx.
     
    Carlos A Trivino

    Subject: RE: How to access the db_cra stored procedures in UCCX 8.5?
    Replied by: David Lender on 17-11-2011 09:59:53 AM
    This forum is for UCCX CTI protocol only.  You may wish to post your question in the Contact Center product forum here
    https://supportforums.cisco.com/community/netpro/collaboration-voice-video/contact-center