The Avaya IP Office platform is the ultimate in converged voice and data technology. IP Office brings a combination of voice and data applications formerly reserved for only the largest corporations. Cutting edge customer service with easy to use tools is now available to the smallest of businesses.

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.

Email User and Group Configuration	Installing VM Pro for SMTP Voicemail Email	Email Reading VM PRO
Voicemail Pro for MAPI Voicemail Email	What Voicemail Email Messages Look Like	Email Settings VM PRO
Overview of Voicemail Email Installation	Setting a Mailbox Fax Number	IVR: Enter Details into the Database
System Preferences: Housekeeping	Automatic Message Deletion - Housekeeping	Example Call Flow Using $POS
Hunt Group Message Waiting Indication	Integrated Messaging Service (IMS)	Voicemail Pro Fax Operation
Installing the IMS Client Software	Installing the IMS & Voicemail Pro Software	System Preferences: General
Voicemail Pro Installation Types	IVR: Connecting Voicemail Pro to a Database	Configuring Group Broadcast
Voice Mail Pro Licenses	Adding a Record Name Module	Hunt Group Voicemail
Mailbox User Controls Overview	Number of Simultaneous Voicemail Users	Before Installing IMS
Customizing Manual Recording	Returning Data from the Database	Installation Requirements
Out of Hours Operation	Setting the Destination for User Recordings	IP Office Configuration
Using a Play Configuration Menu Action	Using Short Codes to Access Voicemail	Language Support
Starting Voicemail Pro	Starting the Voicemail Pro Server	Overview of Remote Access
Telephony Operation Mode	Switching Voicemail Pro to MAPI	Example Database Scenario
Voicemail Pro TTY Prompts	Access from a Trusted Extension	Text to Speech
Upgrading Existing Voicemail Pro System	User Defined Variables	User Configuration
Actions Voicemail Pro	Using Voicemail to Give Error Messages	Voicemail Telephone Numbers
Voicemail Pro Language Switching	Voicemail Pro Networked Messaging	VPNM Preferences
Voice Recording Library (VRL)	VM Pro with Web Campaigns (Typical) Software Installation	Hot Desking

about

avaya voice mail

avaya one x quick edition

jersey shore phone systems

vm pro

PO BOX 186 Spring Lake, New Jersey 07762