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.
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
This version of the Cisco UCM stores its call records in a Microsoft SQL Server database. However, by default, this functionality is not enabled. To enable it, the following settings must be configured on the Publisher using the Service Parameters configuration window:
...
This version of the UCM outputs its call records to a table named
in a database entitled
. Rather than have TIM Plus read and remove CDRs from the live
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:
...
HTML |
---|
<a id="Set up a DSN connection"></a> |
Setting up a DSN connection for TIM Plus
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:
- 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 |
- Select the System DSN tab and click the Add button
- Select SQL Server from the list of available drivers and click Finish
- In the Name field, enter 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 the Next button
- Select the option With SQL Server authentication using a login ID and password entered by the user , then click Next
- Enable the checkbox Change the default database to: , select CDR , then click the Next button
- Click the Finish button
- Click the Test Data Source button to verify your settings and, if the test is successful, click OK
- Click the OK button to close the control panel applet
...
HTML |
---|
<a id="Configure TIM Plus"></a> |
Configuring TIM Plus
Once the DSN connection has been set up, log in to TIM Plus and perform the steps below:
- Click on the Directory tab.
- Choose the site you want to configure and click Properties.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/4817081/cisco_ucm_2.png |
---|
|
- In the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.
- Select Connect to a system DSN from the drop-down list.
- Select Cisco UCM v4 DSN from the drop-down list.
- Enter 5 in the Frequency field.
- Select Cisco UCM v4 DSN from the DB script drop-down list.
- Click the Save button to apply the settings.