Cisco Unified Call Manager (below v5)

...

To set up replication you may need to speak to your database administrator or your Cisco UCM maintainer. Ensure that the SQL user described above has full access rights to this replicated table. 

 You need to know the following information in order for TIM Plus to be able to connect successfully to the Cisco UCM CDR databaseCDR database:

• The IP address or hostname of the Microsoft SQL Server database located on the Publisher node.
• Username The username and Password password to connect to the

  Referencemacro
  Label CDR

   database.

...

1. Open Windows Control Panel
2. Double click on the Administrative tools icon
3. Double click on the Data Sources (ODBC) icon
4. Select the System DSN tab and click the Add button
5. Select SQL Server from the list of available drivers and click Finish
6. In the Name field, enter  CCM
7. In the Description field enter the following: TIM Plus link to CCM
8. In the Database name field enter the database type e.g SQL, MySQL etc.
9. In the Server drop-down list select the Cisco UCM Publisher IP address or machine name
10. Click the Next button
11. Select the option  With SQL Server authentication using a login ID and password entered by the user , then click Next
12. Enable the checkbox  Change the default database to: , select CDR , then click the Next button
13. Click the Finish button
14. Click the Test Data Source button to verify your settings and, if the test is successful, click OK
15. Finally, click Click the OK button to close the control panel applet.

An example of an ODBC setup is shown below:

...

Once the DSN connection has been setupset up, log on in to TIM Plus as usual and apply perform the following settingssteps below:

1. Click on the Directory tab.
2. Choose the site you want to configure and click Properties.
   

   Screenshotmacro
   Border false URL /download/attachments/4817081/cisco_ucm_2.png

3. In the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.In the Connection method field, select
4. Select Connect to a system DSN from the drop

   Referencemacro
   Label Connection method

    drop-down list.In the DSN name field, select  
5. Select Cisco UCM v4 DSN from the drop

   Referencemacro
   Label DSN name

    drop-down list.
6. Set the Frequency option to 5.
7. In the DB script field, select Cisco UCM v4 DSN from the drop-down list.
8. Click the Save button to apply your settings.

...