Nethvoice: Add PostgreSQL support to CQR database integration

[margit86]

Description

Add PostgreSQL as a supported database for CQR queries in NethVoice.

A reseller has a potential customer using Infinity by Zucchetti, whose backend database is PostgreSQL.

The customer needs to dynamically route incoming calls according to the result of a database query executed by CQR.

Currently the available database integrations are MSSQL and MySQL, while PostgreSQL cannot be selected/configured.

PostgreSQL support would allow CQR to be integrated with applications and management systems that use PostgreSQL as their database backend.

Steps

• Configure a CQR that requires an external database query
• Open the database connection configuration
• Try to configure a PostgreSQL database
• PostgreSQL is not available among the supported database types

Actual behavior

CQR database integration currently provides MSSQL and MySQL connections

A PostgreSQL database cannot be configured as a query source

Expected behavior

Add PostgreSQL as a supported database type for CQR

The configuration should allow defining at least:

• PostgreSQL server address
• Port
• Database name
• Username
• Password
• Query used by the CQR

The result of the PostgreSQL query should be usable by the CQR with the same routing logic currently available for the other supported database backends

Components

• NethVoice
• CQR
• Database integration
• PostgreSQL