Cisco Unified Intelligence Center and CVP Reporting Server Integration Example

Greetings to everyone! I decided to write this post as a small addition to the Cisco DUIC course. This course discusses Cisco Unified Intelligence Center (CUIC), which provides reports for Cisco contact center products. The course describes the integration of CUIC and UCCE quite well, but there is a very small amount of information about how to configure CUIC for CVP reports. Let's discuss it now.
The data for CVP reports are stored on one of its servers - CVP Reporting Server. This server has Informix databases, where, in fact, the required reporting statistics are stored. There are two such reporting databases on this server:

  - cvp_data - contains main data for reports on calls, trunk usage and VXML applications;

  - callback - here are the data used by reports on callbacks (Courtesy Call Back feature).

To obtain CVP reporting data you must configure both databases as Data Sources in the CUIC server. Open CUIC web interface, select the Data Sources drawer on the left, and then click Create button to add a new data source to the CUIC. In the window that opens, enter the connection parameters :

- Name - Enter the name of this data source;
- Type - Select Informix for CVP;
- Database Host - Enter the IP address or DNS name for the CVP Reporting server;
- Port - 1526  (the default port for Informix database);
- Database Name - Enter the name of the reporting database on the Unified CVP reporting server. It can be cvp_data or callback (the default DB names).

- Instance - Specify the instance name of the database you are connecting to. Default is cvp
- Database User ID - Enter the User ID for the Reporting User who is configured in the Operations Console to access the Unified CVP reporting database.
- Password - Enter and confirm the password for the database user.
- Charset - Select UTF-8 for the Unified CVP Informix database. If this is not set correctly, Unified IC will be unable to connect.

After setting all the parameters, you need to check the connection to the CVP Reporting database by clicking the Test Connection button. If everything is configured correctly, the Online status will appear:

Next, save the settings. The configuration of the callback Data Source is similar. If the setttings are completed properly, then both new data sources will have the status Online:

After setting up Data Sources, you need to import stock (Cisco standard) reports for CVP. They can be downloaded from the CVP server  (C: \ Cisco \ CVP \ CVP Reporting Templates):

Let's import CVP Call Detail report now to demonstrate how the integration works:

Select the file to import and specify the CUIC subcategory where the imported report will be located:

In the process of importing an error can appear, indicating that the Data Source should be set for this report. Just correct it:

The imported report has appeared in CUIC:

Then we can run the report and apply the necessary filters:

 

As you can see, the integration of CUIC and CVP Reporting is not so complicated as it may seems. It is worth to say that the name of the report database may be different in the earlier releases of CVP (Cisco documentation gives the default name cvp_db).

Thank you for reading this post and good luck in your CUIC implementations!