The HCL Informix database server provides the ODBC and JDBC communication and connectivity that enable external data access to the CMS database. There are ODBC and JDBC clients available for Windows and other operating systems. This document covers the Windows clients. Windows 10 and 11 are supported.

All historical CMS database tables, dictionary tables, and customer-provided tables can be accessed by ODBC or JDBC clients through standard ODBC or JDBC enabled software applications.

All standard Structured Query Language (SQL) queries generated by user applications are supported by ODBC and JDBC, as limited by permissions. Table-level read-only permissions restrict access to certain database tables.