Cisco Unified Call Manager up to V4.x

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 Enterprise establishes a DSN connection with this PBX.

Support Files

  Cisco UCM v4 DSN.TDT
  Cisco UCM v4 DSN.TDS
  Cisco UCM 4.DBS

Required Tasks

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

Configuring the 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:

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

This version of the UCM outputs its call records 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 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. Ensure that the SQL user described above has full access rights to this replicated table. 

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

• The IP address or hostname of the Microsoft SQL Server database located on the Publisher node.
• The 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. Click the OK button to close the control panel applet

An example of an ODBC setup is shown below:

Configuring TIM Enterprise

Once NetPBX is configured and collecting data, log in to TIM Enterprise and perform the following steps:

1. Click on the Directory tab.
2. Choose the PBX object you want to configure and click Properties.
3. A new window will open. In the General tab, select Cisco UCM v4 DSN from the Data format list and tick the Keep a local backup of data box, as shown below:
   
   
4. Select Connect to a system DSN from the Connection method list. 
5. The DSN connection details should be automatically picked up.
6. Finally, click on the Save button.
   
   

These instructions should assist in configuring your Cisco UCM to work with TIM Enterprise. If you are not familiar with PBX configuration, please contact your system maintainer.

Configuring Cisco Unified Call Manager

By default the CDRs are not written to the MS SQL Database. The following 'Service' parameters need to be enabled on the Publisher using the Service Parameters Configuration window:

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

The database that TIM Enterprise will connect to what is called 'CDR'. Within this database there is a table called 'CallDetailRecord'. Rather than TIM Enterprise 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 be used by other applications that may require it. There should be a SQL User already created with the following credentials:

• Username: CiscoCCMCDR
• Password: dipsy

To setup replication you will need to speak to your 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 has full access to the new table.

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

• IP/DNS of the MS SQL Database which is located on the Publisher.
• Username and Password to connect to the CDR database (you may need to speak to your maintainer about this).

Setting up a DSN connection for TIM Enterprise

You will need to setup a DSN connection for TIM Enterprise to work with the Cisco UCM. Below you will find instructions on how to do this within Microsoft Windows:

1. Click on Windows Start.
2. Click on Control panel.
3. Double click on Administrative tools icon.
4. Double click on Data Sources (ODBC) icon.
5. Click on the System DSN tab.
6. Click on the Add button.
7. Select SQL Server from the list and click Finish.
8. In the Name field enter the following: CCM.
9. In the Description field enter the following: TIM Plus link to CCM.
10. In the Database name field enter the database type e.g SQL, MySQL etc.
11. In the Server drop-down list select the Cisco UCM Publisher IP address or machine name.
12. Click on the Next button.
13. Click on the radio button With SQL Server authentication using a login ID and password entered by the user and click on the Next button.
14. Click on the check box Change the default database to: and select CDR and then click on the Next button.
15. Click on the Finish button.
16. Click on the Test Data Source button and once you make sure the test is completed successfully, click on the OK button.
17. Now click on the OK button.

Now you will be able to see the CCM in the System DSN list.

An example of ODBC setup is shown below:

Configuring TIM Enterprise

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

1. Browse to TIM Enterprise as normal and login with your credentials.
2. Click on the Directory tab.
3. Go the the point in the Directory where you need to add the PBX Object and add a PBX with the name 'Cisco UCM 4.0'.
4. Left-click on it and select Properties.
5. From the General settings tab select Cisco UCM v4 DSN from the PBX model list.

6. In the Connection tab select System DSN connection from the Connection method list.
7. The DSN connection details should be automatically picked up.
8. Finally, click on the Save button.