Quick Search
Browse
Pages
Blog
Labels
Attachments
Mail
Advanced
What’s New
Space Directory
Feed Builder
Keyboard Shortcuts
Confluence Gadgets
Log In
Dashboard
TIM Plus
Copy Page
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account. You can also
Sign Up
for a new account.
This page is being edited by
.
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
More colours
Strikethrough
Subscript
Superscript
Monospace
Clear Formatting
Bullet list
Numbered list
Outdent
Indent
Align left
Align center
Align right
Link
Table
Insert
Insert Content
Image
Link
Attachment
Symbol
Emoticon
Wiki Markup
Horizontal rule
tinymce.confluence.insert_menu.macro_desc
Info
JIRA Issue
Status
Gallery
Tasklist
Table of Contents
Other Macros
Undo
Redo
Find/Replace
Keyboard Shortcuts Help
<p>These instructions help you configure your older Cisco UCM to work with TIM Plus. Contact your system maintainer if you are not familiar with the configuration of your PBX.</p><p><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3BieHN1bW1hcnk6U3VwcG9ydGZpbGVzMT1DaXNjbyBVQ00gdjQgRFNOLlREVHxTdXBwb3J0ZmlsZXMyPUNpc2NvIFVDTSB2NCBEU04uVERTfFN1cHBvcnRmaWxlczM9Q2lzY28gVUNNIDQuREJTfFJlcXVpcmVkdGFzazE9Q29uZmlndXJlIHRoZSBTTURSIG91dHB1dHxSZXF1aXJlZHRhc2szPVNldCB1cCBhIERTTiBjb25uZWN0aW9ufFJlcXVpcmVkdGFzazI9Q29uZmlndXJlIFRJTSBQbHVzfENvbm5lY3Rpb249RFNOIGNvbm5lY3Rpb258UmVxdWlyZWRUYXNrMT1Db25maWd1cmUgdGhlIFNNRFIgb3V0cHV0fFJlcXVpcmVkVGFzazI9U2V0IHVwIGEgRFNOIGNvbm5lY3Rpb258UmVxdWlyZWRUYXNrMz1Db25maWd1cmUgVElNIFBsdXN9&locale=en_GB&version=2" data-macro-name="pbxsummary" data-macro-parameters="Connection=DSN connection|RequiredTask1=Configure the SMDR output|RequiredTask2=Set up a DSN connection|RequiredTask3=Configure TIM Plus|Requiredtask1=Configure the SMDR output|Requiredtask2=Configure TIM Plus|Requiredtask3=Set up a DSN connection|Supportfiles1=Cisco UCM v4 DSN.TDT|Supportfiles2=Cisco UCM v4 DSN.TDS|Supportfiles3=Cisco UCM 4.DBS"></p><table class="wysiwyg-macro" data-macro-name="html" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2h0bWx9&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre><a id="Configure the SMDR output"></a></pre></td></tr></table><h2>Configuring your SMDR output</h2><p>This version of the Cisco UCM stores its call records in a Microsoft SQL Server database. However, by default, this functionality is not enabled. <span style="font-size: 10.0pt;line-height: 13.0pt;">To enable it, the following settings</span><span style="font-size: 10.0pt;line-height: 13.0pt;"> must be configured on the </span><span class="reference" style="font-size: 10.0pt;line-height: 13.0pt;">Publisher</span><span style="font-size: 10.0pt;line-height: 13.0pt;"> using the </span><span class="reference" style="font-size: 10.0pt;line-height: 13.0pt;">Service Parameters</span><span style="font-size: 10.0pt;line-height: 13.0pt;"> configuration window:</span></p><ul><li>CDR Enabled</li><li>CDR Log Calls With Zero Duration Flag</li><li>Call Diagnostics Enabled</li></ul><p>This version of the UCM outputs its call records to a table named <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3JlZmVyZW5jZW1hY3JvOkxhYmVsPUNhbGxEZXRhaWxSZWNvcmR9&locale=en_GB&version=2" data-macro-name="referencemacro" data-macro-parameters="Label=CallDetailRecord"> in a database entitled <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3JlZmVyZW5jZW1hY3JvOkxhYmVsPUNEUn0&locale=en_GB&version=2" data-macro-name="referencemacro" data-macro-parameters="Label=CDR">. Rather than have TIM Plus read and remove CDRs from the live <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3JlZmVyZW5jZW1hY3JvOkxhYmVsPUNhbGxEZXRhaWxSZWNvcmR9&locale=en_GB&version=2" data-macro-name="referencemacro" data-macro-parameters="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 require it. Normally, there already exists a SQL User with the following credentials:</p><ul><li><strong>Username:</strong> <span class="keyword">CiscoCCMCDR</span></li><li><strong>Password:</strong> <span class="keyword">dipsy</span></li></ul><p>To set up replication you may need to speak to your database administrator or your Cisco UCM maintainer. <span style="font-size: 10.0pt;line-height: 13.0pt;">Ensure that the SQL user described above has full access rights to this replicated table. </span></p><p><span style="font-size: 10.0pt;line-height: 13.0pt;">You need to know the following information in order for TIM Plus to be able to connect to the Cisco UCM CDR database:</span></p><ul><li>The IP address or hostname of the Microsoft SQL Server database located on the <span class="reference">Publisher</span> node.</li><li>The username and password to connect to the <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3JlZmVyZW5jZW1hY3JvOkxhYmVsPUNEUn0&locale=en_GB&version=2" data-macro-name="referencemacro" data-macro-parameters="Label=CDR"> database.</li></ul><table class="wysiwyg-macro" data-macro-name="html" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2h0bWx9&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre><a id="Set up a DSN connection"></a></pre></td></tr></table><h2>Setting up a DSN connection for TIM Plus</h2><p>To enable TIM Plus 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:</p><ol><li><span style="font-size: 10.0pt;">Open Windows <strong>Control Panel</strong></span></li><li>Double click on the <span class="button no_margin">Administrative tools</span> icon</li><li><p>Double click on the <span class="button no_margin">Data Sources (ODBC)</span> icon to open the <span class="reference">ODBC Data Source Administrator</span> window</p><table class="wysiwyg-macro" data-macro-name="info" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm99&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p class="reference">For a 64 bit system, access the <span class="reference">ODBC Data Source Administrator </span>from the following location <span class="reference">C:\Windows\SysWOW64\odbcad32.exe</span></p></td></tr></table></li><li>Select the <span class="button no_margin">System DSN</span> tab and click the <span class="button no_margin">Add</span><span style="font-size: 10.0pt;"> button</span></li><li>Select <span class="reference">SQL Server</span> from the list of available drivers and click <span class="button no_margin">Finish</span></li><li>In the <span class="reference">Name</span> field, enter <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 the <span class="button no_margin">Next</span> button</li><li>Select the option <span class="keyword">With SQL Server authentication using a login ID and password entered by the user</span> , then click <span class="button no_margin">Next</span></li><li>Enable the checkbox <span class="keyword">Change the default database to:</span> , select <span class="keyword">CDR</span> , then click the <span class="button no_margin">Next</span> button</li><li>Click the <span class="button no_margin">Finish</span> button</li><li>Click the <span class="button no_margin">Test Data Source</span> button to verify your settings and, if the test is successful, click <span class="button no_margin">OK</span></li><li>Click the <span class="button no_margin">OK</span> button to close the control panel applet</li></ol><p>An example of an ODBC setup is shown below:</p><p><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3NjcmVlbnNob3RtYWNybzpCb3JkZXI9ZmFsc2V8VVJMPS9kb3dubG9hZC9hdHRhY2htZW50cy80ODE3MDgxL2Npc2NvX3VjbV8xLnBuZ30&locale=en_GB&version=2" data-macro-name="screenshotmacro" data-macro-parameters="Border=false|URL=/download/attachments/4817081/cisco_ucm_1.png"></p><table class="wysiwyg-macro" data-macro-name="html" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2h0bWx9&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre><a id="Configure TIM Plus"></a></pre></td></tr></table><h2>Configuring TIM Plus</h2><p>Once the DSN connection has been set up, log in to TIM Plus and perform the steps below:</p><ol><li>Click on the <span class="button no_margin">Directory</span> tab.</li><li>Choose the site you want to configure and click <span class="button no_margin">Properties</span>.<br /><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3NjcmVlbnNob3RtYWNybzpCb3JkZXI9ZmFsc2V8VVJMPS9kb3dubG9hZC9hdHRhY2htZW50cy80ODE3MDgxL2Npc2NvX3VjbV8yLnBuZ30&locale=en_GB&version=2" data-macro-name="screenshotmacro" data-macro-parameters="Border=false|URL=/download/attachments/4817081/cisco_ucm_2.png"></li><li>In 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>Select <span class="keyword">Connect to a system DSN</span> from the <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3JlZmVyZW5jZW1hY3JvOkxhYmVsPUNvbm5lY3Rpb24gbWV0aG9kfQ&locale=en_GB&version=2" data-macro-name="referencemacro" data-macro-parameters="Label=Connection method"> drop-down list. </li><li>Select <span class="keyword">Cisco UCM v4 DSN</span> from the <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3JlZmVyZW5jZW1hY3JvOkxhYmVsPURTTiBuYW1lfQ&locale=en_GB&version=2" data-macro-name="referencemacro" data-macro-parameters="Label=DSN name"> drop-down list.</li><li>Enter <span class="keyword">5</span> in the <span class="reference">Frequency</span> field.</li><li><span style="color: rgb(80,80,80);">Select </span><span class="keyword">Cisco UCM v4 DSN</span><span style="color: rgb(80,80,80);"> from the </span><span class="reference">DB script</span> drop-down list.</li><li>Click the <span class="button no_margin">Save</span> button to apply the settings.</li></ol>
Attachments
Labels
Location
< Edit
Preview >
Loading…
Save
Cancel
Next hint
search
attachments
weblink
advanced