McDewey

a) Log in to Unified Intelligence Center on the Unified CCX server. b) In the left pane, click Data Sources. The Data Sources page opens in a separate tab in the right pane. c) Select the Unified CCX data source and click Edit. d) Record the settings in the page so that you can refer to this data later. Step 3 Configure a data source on the Standalone Unified Intelligence Center server to point to the Unified CCX server. a) Log in to the Standalone Unified Intelligence Center using credentials that has report designer permissions. b) In the left pane, click Data Sources. c) Click Create to create a new data source. d) Set the parameters as per the settings you recorded in Step 2d. The database user name should be uccxhruser and the password should match the password you set in Step 1c. Note e) Click Test Connection and verify the settings. If an error is prompted, verify that the settings are correct and try again. Tip Create Custom Stored Procedure Perform the following steps for both Unified CCX nodes, if applicable. Note The Unified CCX database schema details are described in the Database Schema Guide for Cisco Unified CCX and Cisco Unified IP IVR, located at: https://www.cisco.com/c/en/us/support/customer-collaboration/unified-contact-center-express/ products-technical-reference-list.html. Procedure Step 1 Connect to the db_cra database using the uccxhruser username and password. Step 2 Create a stored procedure using third-party tools such as SQuirrel SQL Client and AGS Server Studio. Step 3 Assign execution privileges for the stored procedure to uccxHrUserRole using the following command: Example: grant execute on <your procedure name> to 'uccxHrUserRole'; What to do next See the task flow table in How to Create Custom Reports, on page 3. Cisco Unified Contact Center Express Report Developer Guide, Release 12.5(1) 5 Create Custom Reports Create Custom Stored Procedure