Tariscope 4.5.x. Administrator's guide
Chapter 4 Tariscope configuration
4.13. Tariscope Observer
4.13.5. MS SQL Server database
If you select the MS SQL Server database data source and click on the Data source configuration button (Figure 4.13.2), the Data source configuration window appears as shown in Figure 4.13.5.1.
Figure 4.13.5.1
Now this setting is applied only to receive the CDR data from Cisco Unified CallManager version 4.0 (herein "CUCM v4") or Telesystems Oktell.
The Preset list allows to select a preset for telephone system. Now the list contains the following options:
- Custom.
- Cisco CallManager 4.
- Telesystems Oktell.
The Custom option requires from the Tariscope administrator to manually set all parameters.
If you need to setup Tariscope Observer to working with CUCM v4,:
- select the Cisco CallManager 4 item,
- click on the Click here to change server connection link,
- in the appeared additional boxes, select the required type of authentication. If you use the SQL Server Authentication, type a username and password in the User name and Password boxes, and click Save.
On this the configuration of parameters for CUCM v4 is finished.
You need execute the same actions, if you select the Telesystems Oktell item in the Preset list.
For the Custom option, click on the Click here to change server connection link. In the appeared additional boxes, select the required type of authentication and setup parameters.
In the Table name box, type a name of the table with CDR data.
In the ID field name box, type a name of the field used in the table as a unique identifier.
In the ID field type list, select the ID field type. By default, it is Guid.
In the Data field name box, type a name of the date field in the table of calls stored in the MS SQL server.
In the Data field type list, select the data field type.
If necessary, in the Last ID box, type an identifier of record from which will be read the following table entries.
In the Interval box, set the interval time. The value in the box is specified in the following format: hh:mm:ss, where hh = hours, mm = minutes, ss = seconds.
In the Last Date calendar box, select the time and date from which the data will be processed.
