Cisco UCM (below v5)

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

...

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

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:

...

This version of the UCM outputs its call records to a table named CallDetailRecord in a database entitled CDR. Rather than have TIM Plus enterprise 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:

...

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

...

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

Setting up a DSN connection for TIM

...

Enterprise

To enable TIM Plus Enterprise 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 Enterprise 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:

...

<a id="Configure TIM Enterprise"></a>

Configuring TIM Enterprise

Follow the steps below to configure TIM Enterprise to collect the SMDR data from your Cisco UCMOnce the DSN connection has been set up, log in to TIM Enterprise and perform the steps below:

1. Click on the Directory tab.
2. Choose Locate the PBX object you want to configure and click in the Directory, right-click on it and select Properties.
3. A new window will open. In the General tab, select , displaying the general properties of your PBX object. Select Cisco UCM v4 DSN from the Data format list and tick the the 

   Keywordmacro
   Label Keep a local backup of data

   box, as shown below:
   

   Screenshotmacro
   Border false Shadow false URL /download/attachments/3670082/cisco_ucm_2.png

4. Select Click on the

   Buttonmacro
   Label Connection

   tab and select Connect to a system DSN from the Connection method list. 
5. The DSN connection details should be automatically picked up automatically.
6. Finally, click Click on the Save button to apply the changes.
   

   Screenshotmacro
   Border false Shadow false URL /download/attachments/3670082/cisco_ucm_3.png