Link to home
Start Free TrialLog in
Avatar of i_harfoush
i_harfoushFlag for Kuwait

asked on

Reading Data from Cisco CUCM Call Manager 8.0 for Calls Recorded through ASP.NET VB

Hi All,

We have installed Cisco VOIP in our network and we have the Cisco CUCM 8.0 call manager set up. We need to be able to query the CUCM database from ASP.NET using VB code, and retrieve data from it into our SQL like caller ID, direct extension called.

I know we can export CDR data from CUCM directly and dump it into SQL, but i need to do the opposite: We are making an application to be installed on some user machines which uses triggers when new call received by a user to show a popup screen on the spot with information of caller (after quering the caller ID number with our own SQL database for user information). Any feedback is highly appreciated.

Thanks!!
Avatar of Alex Bahar
Alex Bahar
Flag of Australia image

You can monitor the calls for certain extensions/users on the client machine using Cisco JTAPI. On the Call Manager you have to activate the CiscoCTI service, enable CTI on the User configuration page associated to the extension, create CTI port and CTI route point associated to the user/extension you want to monitor.
 You can download the JTAPI/TAPI client driver on the Call Manager plugins page. You need to configure the JTAP/TAPI driver with the Call manager user credentials. When activated, the JTAPI client will register to the Call Manager like a softphone with the same phone extension. hence it will receive the call information (CallerID) when a new call is made to this phone. Your CTI application running on the client PC will communicate with the JTAPI/TAPI device to learn the CallerID when a new call comes in.
This may sound complicated if you are not a Call Manager admin as there are multiple steps involved in the configuration. I gave you the necessary pointers. You need to learn the details by reading references.
Check the following links as a starting point.
Cisco Unified TAPI Developers Guide for Cisco Unified Communications Manager  
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/tapi_dev/7_0_1/CUCM_TAPI_Dev_Guide.html 
Computer Telephony Integration
http://www.ciscosystems.com/en/US/docs/voice_ip_comm/cucm/admin/3_1_1/ccmsys/a08cti.html 
Cisco JTAPI operations and developer resources
http://developer.cisco.com/web/jtapi/home 
http://developer.cisco.com/web/jtapi/wikidocs/-/wiki/Main/Cisco%20Unified%20JTAPI%20Operations-by-Release%20Matrix
ASKER CERTIFIED SOLUTION
Avatar of Alex Bahar
Alex Bahar
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of i_harfoush

ASKER

Thanks Abahar for the feedback, i will review the attached links and i will keep you updated with results my attempts. Thanks again!
No worries. There are plenty of references about TAPI & .NET programming on the net. For you, getting the call manager TAPI client will be the tricky part, I guess.
I hope it all goes well.
Fine answer
I have downloaded the TAPI for .Net and checked all the links above but this only helps in how to use the PC as a dialer through the modem configured. I could not find anything on how to connect to Cisco CallManager database and read data from it directly. Even on Cisco website nothing is stated in there. Anyway i will close this and grant you the points, we will be working around this in another way through the call agent popup screen. Thanks mate!