The Database tab displays all database pools used by Genesys Quality Management Suite. The database pools are used by GQM modules in order to connect to various databases (for example to your Oracle instance for GQM) and contain all necessary information such as DB server IP addresses, ports and login credentials.

Using the pools configuration you can also limit DB connections count for GQM and define the connection timeout.

Displaying Database Pools

Navigate to Settings > Configuration > CallREC Core > Database

There can be multiple pools. The main pool must be named callrec. From Version 8.1.520 all Maintenance tools and Key Manager use the main pool.

Creating a New Database Pool

Settings for database pools use the following parameters:

  1. Pool name: Enter a unique name for the pool.
  2. Pool type: From version 8.1.520 there is only one type that can be chosen: Ibatis pool. If selected, the Database driver selection appears instead of SQL map.

  3. SQL map: Depending on the purpose of the pool choose the SQL map from the following list:

    • Callstorage Oracle and Callstorage PostgreSQL - Used to store call information, users and recording rules.
    • Quality Manager Business Oracle and Quality Manager Business PostgreSQL - Used to store information for Quality Management.
    • User define - custom SQL map, if selected then the option SQL map path appears. Define a path to a custom XML map. For example:

      </cz/zoom/callrec/core/callstorage/pojo/sqlMap-config.xml>
  4. Host: IP address of the database server.
  5. Port: port number of the database server. Possible default port number:
    • 5432 - PosgreSQL
    • 1521 - Oracle
      More information about ports can be found in Ports Usage guide.
  6. Database: Database name (for PostgreSQL, MSSQL) or Service name (for Oracle).
  7. Login name:
    1. For Callstorage SQL map default is callrec.
    2. For Quality Manager Business default is wbsc.
  8. Password: The user's password.
  9. Maximum connections: Maximum simultaneous connections to the database.
  10. Connections on init: The number of initial connections. It is recommended to set this value to 1.
  11. Timeout: Connection timeout.