Configuring Cisco Unified Intelligence Center to get CVP reports

Here’s what we have initially:

  • Cisco Unified Intelligence Center (CUIC) collects and displays reports about Cisco contact centers.
  • The data for Cisco Voice Portal (CVP) reports is stored on one of its servers, namely the CVP Reporting Server.
  • This server contains Informix databases where the statistics is stored.
  • And there are two reporting databases on this server:
    • cvp_data – contains the basic data for the reports on the performed calls, trunk and VXML application usage;
    • callback – contains the data for the reports on Courtesy Call Back.

To get CVP statistics data, you should configure both databases as Data Sources for CUIC server. Open CUIC web interface, select Data Source tab and click Create to add a new data source. On the page that appears, enter the connection parameters:

  • Name – new data source name;
  • Type – database type. Select Informix for CVP;
  • Database Host – CVP Reporting server IP address or hostname;
  • Port – 1526 (the default Informix port);
  • Database Name – CVP Reporting database name. Default: cvp_data;
  • Instance – Informix Instance name. Default: cvp;
  • Database User ID – Informix database username;
  • Password – this user’s password (configured during the CVP installation);
  • Charset – character encoding. Select UTF-8 for CVP Reporting Server.

After configuring all the parameters, click Test Connection to check the connection to the database. If the test was successful, it will show the Online status:

CUIC Web Interface

Now save the configuration. Repeat the process to configure the connection to the callback database. If everything is correct, both data sources will have the Online status:

CVP Callback

After the Data Sources are configured, import the reporting templates for CVP. They can be downloaded from the CVP server (C:\Cisco\CVP\CVP Reporting Templates):

CVP Reporting Templates Folder

For example, let’s import CVP Call Detail:

CVP Call Detail Template

Select the file to be imported and select the CUIC folder the imported report should be saved to:

CUIC Template Import

CUIC Imported Report Folder

There may be an error during the import. That means you should select a Data Source for the report. Lets fix it:

CUIC Report Data Source Error

CUIC Report Data Source Specified

The imported report will appear in CUIC:

CUIC Imported Report Data

Now run the report and apply the required filters:

CUIC Call Report Filters

A view of CUIC imported data

As you can see, integrating CUIC with CVP Reporting isn’t that complicated. Note that in earlier CVP versions the report database name may be different (Cisco documentation contains the default name cvp_db).

This article was translated from the guide on getting CVP reports in CUIC by Dmitry Benda.

You can skip to the end and leave a response. Pinging is currently not allowed.

14/1/2019

Leave a Reply

Your email address will not be published.