Altigen AltiWare OE 4.0, Administration Manual

Page: 45 / 238

Setting up Call Reports
AltiWare OE System Administration Manual 35
S
ystem
C
o
n
fig
u
ra
tio
n
Setting External Logging
AltiWare allows you to output call accounting to a Microsoft SQL 7
database or to a third party external application.
In either case, the database cannot be on the same server as the AltiWare
system. A system integrator or database developer will need to write a
custom query to extract data from the SQL database.
You can send reports from a number of different AltiServ systems to the
same database.
Before you enable external logging using this window, you
need to set up and configure the database. It should be ready
to receive the reports before you enable the export here.
Enabling the External Log
After setting up the database, run AltiWare Administrator, select System
Configuration on the Management menu and open this Call Reports
window. Select one of the following:
• Enable Altigen External CDR to use AltiGen’s implementation of
the Microsoft SQL database.
• Enable 3rd-Party External CDR to export the data to a third party
application.
In either case, type the external server’s IP address into the IP box.
Using the CDR Buffer Size box, type in a maximum number of records to
hold in a buffer while sending out CDR data. The range is from 100 –
10,000, with a default of 500.
AltiGen does not provide any SQL backup and restore utility.
We strongly recommend that you use SQL Backup and
Maintenance utility to perform daily backup and maintenance
jobs; and use a restore utility to restore the database. If you need to
reconstruct the SQL server, run the External Logger Setup to create an
empty calldb database before restore.
Exporting Through a Local Port
You can send the CDR to a COMM Port to export to, for example, an
accounting data processing system.
To do this, select the Enable Data Output box. Then select an Available
Port and the Baud Rate.