Tariscope 4.x. Administrator's guide
Chapter 3. Tariscope configuration
3.14. Tariscope Observer
3.14.5. MS SQL Server database
If you select the MS SQL Server database data source, the Tariscope window will be as shown in Figure 3.14.5.1.
Figure 3.14.5.1
Now this setting is applied only to received 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 Change data source connection options link,
- in the appeared Connect to database server window (Figure 3.14.4.2), in the Authentication list, select the required type of authentication. If you use the Window Authentication, click Connect. If you use the SQL Server Authentication, type a user name and password in the User name and Password boxes, and click Connect.
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 item from the list, click on the Change data source connection options link. In the appeared Connect to database server window (Figure 3.14.4.2), setup parameters.
In the Server name box, type a name of Microsoft SQL Server to which the Tariscope Observer service will be connected.
In the Authentication list, select the type of authentication as mentioned above.
In the Database box, type a database name that contains CDR data.
Click Connect.
In the window shown in Figure 3.14.5.1, in the Table name box, type a name of the table with CDR data.
Specify the required parameters in the Fetch options section.
In the ID Field name box, type a name of the field used in the table as a unique identifier.
If necessary, in the Last ID box, type an identifier of record from which will be read the following table entries.
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 Last Date calendar box, select the time and date from which the data will be taken in handling.
In the Fetch interval box, set the interval time in seconds through that Tariscope Observer will be connected to MySQL server to check new CDR. The default value is 30 seconds.
