Asterisk Integration into MSSQL Database Erik Wilhelmsen IT

Asterisk Integration into MSSQL Database Erik Wilhelmsen IT Manager CCV

Advantages for integration Voicemail storage More configurable/Open ended Call Detail Records Click to call functionality (AMI) SIP Peer status updates Asterisk Realtime Voicemail. conf, extensions. conf, sip. conf

Asterisk Install Req. Asterisk 1. 4 or higher (1. 6 for some features) Free. TDS driver (tds ver. 7. 0) Build Asterisk with odbc and cdr_tds support

Linux Conf Update ODBC. ini Update ODBCinst. ini

Asterisk conf Update res_odbc. conf with DB variable info Update cdr_tds. conf

Asterisk conf Update Extconfig. conf Update Voicemail. conf Update Extensions. conf

Voicemail Storage Ability to store VM’s as blob file in database Update status of VM with agent Click to call integration using outlook app.

Call Detail records Store all call records in MSSQL DB With agent/app we are able to massage record data to fit our needs Pull info we need realtime into our CMS for reporting or information

Click to call Using extensions DB we are able to make a call to the AMI and provide Click-to-Call Integrated into our CMS and Call Detail reporting Also able to query our membership database to provide caller info for Click-to. Call

Sip Peer Status With SIP Database we are able to update SIP peer status Use this information for Telephony app on client desktops using Windows bubble pop. Future: we hope to use this for out of office replies for outlook and setting VM greetings.

Follow-me app We have designed a custom app that allows a user to select where to be called at. Also provides follow-me on click-to-call Future: Integrate into SIP status DB