Integrace Asterisku s podnikovými informačními systémy

Abstract

This master thesis is about integration of an Asterisk IP private branch exchange with the information systems of a company. The goal of this thesis is to design and implement an information line dialplan within a sample company operating a Vtiger CRM system using VoIP technology with their Asterisk IP PBX. Then display more information in incoming call notifier to user of the CRM, analyse and test of calls and Vtiger Asterisk Connector web application. The theoretical part of the thesis describes CRM systems and compares three chosen open-source CRM systems. The next main topic is about Asterisk and description of its interfaces for communication with external applications and module for ODBC connector which allows relational database integration. The practical part describes the configuration and implementation of Vtiger CRM, PBX Asterisk, Vtiger Asterisk Connector and ODBC connector. The dialplan is designed and implemented based on the findings of database data model. The dialplan redirects calls using SQL queries on the database of information systems. The practical part also contains modification of notification window with added information from database. On the end of the thesis is described process of testing and analysis of calls.