<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>
<ol>
<li>Click on Windows <span class="button" id="list">Start</span>.</li>
<li>Click on <span class="button" id="list">Control panel</span>.</li>
<li>Double click on <span class="button" id="list">Administrative tools</span> icon.</li>
<li>Double click on <span class="button" id="list">Data Sources (ODBC)</span> icon.</li>
<li>Click on the <span class="button" id="list">System DSN</span> tab.</li>
<li>Click on the <span class="button" id="list">Add</span> button.</li>
<li>Select <span class="reference">MySQL ODBC 3.51 Driver</span> from the list and click <span class="button" id="list">Finish</span>. If you cannot see the <span class="reference">MySQL ODBC 3.51 Driver</span> you will need
to download this from <a href="http://www.mysql.com">http://www.mysql.com</a>.</li>
<li>In the <span class="reference">Name</span> field enter the following: 'shoretel'.</li>
<li>In the <span class="reference">Description</span> field enter the following: 'TIM Enterprise link to ShoreTel'.</li>
<li>In the <span class="reference">Server</span> field enter the IP Address of the ShoreWare Server.</li>
<li>In the <span class="reference">Username</span> field enter the username that was created for the ShoreWareCDR database.</li>
<li>In the <span class="reference">Password</span> field enter the password that was created for the ShoreWareCDR database.</li>
<li>In the <span class="reference">Database</span> drop-down list select 'ShoreWareCDR'.</li>
<li>Now click on the <span class="button" id="list">Test</span> button which will confirm if the information you entered is correct and connection is successful.</li>
<li>Click on the <span class="button" id="list">OK</span> button and then again to close the window.</li>
</ol>
<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> |