Avaya 15-601063 User Manual

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.