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.

...

HTML
<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:

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.

HTML
<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:

Open Windows Control Panel
Double click on the Administrative tools icon
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
Select the System DSN tab and click the Add button
Select SQL Server from the list of available drivers and click Finish
In the Name field, enter CCM
In the Description field enter the following: TIM Plus Enterprise link to CCM
In the Database name field enter the database type e.g SQL, MySQL etc.
In the Server drop-down list select the Cisco UCM Publisher IP address or machine name
Click the Next button
Select the option With SQL Server authentication using a login ID and password entered by the user , then click Next
Enable the checkbox Change the default database to: , select CDR , then click the Next button
Click the Finish button
Click the Test Data Source button to verify your settings and, if the test is successful, click OK
Click the OK button to close the control panel applet

An example of an ODBC setup is shown below:

Screenshotmacro

Border	false
Shadow	false
URL	/download/attachments/4817081/cisco_ucm_1.png

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

Configuring TIM Enterprise

Once NetPBX is configured and collecting datathe DSN connection has been set up, log in to TIM Enterprise and perform the following steps below:

Click on the Directory tab.
Choose Locate the PBX object you want to configure and click in the Directory, right-click on it and select Properties.
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
Select Click on the
Buttonmacro
Label Connection
tab and select Connect to a system DSN from the Connection method list.
The DSN connection details should be automatically picked up automatically.
Finally, click Click on the Save button to apply the changes.
Screenshotmacro
Border false
Shadow false
URL /download/attachments/3670082/cisco_ucm_3.png

HTML

<p>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.</p>

<table class="confluenceTable">
	<tbody>
		<tr>
			<th class="confluenceTh" width=158>Connection information</th>
			<th class="confluenceTh">Description</th>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Connection type</b></td>
			<td class="confluenceTd">IP
			</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>IP method</b></td>
			<td class="confluenceTd">The Cisco UCM stores its Call Detail Records in a MS SQL database which is located on the <span class="reference">Publisher</span>.
			</td>
		</tr>
	</tbody>
</table>

<h2>Configuring Cisco Unified Call Manager</h2>

<p>By default the CDRs are not written to the MS SQL Database. The following 'Service' parameters need to be enabled on the <span class="reference">Publisher</span> using the 
<span class="reference">Service Parameters</span> Configuration window:</p>

<ul>
	<li>CDR Enabled</li>
	<li>CDR Log CallsWith Zero Duration Flag</li>
	<li>Call Diagnostics Enabled</li>
</ul>

<p>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 <b>highly recommend</b> 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:</p>

<ul>
	<li><b>Username:</b> <span class="keyword">CiscoCCMCDR</span></li>
	<li><b>Password:</b> <span class="keyword">dipsy</span></li>
</ul>

<p>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'.</p>
  
<p>Please make sure that when the replication is setup that the above user has full access to the new table.</p>

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

<ul>
	<li>IP/DNS of the MS SQL Database which is located on the <span class="reference">Publisher</span>.</li>
	<li>Username and Password to connect to the CDR database (you may need to speak to your maintainer about this).</li>
</ul>

<h2>Setting up a DSN connection for TIM Enterprise</h2>

<p>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:</p>

<ol>
	<li>Click on Windows <span class="button no_margin">Start</span>.</li>
	<li>Click on <span class="button no_margin">Control panel</span>.</li>
	<li>Double click on <span class="button no_margin">Administrative tools</span> icon.</li>
	<li>Double click on <span class="button no_margin">Data Sources (ODBC)</span> icon.</li>
	<li>Click on the <span class="button no_margin">System DSN</span> tab.</li>
	<li>Click on the <span class="button no_margin">Add</span> button.</li>
	<li>Select <span class="reference">SQL Server</span> from the list and click <span class="button no_margin">Finish</span>.</li>
	<li>In the <span class="reference">Name</span> field enter the following: <span class="keyword">CCM</span>.</li>
	<li>In the <span class="reference">Description</span> field enter the following: <span class="keyword">TIM Plus link to CCM</span>.</li>
	<li>In the <span class="reference">Database name</span> field enter the database type e.g <span class="keyword">SQL</span>, <span class="keyword">MySQL</span> etc.</li>
	<li>In the <span class="reference">Server</span> drop-down list select the Cisco UCM Publisher IP address or machine name.</li>
	<li>Click on the <span class="button no_margin">Next</span> button.</li>
	<li>Click on the radio button <span class="keyword">With SQL Server authentication using a login ID and password entered by the user</span> and click on the <span class="button no_margin">Next</span> button.</li>
	<li>Click on the check box <span class="keyword">Change the default database to:</span> and select <span class="keyword">CDR</span> and then click on the <span class="button no_margin">Next</span> button.</li>
	<li>Click on the <span class="button no_margin">Finish</span> button.</li>
	<li>Click on the <span class="button no_margin">Test Data Source</span> button and once you make sure the test is completed successfully, click on the <span class="button no_margin">OK</span> button.</li>
	<li>Now click on the <span class="button no_margin">OK</span> button.</li>
</ol>

<p>Now you will be able to see the CCM in the <span class="button">System DSN</span> list.</p>

<p>An example of ODBC setup is shown below:</p>

<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/cisco_ucm_1.png" alt="Cisco UCM" />

<h2>Configuring TIM Enterprise</h2>

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

<ol>
	<li>Browse to TIM Enterprise as normal and login with your credentials.</li>
	<li>Click on the <span class="button no_margin">Directory</span> tab.</li>
	<li>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'.</li>
	<li>Left-click on it and select <span class="button no_margin">Properties</span>.</li>
	<li>From the <span class="button no_margin">General</span> settings tab select <span class="keyword">Cisco UCM v4 DSN</span> from the PBX model list.</li>
	<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/cisco_ucm_2.png" alt="Cisco UCM" />
	<li>In the <span class="button no_margin">Connection</span> tab select <span class="keyword">System DSN connection</span> from the <span class="reference">Connection method</span> list.</li>
	<li>The DSN connection details should be automatically picked up.</li>
	<li>Finally, click on the <span class="button no_margin">Save</span> button.</li>
	<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/cisco_ucm_3.png" alt="Cisco UCM" />
</ol>

Cisco UCM (below v5)

Versions Compared

Old Version 17

New Version Current

Key

Configuring the SMDR output

Setting up a DSN connection for TIM

Enterprise

Configuring TIM Enterprise