SwyxWare - DSN connection

same as a ShoreTel but MS SQL instead of MySQL.

These instructions help you configure your SwyxWare phone system to work with TIM Plus. Contact your system maintainer if you are not familiar with the configuration of your PBX.

<a id="Configure the SMDR output"></a>

Configuring your SMDR output

By default, the Swyx telephone system writes its CDR data to a MSSQL database. In order for TIM Enterprise to connect to the database and collect the call logging data, you need to create a username and password in the MSSQL database on the Swyx  server. Contact your system maintainer if you are not familiar with this procedure.

The following information is required for TIM Enterprise to connect to the Swyx  database:

• IP address or hostname of the  Swyx server where the MSSQL database resides.
• Username and Password of the Swyx database.

The default credentials for the Swyx  database are shown below:

<a id="Configure the DSN connection"></a>

Setting up a DSN connection

To enable TIM Plus to work with your Skype for Business phone system, you first need to set up a DSN connection by following the steps below:

1. Open Windows Control Panel and select the Administrative Tools icon

2. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window.

   Info
   For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

3. Click on the System DSN tab.
4. Click on the Add button.
5. Select SQL Native Client from the driver list and click Finish.
6. In the Name field, enter swyx.
7. In the Description field, enter TIM Plus link to swyx.
   
8. In the Server field, enter the IP address or hostname of your Swyx server.
9. In the Username field, enter the username for your Swyx database.
10. In the Password field, enter the password for your Swyx database.
11. In the Database drop-down list, select swyx.
12. Click on the Test button to confirm the information you entered is correct and that the connection is successful.
13. Click on the OK button to close the window.

<a id="Configure TIM Plus"></a>

Configuring TIM Plus

Once the DSN connection has been set up, log in to TIM Plus and perform the steps below:

1. Click on the Directory tab.
2. Choose the site you want to configure and click Properties.
   

   Screenshotmacro
   Border false URL /download/attachments/16712038/swyx_odbc_3.png

3. In the Site Properties window, select SWYX V8 from the PBX model drop-down list.
4. In the Connection method field, select Connect to a system DSN from the drop-down list.
5. In the DSN name field, select swyx from the drop-down list.
6. In the Frequency field, enter 5.
7. In the DB script field, select SWYX V8 from the drop-down list.
8. Click on the Save button to apply the settings.