Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current ·  View Page History
<< Previous Version 11 Next >>

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

Configuring your SMDR

The Cisco UCM stores its Call Detail Records in a MSSQL database, however, the output is not enabled by default.

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

  • CDR Enabled
  • CDR Log CallsWith 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 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 Plus 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 Plus

You will need to setup a DSN connection for TIM Plus 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 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. Select the site configured during the setup wizard and click Properties.

  3. Within 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. In the Frequency field enter in 5.
  7. In the DB script field select Cisco UCM v4 DSN from the drop-down list.
  8. Finally, click on the Save button to apply the settings.


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

Connection information Description
Connection type IP
IP method The Cisco UCM stores its Call Detail Records in a MS SQL database which is located on the Publisher.

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 Plus will connect to what 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 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 Plus 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 Plus

You will need to setup a DSN connection for TIM Plus 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:

Cisco UCM

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.
    4. Cisco UCM
  4. Within the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.
  5. In the Connection method field select Connect to a system DSN from the drop-down list.
  6. In the DSN name field select Cisco UCM v4 DSN from the drop-down list.
  7. In the Frequency field enter in 5.
  8. In the DB script field select Cisco UCM v4 DSN from the drop-down list.
  9. Finally, click on the Save button.
Labels:
None
Edit Labels