Avaya 6 Manual De Usuario
![Avaya](https://files.manualsbrain.com/attachments/539de53b12b0cfce0bb8cf1e3bb961e969d9f556/common/fit/150/50/0bfb423b07b431ecf5ac095ccde7771f5eac50e962dfba59f8e256280b3d/brand_logo.png)
Voicemail Pro Installation and Maintenance
Page 250
15-601063 Issue 22e (16 May 2010)
IP Office Release 6
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
, 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.
Interface licenses can still be used.
·
Database Open Action
Open a database.
·
Database Execute Action
Perform an action on a database.
·
Database Get Data Action
Get information from a database.
·
Database Close Action
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
.
·
In addition to the normal
licenses for Voicemail Pro
, 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.
Interface licenses can still be used.
Settings
1. Click the
Database Actions icon and select
Database Open.
2. The
General
,
Entry Prompts
,
Reporting
and
Results
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
.
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.
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.
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.
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.
This result connection is used once the database is opened.
·
Failure
This result connection is used if the database cannot be opened.
This result connection is used if the database cannot be opened.
22
250
251
252
253
366
22
176
177
182
183