Instruction manual

ODBC Driver and Installation CentreVu® CMS Open Database Connectivity
ODBC Driver 2-2
ODBC Driver 2
Introduction 2
An OpenLink Multi-Tier ODBC driver facilitates client querying of data for
extraction from the
CentreVu CMS database. The client driver supports
client access from
Solaris , Windows 95, Windows 98, Windows 2000,
and Windows NT clients. All historical CMS database tables, dictionary
tables, and customer-defined tables can be accessed by ODBC clients
through standard Structured Query Language (SQL) queries. All standard
SQL queries are supported by the ODBC driver as limited by
permissions. Table-level permissions will restrict access to database
tables. The tables accessible in
CentreVu CMS Release 3 Version 8 are
described in detail in Chapter 3, “Database Tables.”
Function 2
OpenLink ODBC drivers are composed of two main components: a
generic ODBC driver and the
OpenLink Request Agent. The OpenLink
Request Agent resides on the client and interfaces with the ODBC driver
through proprietary protocol. ODBC drivers are controlled by an ODBC
driver manager, in this case, the
OpenLink Request Broker. The
OpenLink Request Broker resides on the server. ODBC uses data source
names as the link between the ODBC Request Broker and the relevant
ODBC driver for a particular database.
The
OpenLink ODBC driver is a multi-tier driver; that is, the driver
controls both ODBC calls and the manner in which these calls are
transferred to the relevant database management system (in
CentreVu
CMS,
Informix ) over the communications infrastructure. The OpenLink
Request Broker provides the link between the user’s applications and the
database management system (DBMS—in CMS,
Informix ). Once it is
installed and administered, the ODBC driver and its components are
transparent to the client. The CMS ODBC feature allows multiple,
synchronous accesses from clients, users, and/or applications.
Supported Logins 2
The CMS ODBC feature supports up to five or ten simultaneous logins, in
increments of five, depending on your licensing agreement.
Additional
Information
2
For additional information on the ODBC driver, see the on-line help file
that is included on the Call Management System
OpenLink ODBC Driver
compact disk.