Cisco UCM (below v5)

<p>These instructions should assist in configuring your Aastra BP 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>CiscoCCMCDR</li>
	<li><b>Password: </b>dipsy</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>



<h2>Configuring TIM Enterprise</h2>

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

<ol>
	<li>Browse to TIM Enterprise as normal and login with your credentials.</li>
	<li>Click on the <span class="button" id="list">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 'Aastra BP'.</li>
	<li>Left-click on it and select <span class="button" id="list">Properties</span>.</li>
	<li>From the <span class="button" id="list">General</span> settings tab select <span class="keyword">Aastra BP</span> from the PBX model list.</li>
	<img src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/aastra_bp_2.png" alt="Aastra BP" />
	<li>In the <span class="button" id="list">Connection</span> tab select <span class="keyword">No connection required</span> from the <span class="reference">Connection method</span> list.</li>
	<li>Finally, click on the <span class="button" id="list">Save</span> button.</li>
	<img src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/aastra_bp_3.png" alt="Aastra BP" />
</ol>