Cisco Unified Call Manager (below v5)

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

Connection Type

  TIM Plus establishes a DSN connection with this PBX.

Support Files

  Cisco UCM v4 DSN.TDT
  Cisco UCM v4 DSN.TDS

Required Tasks

  Configure the SMDR output
  Set up a DSN connection
  Configure TIM Plus

Configuring your SMDR output

This version of the Cisco UCM stores its CDRs (call detail records) in a Microsoft SQL Server database. However, by default, this functionality is not enabled.

To enable CDR output to the database, the following 'Service' parameters must be configured on the Publisher using the Service Parameters Configuration window:

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

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

• Username: CiscoCCMCDR
• Password: dipsy

To set up replication you may need to speak to your database administrator or your Cisco UCM maintainer.

Here, we will assume you will use a replicated table name of calldetailrecord2 .

Ensure that the SQL user described above also has full access to this replicated table.

You need to know the following information for TIM Plus to connect successfully to the Cisco UCM CDR database:

• IP address or hostname of the Microsoft SQL Server database located on the Publisher node.
• Username and Password to connect to the CDR database.

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
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. Finally, click the OK button to close the control panel applet.

An example of ODBC setup is shown below:

Configuring TIM Plus

Once the DSN connection has been setup, log on to TIM Plus as usual and apply the following settings:

1. Click on the Directory tab.
2. Choose the site you want to configure and click Properties.
   
   
3. In the Site Properties window, select Cisco UCM v4 DSN 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 Cisco UCM v4 DSN from the drop-down list.
6. Set the Frequency option to 5.
7. In the DB script field, select Cisco UCM v4 DSN from the drop-down list.
8. Click the Save button to apply your settings.