« Back to TCL-API

Connecting to database through TCL

Combination View Flat View Tree View
Threads [ Previous | Next ]
Connecting to database through TCL
connecting to database using tcl ivr
Answer
9/25/12 7:55 AM
Hi
I am wondering if we can connect directly to database using TCL IVR as is done in standard TCL/TK:
http://stackoverflow.com/questions/8464052/connecting-to-microsoft-sql-server-using-tcl 
If there is no possiblity of extending TCL IVR in that case, which way do you propose for connecting a tcl script to MS SQL database, I know it can be done through cisco secure ACS and also voice XML. My request to connect to a database stems from the following scenario:
I need to access some predefined holidays and special days that reside in a MS SQL database and are subject to change periodically. I want to have the ability to read such database and  play the corresponding voice menu.
 
Flag

RE: Connecting to database through TCL
Answer
9/25/12 5:36 PM as a reply to Sara Afghan.
Sara Afghan:
Hi
I am wondering if we can connect directly to database using TCL IVR as is done in standard TCL/TK:
http://stackoverflow.com/questions/8464052/connecting-to-microsoft-sql-server-using-tcl 
If there is no possiblity of extending TCL IVR in that case, which way do you propose for connecting a tcl script to MS SQL database, I know it can be done through cisco secure ACS and also voice XML. My request to connect to a database stems from the following scenario:
I need to access some predefined holidays and special days that reside in a MS SQL database and are subject to change periodically. I want to have the ability to read such database and  play the corresponding voice menu.
 

 
Don't know what exactly you like to with database .Tcl IVR API can communicate with Cisco ACS. Please refer to those aaa xxxxx commands in programming guide.
 
In term of playing different message you can ustilze stand tcl command to determine date of year, time of date to play different voice prompt. You can make those prompt configurable under application "param"
Flag

RE: Connecting to database through TCL
Answer
9/28/12 2:38 PM as a reply to Sara Afghan.
You could write a web services that interacts with your database and from your TCL script, use the httpios package to connect to your webservice to send and receive data.
Flag