Huge thanks to Joshua Colp for mirroring services

CSQL implementation with Asterisk in a contact centre scenario

Share on Twitter Digg this story Click to view a printable version Tue, 27 Oct 2009 21:40:21 -0400

thumnail

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


You haven't voted yet! Vote:
Current Rating: 6.5/10 (2 votes)

Comments (Click to post)

Comments
Name:
Subject:
Website:
Message: 

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!!!).


Original Content (C) 2004-2010 Matt Riddell
Back 5  Feed Add
to
Google Subscribe with Bloglines
Go to today

Icons by: FastIcon.com


Back to life
July 21, 2010 Average Vote: 10
Hey all - I am back online after some pretty big projects which have taken all my time. Will be updating the Asterisk news over the next few days.

Nerd Vittles: Building a Bluetooth Proximity Detection System with Asterisk
December 12, 2005 Average Vote: 10
The Nerd Vittles site has an article on proximity detection using Asterisk and a TomTom GPS

Automated Testing Update
July 30, 2010 Average Vote: 10
Russell Bryant has posted details of a new mailing list for automated testing of Asterisk and some information on the progress that has been made. There is no way to say how important I think this work is. It really makes a huge difference to Asterisk and the ability to use it in an enterprise environment. Really great work.

VoIP-Info: FFasterisk Video file converter
August 25, 2006 Average Vote: 10
The wiki has a link to a new piece of software for converting video to the format required for Asterisk.

Code Review: SRTP support for Asterisk
March 12, 2009 Average Vote: 10
Terry Wilson has moved his SRTP branch onto the Digium review board.

HumBug - Pre BETA Launch Registration
July 27, 2010 Average Vote: 10
Nir Simionovich has posted details of the beta of the new call analytics service.

Interview with BKW_
December 7, 2004 Average Vote: 10
We've finally completed our interview with BKW. Hope you like! :-)

SlashDot: GSM and Asterisk Integration
August 21, 2005 Average Vote: 10
There is a post up on SlashDot which talks about using cellphones with Asterisk.

Interview with Mark Spencer
November 26, 2004 Average Vote: 9.9
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.

Asterisk and Kamailio realtime integration tutorial
May 24, 2010 Average Vote: 9.9
Daniel-Constantin Mierla has posted a link to a tutorial on integrating Asterisk and Kamailio using realtime.

Asterisk IPv6 update
February 1, 2010 Average Vote: 9.8
Olle has posted an update on IPV6 in Asterisk and a link to a blog post of his.

Proposal for T.38 transparent gateway design in Asterisk
April 29, 2010 Average Vote: 9.8
Kevin Fleming has posted a proposed design for a transparent T.38 gateway for Asterisk:

Asterisk Monitoring with iPhone and iPod touch
February 12, 2010 Average Vote: 9.7
For the past couple of weeks I have been working on an app that allows you to monitor and restart Asterisk servers.

Monitoring Asterisk with Munin
January 7, 2010 Average Vote: 9.7
I had a few requests for these munin plugins after some discussion on one of the Asterisk lists and thought people might like them.

New Zealand Asterisk Voices
March 2, 2006 Average Vote: 9.7
Chris Hodgetts has posted details of recordings of Asterisk Sounds with a New Zealand accent.


Automated Testing Update
July 30, 2010
Russell Bryant has posted details of a new mailing list for automated testing of Asterisk and some information on the progress that has been made. There is no way to say how important I think this work is. It really makes a huge difference to Asterisk and the ability to use it in an enterprise environment. Really great work.

Asterisk 1.8.0-beta2 Now Available
July 28, 2010
The Asterisk Development Team has announced the release of Asterisk 1.8.0-beta2.

HumBug - Pre BETA Launch Registration
July 27, 2010
Nir Simionovich has posted details of the beta of the new call analytics service.

Branch Merging Changes
July 26, 2010
Russell Bryant has posted details of some changes to the way developers need to commit code to Asterisk because of the newly released 1.8 branch.

Asterisk 1.8.0-beta1 is Now Available
July 26, 2010
The Asterisk Development Team has announced the release of Asterisk 1.8.0-beta1. This release marks the beginning of the testing process for the eventual release of Asterisk 1.8.0.

Asterisk 1.6.2.10 Now Available
July 26, 2010
The Asterisk Development Team has announced the release of Asterisk 1.6.2.10.

Asterisk 1.4.34 Now Available
July 26, 2010
The Asterisk Development Team has announced the release of Asterisk 1.4.34.

AppleRaisin - AstDB over realtime
July 23, 2010
Olle has posted a note about his awesome AppleRaisin branch which provides the ability to store AstDB in realtime. This would make for a much simpler failover and clustering situation.

QueueMetrics 1.6.1 released
July 22, 2010
Lenz has posted a note to inform us that QueueMetrics version 1.6.1 has been released. This release offers a large number of bug fixes, misc improvements and new developements including hotdesking.

Asterisk 1.8 Branch Creation
July 22, 2010
Russell Bryant has posted a note to inform us of the creation of the 1.8 branch of Asterisk.