Cisco UCM (below v5)

...

1. Open Windows Control Panel
2. Double click on the Administrative tools icon

3. 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 window from the following location C:\Windows\SysWOW64\odbcad32.exe

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 Enterprise 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. Click the OK button to close the control panel applet

An example of an ODBC setup is shown below:

...