<p>These instructions should assist in configuring your Cisco UCM to
work with TIM EnterprisePlus. 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 EnterprisePlus will connect to what is called 'CDR'. Within this database there is a table called 'CallDetailRecord'. Rather than TIM EnterprisePlus 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 EnterprisePlus 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<Plus</h2>
<p>You will need to setup a DSN connection for TIM EnterprisePlus 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: 'CCM'.</li>
<li>In the <span class="reference">Description</span> field enter the following: 'TIM EnterprisePlus link to CCM'.</li>
<li>In the <span class="reference">Database name</span> field enter the database type e.g SQL, MySQL 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="reference">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="reference">Change the default database to:</span> and select 'CDR' 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_enterpriseplus/pbx/cisco_ucm_1.png" alt="Cisco UCM" />
<h2>Configuring TIM Enterprise<Plus</h2>
<p>Below you will find steps on how to configure TIM EnterprisePlus to listen for SMDR data from your Cisco UCM 4.0:</p>
<ol>
<li>Browse to TIM EnterprisePlus as normal and login with your credentials.</li>
<li>Click on the <span class="button no_margin">Directory</span> tab.</li>
<li>Go<li>Click theon the pointsite inconfigured the Directory where you need to add during the PBXsetup Objectwizard 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>or create a new site and click <span class="button no_margin">General</span> settings tab select <span class="keyword">Cisco UCM v4 DSN</span> from the PBX model list>Properties</span>.</li>
<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterpriseplus/pbx/cisco_ucm_2.png" alt="Cisco UCM" />
<li>In<li>Within the <span class="button no_margin">Connection<reference">Site Properties</span> tabwindow, select <span class="keyword">System>Cisco DSNUCM connection<v4 DSN</span> from the <span class="reference">Connection>PBX method<model</span> drop-down list.</li>
<li>The<li>In DSNthe connection details should be automatically picked up<span class="reference">Connection method</span> field select <span class="keyword">Connect to a system DSN</span> from the drop-down list.</li>
<li>Finally,<li>In clickthe on the <span class="reference">DSN name</span> field select <span class="button no_margin">Save<keyword">Cisco UCM v4 DSN</span> buttonfrom the drop-down list.</li>
<img<li>In the <span class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/pbx/cisco_ucm_3.png" alt="Cisco UCM" />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> |