background image

Strata

® 

CIX

Technical Bulletin

© Copyright 2009

Toshiba America Information Systems, Inc.

Telecommunication Systems Division

9740 Irvine Blvd., Irvine, CA

92618-1697

(949) 583-3700

www.telecom.toshiba.com

TOSHIBA

March 2008

Database Assistant

Database Assistant is a companion package to Voice Assistant.  Database Assistant provides an interface 
between any Open Database Connectivity (ODBC) compliant database and Voice Assistant.  This 
increases the power and flexibility of Interactive Voice Response (IVR) systems by giving them real-time 
access to databases.

Installation

Database Assistant must be installed on a PC running Windows NT, Windows 2000, Windows XP, or 
Windows 2003 server.  Voice Assistant 4.1 or higher is also required. The Microsoft ODBC Drivers must be 
installed prior to installing Database Assistant.

Follow these steps in order:

1.

Install Voice Assistant.

2.

Install the Microsoft ODBC Drivers which are included.  Even if you are using a different ODBC Driver 
for a different database, these drivers need to be installed for Database Assistant to run properly.

3.

Reboot the system.

4.

Install Database Assistant.

5.

Reboot the system.

Getting Started

Once Database Assistant is installed you must login to gain access to the database.

1.

Click on Log In from the Access tab in Database 
Assistant.  The Login to Program box displays 
(shown right).

2.

Enter your password to gain access to the 
database, then click on Okay.

The default password is 3333 for access level 1 and 
9999 for access level 15.

3.

Set up Database Assistant. To do this, click on the 
Debug tab.

Summary of Contents for Strata CIX Database Assistant

Page 1: ... Voice Assistant 4 1 or higher is also required The Microsoft ODBC Drivers must be installed prior to installing Database Assistant Follow these steps in order 1 Install Voice Assistant 2 Install the Microsoft ODBC Drivers which are included Even if you are using a different ODBC Driver for a different database these drivers need to be installed for Database Assistant to run properly 3 Reboot the ...

Page 2: ...current password located in the field labeled Normal Enter a new password Then click on Save To change the password for the Super User delete the current password located in the field labeled Super User Enter a new password Then click on Save Log In Log Out This button is used to log in or log out of Database Assistant Access Level This displays the access level for the current user Normal This fi...

Page 3: ...Connection 1 Click on the Create button under the ODBC Connection Controls section under the ODBC Setup tab 2 The Select Cursor Driver screen will appear Select the Cursor Driver to use for the ODBC connection Then click on Ok to bring up the Select Data Source window 3 Click on Machine Data Source and then click on New 4 Enable the System Data Source radio button then click on Next 5 Choose the a...

Page 4: ...etup screen 11 The Data Source Name you entered should now appear in the ODBC Connections section Delete an ODBC Connection Highlight the ODBC Connection you wish to delete in the ODBC Connection section and click on the Delete button SQL Statements This section is used to add edit delete and test SQL statements For more detailed information about SQL Statements see the section labeled SQL Stateme...

Page 5: ... is used to set up the Host Manager for Database Assistant Upon entering this screen for the first time enter VA_HOST in the Host Manager box Click Save Chg The upper right corner light should switch to green and Host Connection should be Operational ...

Page 6: ...tements Add an SQL Statement To add an SQL Statement make sure your database is highlighted in the ODBC Connections box located next to the SQL Statements box in the ODBC Setup screen Then click on Add SQL to bring up the Add SQL Statement screen This screen allows us to create an SQL Statement that can be used by Voice Assistant Name Enter the name you wish to give your SQL Statement Timeout Ente...

Page 7: ... highlight the statement you wish to edit and click on the Edit SQL button This will bring up the Add SQL Statement box where you can make the desired changes Using SQL Queries The queries are activated using the REQ_DBACT command in Voice Assistant scripts see the Operations Manual for more details End of Document Tables This box lists all of the tables found in your selected database If you high...

Reviews: