1 / 14

Asterisk Integration into MSSQL Database

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.

deirdra
Download Presentation

Asterisk Integration into MSSQL Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Asterisk Integration into MSSQL Database • Erik Wilhelmsen • IT Manager • CCV

  2. 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

  3. Asterisk Install Req. • Asterisk 1.4 or higher (1.6 for some features) • FreeTDS driver (tds ver. 7.0) • Build Asterisk with odbc and cdr_tds support

  4. Linux Conf • Update ODBC.ini • Update ODBCinst.ini

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

  6. Asterisk conf • Update Extconfig.conf • Update Voicemail.conf • Update Extensions.conf

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

  8. 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

  9. 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

  10. 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.

  11. 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

  12. Intercom/Hunt/Conf • Using this integration we have been able to provide an Intercom calling conference hunt group. • Use this for security/announcements

  13. Asterisk Realtime • Running conf files from database • extensions.conf • voicemail.conf • sip.conf

  14. Questions?

More Related