Voicemail Pro Page 336
15-601063 Issue 20l (03 March 2009)IP Office
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.