Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Pbxsummary
Supportfiles1Cisco UCM v4 DSN.TDT
Supportfiles2Cisco UCM v4 DSN.TDS
Supportfiles3Cisco UCM 4.DBS
Requiredtask1Configure the SMDR output
Requiredtask3Set up a DSN connection
Requiredtask2Configure TIM Plus
ConnectionDSN connection
RequiredTask1Configure the SMDR output
RequiredTask2Set up a DSN connection
RequiredTask3Configure TIM Plus

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

Configuring your SMDR output

This version of the Cisco UCM stores its call records in a Microsoft SQL Server database. However, by default, this functionality is not enabled. To enable it, the following settings must be configured on the Publisher using the Service Parameters configuration window:

...

This version of the UCM outputs its call records to a table named

Referencemacro
LabelCallDetailRecord
 in a database entitled
Referencemacro
LabelCDR
 .  Rather than have TIM Plus read and remove CDRs from the live 
Referencemacro
LabelCallDetailRecord
 table, we recommend you replicate this into a second table - leaving the original intact - so that it may be used by other applications that require it. Normally, there already exists a SQL User with the following credentials:

...

HTML
<a id="Set up a DSN connection"></a>

Setting up a DSN connection for TIM Plus

To enable TIM Plus to work with your Cisco UCM, you first need to set up a DSN connection. Follow the steps below to perform this task within Microsoft Windows:

  1. Open Windows Control Panel
  2. Double click on the Administrative tools icon
  3. 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

  4. Select the System DSN tab and click the Add button
  5. Select SQL Server from the list of available drivers and click Finish
  6. In the Name field, enter  CCM
  7. In the Description field enter the following: TIM Plus link to CCM
  8. In the Database name field enter the database type e.g SQL, MySQL etc.
  9. In the Server drop-down list select the Cisco UCM Publisher IP address or machine name
  10. Click the Next button
  11. Select the option  With SQL Server authentication using a login ID and password entered by the user , then click Next
  12. Enable the checkbox  Change the default database to: , select CDR , then click the Next button
  13. Click the Finish button
  14. Click the Test Data Source button to verify your settings and, if the test is successful, click OK
  15. Click the OK button to close the control panel applet

...

HTML
<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
    Borderfalse
    URL/download/attachments/4817081/cisco_ucm_2.png
  3. In the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.
  4. Select Connect to a system DSN from the
    Referencemacro
    LabelConnection method
     drop-down list. 
  5. Select Cisco UCM v4 DSN from the
    Referencemacro
    LabelDSN name
     drop-down list.
  6. Enter 5 in the Frequency field.
  7. Select Cisco UCM v4 DSN from the DB script drop-down list.
  8. Click the Save button to apply the settings.