Instruction manual

Open Database Connectivity CentreVu® CMS Open Database Connectivity
ODBC Background and Functionality 1-6
Uses for ODBC
Data
1
Data extracted and stored by an ODBC application can be used by
ODBC-enabled programs, such as workforce management packages,
network routers, and blended inbound/outbound applications. Data can
also be extracted for use in ODBC-enabled programs, including
spreadsheets and report writers. An example of an ODBC data
application is generating reports using data from multiple call center sites
and their databases.
Requesting Data
Using ODBC
1
The ODBC driver installed on the CMS is compatible with the CMS
Informix database. All queries in ODBC must be composed to ensure
continued CMS performance. The query is invoked differently in each
Windows application. For more information on how your application
interfaces with ODBC, refer to your application’s user documentation. For
more information on how to compose efficient database queries, see the
“Edit | Queries” chapter in the
CentreVu® Supervisor Version 8 Report
Designer
document, Lucent Technologies (585-210-930), and
“Performance Impact”
and “Structured Query Language (SQL)” sections
in this chapter.
ODBC Driver Manager
Driver:
Library 1
Driver:
Library 2
Driver:
Library
3
CentreVu CMS Informix database
Windows -based Application
Communications Software
CLIENT
CMS
SERVER