Cisco Unified Call Manager up to V4.x

...

1. Click on Windows Start.
2. Click on Control panel.
3. Double click on Administrative tools icon.
4. Double click on Data Sources (ODBC) icon.
5. Click on the System DSN tab.
6. Click on the Add button.
7. Select SQL Server from the list and click Finish.
8. In the Name field enter the following: CCM.
9. In the Description field enter the following: TIM Plus link to CCM.
10. In the Database name field enter the database type e.g SQL, MySQL etc.
11. In the Server drop-down list select the Cisco UCM Publisher IP address or machine name.
12. Click on the Next button.
13. Click on the radio button With SQL Server authentication using a login ID and password entered by the user and click on the Next button.
14. Click on the check box Change the default database to: and select CDR and then click on the Next button.
15. Click on the Finish button.
16. Click on the Test Data Source button and once you make sure the test is completed successfully, click on the OK button.
17. Now click on the OK button.

Now you will be able to see the CCM in the System DSN list.

An example of ODBC setup is shown below:

...

1. Click on the Directory tab.
2. Select the site configured during the setup wizard and click Properties.
   

   Screenshotmacro
   Border false URL http://docs.call-logger.com:8090/download/attachments/4817081/cisco_ucm_2.png

3. Within the Site Properties window, select Cisco UCM v4 DSN from the PBX model drop-down list.
4. In the Connection method field, select Connect to a system DSN from the drop-down list.
5. In the DSN name field, select Cisco UCM v4 DSN from the 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 on the Save button to apply the settings.