i_harfoush
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!!
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
I hope it all goes well.
ASKER
Fine answer
ASKER
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!
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