Instruction manual

Open Database Connectivity CentreVu® CMS Open Database Connectivity
ODBC Background and Functionality 1-5
Structured Query
Language (SQL)
1
ODBC uses Structured Query Language (SQL) to query and access
data. Because SQL is a language, queries written in SQL can be used to
access data with different formats. SQL is the basis for relational
database access. The simplest description of a relational database
model is the table—data is stored in rows and columns, and relationships
between tables are established through data items with matching values
between the tables. SQL queries access the data stored in the relational
database tables and extract it for use in other applications. SQL can also
be used to construct data calculations. This is useful if you want to look at
a sum of the data; for example, the total number of calls routed to a
particular split or skill. An SQL query is composed from the
Windows
application for which you need the data. The SQL query function is
embedded in the application itself.
CMS ODBC
Drivers
1
The CentreVu CMS Informix database management system is supported
by the
OpenLink Multi-Tier ODBC Driver. A driver is an implementation of
an ODBC application programming interface that supports a particular
database management system; in this case, the
Informix DBMS used by
CentreVu CMS. More specifically, a driver is a dynamic link library that is
specific to a type of DBMS. The driver manager provides the link
between the user’s applications and the DBMS itself by selecting the
dynamic link library using the format of the data being queried by
processing the received ODBC function calls. More information on the
OpenLink driver and its installation procedures can be found in Chapter
2, “ODBC Driver and Installation.”
ODBC Driver
Functionality
1
The following figure illustrates how drivers provide the interface between
user applications and the data being accessed, assuming that driver
dynamic link library 1 is the
Informix specific library.