Avaya 6 manual Database Actions, Database Open

4.10 Database Actions

Database Actions

These actions relate to retrieving and adding data to a database.

∙In addition to the normal licenses for Voicemail Pro 22 , use of database actions requires the IP Office system to have an Advanced Edition license. For systems upgraded to IP Office Release 6, existing legacy VMPro Database Interface licenses can still be used.

∙ Database Open Action 250

Open a database.

∙ Database Execute Action 251

Perform an action on a database.

∙ Database Get Data Action 252

Get information from a database.

∙ Database Close Action 253

Close a database.

4.10.1 Database Open

The Database Open action opens a link to a database. If there is a connection to the database already then the current connection is closed and the new one requested will be opened. For an example of the action in a call flow, see IVR Database Connection Example, Retrieving Data From the Database 366 .

∙In addition to the normal licenses for Voicemail Pro 22 , use of database actions requires the IP Office system to have an Advanced Edition license. For systems upgraded to IP Office Release 6, existing legacy VMPro Database Interface licenses can still be used.

Settings

1.Click the Database Actions icon and select Database Open.

2.The General 176 , Entry Prompts 177 , Reporting 182 and Results 183 tabs are standard tabs available to all actions.

3.Select the Specific tab. The connection string to open the database can be entered directly into the field. For help

on constructing the connection string, click . The Data Link Properties window opens.

∙Provider Tab

Select the OLE DB Provider of the data that is to be connected to. Click Next to move to the Connection Tab

.

∙Connection Tab

Specific information relating the Database provider needs to be completed. Help of the information required for each of the fields can be obtained by clicking the Help button. Fields available will be dependant on the type of provider. Test that the information entered will allow entry into the database, click the Test Connection button. A message Test Connection Succeeded will show if successfully connected to the database.

∙Advanced Tab

Network and other settings, for example access permissions. Fields showing will be dependant on the type of provider selected. Click help for specific information about any of the fields.

∙All

The properties that have been selected on the previous tabs are shown in the All Tab. Amendments can be made as required by selecting the Name and click Edit Value.

Results

This action has the following results which can be connected to further actions:

∙Success

This result connection is used once the database is opened.

∙Failure

This result connection is used if the database cannot be opened.

Voicemail Pro Installation and Maintenance	Page 250
IP Office Release 6	15-601063 Issue 22e (16 May 2010)