CSQL implementation with Asterisk in a contact centre scenario
Huge thanks to Joshua Colp for mirroring services
Tue, 27 Oct 2009 21:40:21 -0400
 Prabakaran T has sent me details of a whitepaper on integrating CSQL and Asterisk:
Excerpt:
Contact / call center software which are based on the Open Source soft switch such as Asterisk use a dynamic real-time system to load objects that may change frequently such as SIP/IAX2 users and peers, queues and their members, from external database management systems. Had the same configurations been stored within the soft switch configuration files, then for every change in the configurations, the switch would require a restart for the changes to take effect, thus resulting in increased system downtimes, which severely disrupts processes on the floor and undermines performance statistics. Such system downtimes are the bane of call centers the world over and are to be avoided at any cost. Hence the facility to access external data sources through the “Real-time” library.
Such real time access to external data objects are also useful for up-scaling operations by clustering multiple soft-switches working with the same centralized information, or when you want to build external applications which modify information in the call flow and you want to do so without requiring a reload / re-start of the soft switch. This introduces a dependency on the performance of the database management system, as information required for the switch to handle the call flow is stored in an external source and has to be fetched in real time. This is where traditional disk resident database systems will never be able to deliver the desired real time performance levels, thereby slowing the performance of the switch resulting in an overall performance degrade of the call center and customer interaction quality and experience, which no call center can afford more so under the stringent customer facing telemarketing regulations.
The whitepaper:
LAKSHYA_CSQL-Asterisk_Implementation_Whitepaper_v1_0.pdf
Similar Articles (Based on Title)tectonic: MySchool uses Asterisk to run call centre - May 4, 2005 The MySchool system in South Africa is now using Asterisk for its call center.
Asterisk saves call centre operator R4.5m - December 12, 2006 Jason Goecke has posted details of a note on the Asterisk Forum.
Asternic Call Centre Stats - June 13, 2008 Nicolas Gudino - the guy who wrote the Flash Operator Panel - has released a new package for monitoring Asterisk queue statistics.
Interview With Flash Operator Panel Developer - September 19, 2004 Interview with Nicolas Gudino, the author of the Flash Operator Panel for Asterisk.
Interview With FreeBSD Developer - September 21, 2004 Interview With Dr Rich Murphy of FreeBSD and Asterisk FreeBSD fame
Link: Article with Asterisk running home server - October 2, 2004 Running a Wireless network in your neighbourhood with Asterisk terminating VOIP calls.
Asterisk-Users: Request for IAX debug session transcript with IAXy - October 11, 2004 Held needed getting IAXy debug's for phone manufacturer's implementation of IAX
DUNDi is available for use with v1-0 - October 23, 2004 BKW has released a .tar.gz file so that you can use DUNDi with Asterisk 1.0
Asterisk-Dev: patch for chan_capi to compile with latest CVS - November 18, 2004 Frank Sautter has created a patch to allow chan_capi-0.3.5 to compile against CVS-HEAD and adds capiAnswerFax patch
Interview with Mark Spencer - November 26, 2004 We have managed to get an interview with Mark Spencer AKA Markster. Mark Spencer is the creator of Asterisk and by far the most active developer.
pressbox.co.uk: Interview with Brian K West - November 29, 2004 Pressbox has published an interview with BKW, one of the developers on Asterisk (NEXT!!!).
Top 15 Daily Asterisk News ArticlesAsterisk-Addons 1.4.10, 1.6.0.4, and 1.6.1.2 Now Available - December 3, 2009 Average Vote: 10 Testing of SIP TCP/TLS support - July 11, 2007 Average Vote: 10 Interview With Flash Operator Panel Developer - September 19, 2004 Average Vote: 10 Voip-info.org: Free downloadable guide on how to switch to VoIP - February 6, 2005 Average Vote: 10 Distributed Asterisk events and device state - March 17, 2008 Average Vote: 10 No interrupts from TDM400 Card - August 12, 2009 Average Vote: 10 snom soft phone - February 8, 2005 Average Vote: 10 Asterisk scalability - February 18, 2009 Average Vote: 10 espeak app for Asterisk 1.6 - September 2, 2009 Average Vote: 9.9 Interview with Mark Spencer - November 26, 2004 Average Vote: 9.7 Iaxclient-devel: JIAXClient - Java IAXClient 0.0.1 released - February 9, 2005 Average Vote: 9.5 Digium Community Achievement Award - October 16, 2009 Average Vote: 9.5 Amazing Asterisk Sign - August 18, 2009 Average Vote: 9.5 Interview with John Todd - August 22, 2009 Average Vote: 9.4 New feature for AMI Redirect command - September 22, 2009 Average Vote: 9
Last 10 Daily Asterisk News ArticlesAsterisk and XMPP Jingle - testers needed - December 3, 2009 Philippe Sultan has posted a request for testers for using Jabber as a softphone.
Asterisk Queues Tutorial updated - Hot-Desking without Agent Channels - December 3, 2009 Matt King has posted an updated Asterisk Queues tutorial.
Asterisk 1.6.2.0-rc7 released, and Asterisk-Addons 1.6.2.0-rc2 re-released - December 3, 2009 The Asterisk Development Team has announced the next Asterisk release candidate for Asterisk 1.6.2.0 as version 1.6.2.0-rc7.
Asterisk-Addons 1.4.10, 1.6.0.4, and 1.6.1.2 Now Available - December 3, 2009 The Asterisk Development Team has announced several Asterisk-Addons releases, including Asterisk-Addons 1.4.10, 1.6.0.4, and 1.6.1.2.
RTCP work going on :: Project Pinefrog - November 25, 2009 Olle has posted details of some work which is underway to improve RTCP stats in Asterisk.
New committer - odicha - November 25, 2009 There is a new committer for Asterisk who has been doing work with GSM modem integration.
New Open Source CTI client for Asterisk - November 19, 2009 Oliver Nittka has posted information on the release of a new CTI client for Asterisk.
AstriCon 2009 Presentation - Building a Distributed Call Center - November 19, 2009 Leif Madsen has posted his presentation on building a distributed call centre.
Changing internal_timing to default to yes - November 19, 2009 Leif Madsen has posted a question about whether the internal_timing option should default to yes.
Oman - 212 arrested for providing VoIP - November 19, 2009 MENAFN has an article by Rahima Al Balushi on the arrest of 212 people in Oman for providing VoIP services.
Loading
| Original Content (C) 2004-2009
Matt Riddell |
|

Icons by: FastIcon.com
| |
|