Manual

Introduction to the Database Schema
This section contains the following topics:
About the Database Schema, page 53
Entity-Relationship Diagram, page 54
Table Denitions, page 54
About the Database Schema
The Reporting Server hosts an Informix Dynamic Server (IDS) database, where it stores reporting
data in a dened database schema. The schema is fully published so that customers may develop
custom reports based on it, using a customer-provided report presentation product. (Customers
may not, however, extend the schema for their own purposes.)
This schema provides Unied CVP customers with the ability to:
establish database connectivity with commercial off-the-shelf reporting and analytics engines
from popular business intelligence technology vendors, such as Crystal Reports and
Exonyand then build their custom reporting and analytics solutions against the Unied
CVP database schema
join with an ICM HDS database to track call activity across both systems (see "Joining Data
with an ICM HDS Database" (page 85))
The following diagram indicates a common set of incoming and outgoing entry and exit states
for a call to a self-service application.
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
53
Chapter 5