Integration with MS SQL

The main principle of the integration is described below:

1. Webitel Server sends configuration file via HTTP to the SQL4Dialer Service. The Service applies configuration file and according to the file get data from the MS SQL.
2. The SQL4Dialer Service create new members in the Webitel dialer via standard HTTP REST API using the domain token.

Installation

You will need a Windows PC that has access to the MS SQL and can be reached from the Webitel Server.

1. Download and unpack the following archive: sql4dialer.goweb.winamd64.zip
2. Open conf/app.conf file and change the value of the http.addr to your IP address (your_ip_address)
3. Save the file

4. Open CMD or PowerShell inside application folder and run: 

   .\sql4dialer.goweb> sql4dialer.exe -install

   This will install application as a Windows Service

5. Reboot the PC

6. After reboot, please, try to open the address: http://your_ip_address:9000/sql4dialer . You will see such response: 

   { "result": [] }

Domain token

For import/export actions, we must have a valid domain token. Go to the Domains menu and open your domain on the tokens tab:

Press plus (+) button and choose role and date until that this token will be valid:

Download your key file now or copy it. If you do not download the key file now, you will not be able to retrieve your token key again. To help protect your security, store your token key securely and do not share it:

Integrations