Cisco Cisco Unified Contact Center Express 9.0(1) Troubleshooting Guide

Page of 18
Export Cisco CRS 3.x Data to a Customer Data
Warehouse
Document ID: 65193
Contents
Introduction
 Prerequisites
      Requirements
      Components Used
      Conventions
 Basic Scenario: Microsoft SQL Server 2000 Database
 Variation 1: CRS Database is MSDE
 Variation 2: Customer Data Warehouse is not Microsoft SQL 2000
 Variation 3: Customer Data Warehouse Already Contains CRS Data
      Incremental Export for Call Details Tables
      Data Export for Configuration Tables
 Related Information
Introduction
This document describes how you can manually export historical reporting data from Cisco Customer
Response Solutions (CRS) 3.x to a customer data warehouse in a Cisco IP Contact Center (IPCC) Express
Edition environment.
Note: The data is stored on a remote database (RDB) if you have configured an RDB. However, if you do not
use an RDB, the historical reporting data is available on the Cisco CRS server.
Prerequisites
Requirements
Cisco recommends that you have knowledge of these topics:
Cisco IPCC
• 
Microsoft SQL Server
• 
Components Used
The information in this document is based on these software and hardware versions:
Cisco IPCC Express 3.x
• 
Microsoft SQL Server 2000
• 
The information in this document was created from the devices in a specific lab environment. All of the
devices used in this document started with a cleared (default) configuration. If your network is live, make sure
that you understand the potential impact of any command.