Cisco UCM (below v5)

These instructions help you configure your Cisco Unified Call Manager up to V4.x to your older Cisco UCM 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

The This version of the Cisco UCM stores its Call Detail Records call records in a MSSQL Microsoft SQL Server database. However, however, the output by default, this functionality is not enabled by default. To enable the CDR outputit, the following 'Service' parameters need to settings must be configured on the Publisher, using  using the Service Parameters Configuration  configuration window:

• CDR Enabled
• CDR Log CallsWith Calls With Zero Duration Flag
• Call Diagnostics Enabled

The database that TIM Plus will connect to is called 'CDR'. Within this database there is a table called 'CallDetailRecord'. Rather than TIM Plus reading and removing data from the 'CallDetailRecord' table we highly recommend that you setup a second table which is a replication of the 'CallDetailRecord' table. This leaves the original table intact and can This version of the UCM outputs its call records to a table named

• Username: CiscoCCMCDR
• Password: dipsy

To setup set up replication you will may need to speak to your Database Administrator database administrator or your Cisco UCM maintainer. The replicated table name should be called 'calldetailrecord2'.Please make sure that when the replication is setup that the above user  Ensure that the SQL user described above has full access rights to the new this replicated table. 

You will need to know the following information in order for TIM Plus to be able to connect successfully to the Cisco UCM CDR databaseCDR database:

• The IP /DNS address or hostname of the MS SQL Database which is Microsoft SQL Server database located on the Publisher node.
• Username The username and Password password to connect to the CDR database (you may need to speak to your maintainer about this)

  Referencemacro
  Label CDR

   database.

<a id="infoSet up a DSN connection"></a>

Setting up a DSN connection for TIM Plus

You will need to setup a DSN connection for To enable TIM Plus to work with the your Cisco UCM. Below you will find instructions on how to do this , you first need to set up a DSN connection. Follow the steps below to perform this task within Microsoft Windows:

1. Click on Windows Start.
2. Click on Control panel.Open Windows Control Panel
3. Double click on the Administrative tools icon.

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

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

...

1. to close the control panel applet

An example of an ODBC setup is shown below:

Configuring TIM Plus

Below you will find steps on how to configure TIM Plus to listen for SMDR data from your Cisco UCM 4.0:

1. Browse to TIM Plus as normal and login with your credentials.
2. Click on the Directory tab.
3. Click on the site configured during the setup wizard and click Propertiesor create a new site and click Properties.

<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/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
   Label Connection method

    drop-down list. 
5. Select Cisco UCM v4 DSN from the

   Referencemacro
   Label DSN 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.