« Back to TCL-API

ANI filtering based on SQL data

Combination View Flat View Tree View
Threads [ Previous | Next ]
ANI filtering based on SQL data
Answer
9/5/12 7:12 AM
I am attempting to send/drop certain ANI's based upon a SQL database.  I have found the ANI-Filtering.tcl script which will work great but I need to base the numbers off of a SQL database instead of the IOS router.  Is this possible?
 
Also, does anyone know of a TCL script that can call an API from lets say an I3 or CCX server?  For example:  If a certain call comes in we want to route it based on certain criteria from an agent. It will either ring the agent or drop the call depending on their agent status.
 
Is this possible?
 
Thanks!
Flag

RE: ANI filtering based on SQL data
Answer
8/16/12 8:05 AM as a reply to Jim Hanus.
Hi Jim,

it is not possible to make a request to database from Tcl script.

Thanks,
Raghavendra
Flag

RE: ANI filtering based on SQL data
Answer
8/16/12 9:35 AM as a reply to Jim Hanus.
Hi Jim,
As far as I am aware the only way to do it would be to use a RADIUS server. TCL can make RADIUS requests, the RADIUS server can connect to the SQL database, and either authorize or not authorize the call based on whatever parameters you choose... ANI, DID, time of day, DTMF's pressed, random selection, etc.
Flag

RE: ANI filtering based on SQL data
Answer
8/16/12 9:54 PM as a reply to Raghavendra Gutty Veeranagappa.
Hi Raghavendra,

Do you know what third party data sources can be integrated in IOS TCL scirpts. (APIs, XML files, SOAP etc) Are the data sources documented anywhere?

Thanks,
-Kleid
Flag

RE: ANI filtering based on SQL data
Answer
9/5/12 7:32 AM as a reply to Kleid Gjataj.
Hi Kleid,

i am not sure about those with TCL script.

Thanks,
Raghavendra
Flag