CMS uses an HCL Informix database management system that supports compatible ODBC and JDBC clients. CMS is delivered with this ODBC and JDBC network connectivity enabled. The ODBC and JDBC clients provide direct access to the Informix database that CMS uses and all the CMS call center data.
ODBC is a specification for a database API. Microsoft ODBC is based on the Call Level Interface specifications from X/Open and the International Standards Organization/International Electromechanical Commission (ISO/IEC). ODBC supports SQL statements with a library of C functions. An application calls these functions to implement ODBC functionality. ODBC applications enable you to do the following:
-
Connect to and disconnect from data sources.
-
Retrieve information about data sources.
-
Retrieve information about the Informix ODBC driver.
-
Set and retrieve Informix ODBC driver options.
-
Prepare and send SQL statements.
-
Retrieve information about SQL results and process it dynamically.
ODBC enables you to allocate storage for results before or after the results are available. You can determine the results and the action to take without the limitations that predefined data structures impose. ODBC does not require a preprocessor to compile an application program.
The JDBC API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases, SQL databases, and other tabular data sources such as spreadsheets or flat files. JDBC provides a call-level API for SQL-based database access. JDBC technology enables you to use the Java programming language to take advantage of Write Once, Run Anywhere
capabilities for applications that require access to enterprise data. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment.
Note:
If you choose to develop an application using ODBC or JDBC, Avaya cannot provide support for that application or for any other third-party software or related mapping.
