Avaya 15-601063 manual IVR Connecting Voicemail Pro to a Database

8.2 IVR: Connecting Voicemail Pro to a Database

Voicemail Pro call flows can interact, read and write data, with almost any Windows database that supports ODBC (Open Database Connectivity) and SQL (Structured Query Language) format.

∙Requirements for Voicemail Pro Database Operation

To use the Database actions within Voicemail Pro, a VM Pro Database Interface must be added to the IP Office configuration.

The Database Actions that can be used in a call flow are:

∙ Database Open

Opens the required database, including any necessary permissions and security options.

∙ Database Execute

Defines a SQL query to either read matching records from the database or to write data to the database. Up to 6 fields can be defined to be returned in matching database records.

∙ Database Get Data

Selects the current record from the matches returned by the preceding Database Execute action. The record fields are then placed into Voicemail Pro variables DBD[0] to DBD[5]. The Database Get Data allows selection of the first, next, previous or last record.

∙ Database Close

Closes the database connection. This also occurs automatically if the caller disconnects.

Voicemail Pro	Page 336
IP Office	15-601063 Issue 20l (03 March 2009)