ANI filtering based on SQL data

Version 1

    Subject: RE: ANI filtering based on SQL data
    Replied by: Mark Alliban on 16-08-2012 04:35:37 AM
    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.
    This document was generated from CDN thread

    Created by: Jim Hanus on 15-08-2012 11:46:43 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!

    Subject: RE: ANI filtering based on SQL data
    Replied by: Raghavendra Gutty Veeranagappa on 16-08-2012 03:05:06 AM
    Hi Jim,

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

    Thanks,
    Raghavendra

    Subject: RE: ANI filtering based on SQL data
    Replied by: Kleid Gjataj on 16-08-2012 04:54:53 PM
    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

    Subject: RE: ANI filtering based on SQL data
    Replied by: Raghavendra Gutty Veeranagappa on 05-09-2012 02:32:20 AM
    Hi Kleid,

    i am not sure about those with TCL script.

    Thanks,
    Raghavendra