Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2171
  • Last Modified:

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!!
0
i_harfoush
Asked:
i_harfoush
  • 3
  • 3
1 Solution
 
Alex BaharCommented:
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
0
 
Alex BaharCommented:
Take a look at the examples here > Utilizing TAPI from ASP.NET
http://www.julmar.com/blog/mark/2006/11/14/UtilizingTAPIFromAnASPNETApplication.aspx 
0
 
i_harfoushAuthor Commented:
Thanks Abahar for the feedback, i will review the attached links and i will keep you updated with results my attempts. Thanks again!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Alex BaharCommented:
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.
0
 
i_harfoushAuthor Commented:
Fine answer
0
 
i_harfoushAuthor Commented:
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!
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now