Cisco UCM (below v5)

These instructions help you configure your Cisco Unified Call Manager up to V4.x to your older Cisco UCM to work with TIM Plus. Contact your system maintainer if you are not familiar with the configuration of your PBX.

Pbxsummary

Supportfiles1	Cisco UCM v4 DSN.TDT
Supportfiles2	Cisco UCM v4 DSN.TDS
Supportfiles3	Cisco UCM 4.DBS
Requiredtask1	Configure the SMDR output
Requiredtask3	Set up a DSN connection
Requiredtask2	Configure TIM Plus
Connection	DSN connection
RequiredTask1	Configure the SMDR output
RequiredTask2	Set up a DSN connection
RequiredTask3	Configure TIM Plus

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

Configuring your SMDR output

The This version of the Cisco UCM stores its Call Detail Records call records in a MSSQL Microsoft SQL Server database. However, however, the output by default, this functionality is not enabled by default. To enable the CDR outputit, the following 'Service' parameters need to settings must be configured on the Publisher, using using the Service Parameters Configuration configuration window:

CDR Enabled
CDR Log CallsWith Calls With 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 This version of the UCM outputs its call records to a table named

Referencemacro

Label	CallDetailRecord

in a database entitled

Referencemacro

Label	CDR

. Rather than have TIM Plus read and remove CDRs from the live

Referencemacro

Label	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. There should be Normally, there already exists a SQL User already created with the following credentials:

Username: CiscoCCMCDR
Password: dipsy

To setup set up replication you will may need to speak to your Database Administrator 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 Ensure that the SQL user described above has full access rights to the new this replicated table.

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

The IP /DNS address or hostname of the MS SQL Database which is Microsoft SQL Server database located on the Publisher node.
Username The username and Password password to connect to the CDR database (you may need to speak to your maintainer about this)
Referencemacro
Label CDR
database.

HTML
<a id="infoSet up a DSN connection"></a>

Setting up a DSN connection for TIM Plus

You will need to setup a DSN connection for To enable TIM Plus to work with the your Cisco UCM. Below you will find instructions on how to do this , you first need to set up a DSN connection. Follow the steps below to perform this task within Microsoft Windows:

Click on Windows Start.
Click on Control panel.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
Click on Select the System DSN tab .Click on the and click the Add button.
Select SQL Server from the list of available drivers and click Finish.
In the Name field, enter the following: CCM.
In the Description field enter the following: TIM Plus 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 on the Next button.
Click on the radio button Select the option With SQL Server authentication using a login ID and password entered by the user and , then click on the Next button.
Click on the check box Enable the checkbox Change the default database to: and , select CDR and , then click on the Next button.
Click on the Finish button.
Click on the Test Data Source button and once you make sure to verify your settings and, if the test is completed successfullysuccessful, click on the OK button.Now click on
Click the OK button .

...

to close the control panel applet

An example of an ODBC setup is shown below:

Screenshotmacro

Border	false
URL	http://docs.call-logger.com:8090/download/attachments/4817081/cisco_ucm_1.png

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

Configuring TIM Plus

Once the DSN connection has been setupset up, log on in to TIM Plus as usual and apply perform the following settingssteps below:

Click on the Directory tab.
Click on Choose the site configured during the setup wizard you want to configure and click Properties.
Screenshotmacro
Border false
URL http://docs.call-logger.com:8090/download/attachments/4817081/cisco_ucm_2.png
Within In the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.In
the Connection method field select Select Connect to a system DSN from the drop
Referencemacro
Label Connection method
drop-down list.In the DSN name field select
Select Cisco UCM v4 DSN from the drop
Referencemacro
Label DSN name
drop-down list.
In the Frequency field enter in 5.
In the DB script field select Enter 5 in the Frequency field.
Select Cisco UCM v4 DSN from the from the DB script drop-down list.
Finally, click on Click the Save button to apply the settings.

HTML

<hr/>
<p>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.</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 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 <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 Plus 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 Plus</h2>

<p>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:</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_plus/pbx/cisco_ucm_1.png" alt="Cisco UCM" />

<h2>Configuring TIM Plus</h2>

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

<ol>
	<li>Browse to TIM Plus as normal and login with your credentials.</li>
	<li>Click on the <span class="button no_margin">Directory</span> tab.</li>
	<li>Click on the site configured during the setup wizard and click <span class="button no_margin">Properties</span>or create a new site and click <span class="button no_margin">Properties</span>.</li>
	<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_plus/pbx/cisco_ucm_2.png" alt="Cisco UCM" />
	<li>Within the <span class="reference">Site Properties</span> window, select <span class="keyword">Cisco UCM v4 DSN</span> from the <span class="reference">PBX model</span> drop-down list.</li>
	<li>In the <span class="reference">Connection method</span> field select <span class="keyword">Connect to a system DSN</span> from the drop-down list.</li>
	<li>In the <span class="reference">DSN name</span> field select <span class="keyword">Cisco UCM v4 DSN</span> from the drop-down list.</li>
	<li>In the <span class="reference">Frequency</span> field enter in <span class="keyword">5</span>.</li>
	<li>In the <span class="reference">DB script</span> field select <span class="keyword">Cisco UCM v4 DSN</span> from the drop-down list.</li>
	<li>Finally, click on the <span class="button no_margin">Save</span> button.</li>
</ol>

Cisco UCM (below v5)

Versions Compared

Old Version 9

New Version Current

Key

Configuring your SMDR output

Setting up a DSN connection for TIM Plus

Configuring TIM Plus