Create an ODBC Connection to connect to Cisco UCCX server

Step 1: Go to Control Panel > Administrative Tools > Data Sources.

Step 2: Select the System DSN tab. ODBC Data Source Administrator window is displayed.

Step 3: Click on Add to create a new DSN.

Step 4: The Create New Data Source window is displayed. From the list of available data sources, select IBM INFORMIX ODBC DRIVER. Click Finish.

Step 5: The ODBC Driver Setup window is displayed. Enter a unique DSN name. Enter a suitable description. Click Apply.

Step 6: Select the Environment tab. Select the Use Server Database locale check box. Ensure that the entry for Fetch Buffer size field is 32767. If default entry is other than 32767, then manually change it to 32767. And change Client locale to value (en_us.819), Click Apply.

Step 7: Select the Connection tab. In the server name field, enter the instance name of Informix server of the set up. The following naming conventions must be followed when creating an instance name:

•Add the letter “i” as a prefix to the instance name, if the host name starts with a number.

•Enter the instance name after converting all upper case letters to lower case.

•Replace hyphens with underscore.

•Append the letters “_uccx” to the instance name.

For example, if the host name is “802UCCX-Ha-Node1“, then you should enter “i802uccx_ha_node1_uccx” in the server name field.

In the host name field, enter either host name or IP address of UCCX server. In service field, enter 1504 which is the TCP port number. In the ‘Protocol’ field, choose ‘onsoctcp’. In the database field, enter ‘db_cra’ which is the database name that stores historical data. In the userId field, enter ‘uccxhruser’ which is the default Historical Reporting user. The password for this user can be set at ‘Password Management’ page of the Unified CCX Administration web interface. The password management page appears under ‘tools’ menu of appadmin. In the password field of ODBC Driver set up page, enter the password which is set at ‘Password management page’ by administrator. Click Apply & Test connection.

Step 8: Ensure that the Test Connection was successful message is displayed. You can view the newly created DSN in the list of DSNs. Close the window.