DOCSHUB DOCSHUB
  • Library
  • Avaya Support Site Avaya Learning Blogs Videos & Podcasts Knowledge base Report Product bugs
Deutsch English Español (México) Français Français (Canada) Italiano Magyar Nederlands Polski Português (Brasil) Русский עברית العربية 中文(简体) 中文(繁體) 日本語 한국어
Login
DOCSHUB DOCSHUB
  • Library
  • Avaya Support Site Avaya Learning Blogs Videos & Podcasts Knowledge base Report Product bugs
  • Deutsch English Español (México) Français Français (Canada) Italiano Magyar Nederlands Polski Português (Brasil) Русский עברית العربية 中文(简体) 中文(繁體) 日本語 한국어
Login

Using ODBC and JDBC with Avaya Call Management System

Table of Contents

Type to filter navigation items by title
  • Notices
  • Introduction
    • Purpose
    • Change history
  • ODBC and JDBC overview
    • ODBC background and functionality
      • Data access through ODBC
      • Data access diagram
      • SQL for ODBC data
      • CMS support of ODBC and JDBC
      • ODBC data usage
      • Data queries in ODBC
    • ODBC and JDBC software
    • ODBC and JDBC features
      • Language
      • Supported number of logins
      • Performance impact
      • Table permissions, security and port allocation
      • Informix User definition
    • CMS and ODBC interoperability
    • CMS database logic structure
      • Agent tables
      • VDN tables
      • Circular structure tables
  • ODBC software configuration
    • Installing ODBC on a Windows client
    • Requirements
    • Installing ODBC on Windows
    • Configuring an ODBC data source
    • Removing a data source
    • Configuring ODBC tracing options
    • Viewing installed ODBC data source drivers
  • JDBC software configuration
    • Installing JDBC on Windows
    • Requirements
    • Installing JDBC on a Windows client
  • Providing secure access to the CMS database
    • Preparing to set secure database access
    • Adding members to the dbaccess group
    • Setting secure access permissions in the CMS database
    • Removing ODBC access permissions for a specific user ID
    • Returning the CMS database to public permissions
  • Encrypting the ODBC and JDBC connections
    • About the Informix TLS and SSL encryption utility
    • Managing certificates for Informix TLS and SSL encryption
    • Exporting a PKCS 12 certificate from the cmsweb.jks certificate
    • Enabling Informix network encryption
    • Updating the Informix network encryption certificate
    • Disabling the Informix network encryption
    • Checking if Informix encryption is enabled
    • Viewing the Informix encryption certificate details
    • Installing the Informix encryption certificate on your Windows computer
    • Updating the Informix encryption certificate on a Windows computer
  • Troubleshooting
    • ODBC and JDBC encryption and certificates
    • Network support
    • Server log files and monitoring
    • Client trace
  • Resources
    • Documentation
      • Finding documents on the Avaya Support website
      • Avaya Documentation Center navigation
    • Viewing Avaya Mentor videos
    • Support
      • Using the Avaya InSite Knowledge Base
  • Glossary
    • Abandoned call
    • ACD Call
    • Access permissions
    • Adjunct/Switch Applications Interface (ASAI)
    • After Call Work (ACW)
    • Application Programming Interface (API)
    • Automatic Call Distribution (ACD)
    • Backup
    • Calculation
    • Call Management System (CMS)
    • Call Management System Query Language (CMSQL)
    • Call Vectoring
    • Call Work Code (CWC)
    • Avaya Supervisor
    • Current interval
    • Daily data
    • CMS database
    • Database item
    • Database Management System (DBMS)
    • CMS database tables
    • Dictionary
    • Driver manager
    • Dynamic link library
    • Entity
    • Exception
    • Historical database
    • Historical reports
    • Informix
    • Informix SQL
    • Intrahour interval
    • Local area network (LAN)
    • Monthly data
    • Open Database Connectivity (ODBC)
    • Previous interval
    • Read permission
    • Real-time database
    • Single-user mode
    • Structured query language (SQL)
    • Switch
    • Trunk
    • Trunk group
    • Vector
    • Vector directory number (VDN)
    • Weekly data
    • Write permission
Home
Using ODBC and JDBC with Avaya Call Management System
Monthly data

Monthly data

Share this page

  • On LinkedIn
  • On X
  • On Email

PDF Export Options

  • This Topic
  • Entire Document
Last Updated : Apr 15, 2024 |
Contact Center - Performance Solutions
Avaya Call Management System
Administering
Administrator
21.0
Expert
Daily data that has been converted to a monthly summary.
Send Feedback

Topic navigation

Previous Topic

Local area network (LAN)

Next Topic

Open Database Connectivity (ODBC)

In this article

STAY CONNECTED

Twitter Youtube Linkedin
Footer Icon
  • Sitemap
  • Terms of use
  • Privacy
  • Cookie Policy
  • Trademarks
  • Accessibility
© 2026 Avaya LLC