Instruction manual

Preface CentreVu® CMS Open Database Connectivity
Overview P-1
Preface
Overview 0
Open Database Connectivity (ODBC) is an optional CentreVu
®
Call
Management System (CMS) feature that allows you to access data in the
CentreVu CMS database for use in other software applications such as
spreadsheet programs. With ODBC, you can access the CMS data directly
from your application, without needing to understand database connectivity
or format.
This feature is especially useful for call centers with multiple sites. ODBC
allows access to data at multiple sites for reports. ODBC uses Structured
Query Language (SQL) to access data, eliminating the need to access the
database in the language in which it was written.
The ODBC feature is a client/server feature; that is, the clients must be
attached to a network that is fully functional to access the server. The
“clients” are the computers that are accessing data through ODBC; the
“server” is the CMS machine where the CMS database is located.
R3V6 and R3V8 ODBC work only in English.
Organization of Document 0
Chapter 1 presents an overview of the ODBC feature, its interaction with
other
CentreVu CMS features, and its performance impact. Also included is
an overview of ODBC functionality and its interaction with the
CentreVu CMS
database.
Chapter 2 presents an overview of the off-the-shelf driver that will be used for
the ODBC feature and its function in relation to
CentreVu CMS data. The
majority of this chapter covers basic installation, configuration, and
initialization procedures for the driver on the server and the clients.
Chapter 3 describes the CentreVu CMS open database tables and the items
in the database tables.