Starting from release CS1000 7.5 (maybe even earlier) Avaya offers toolkit that allows you to configure CDR collection ( Avaya CDR/Traffic Toolkit 2.0)
It is available on devconnect:
http://www.devconnectprogram.com/site/global/products_resources/communication_server_1000/interfaces/data_buffering_and_access_cdr/releases/index.gsp
Because it is a toolkit you still need some development to make it work.
I've created a simple script that saves content of the CDR output text file to MS SQL database.
You need to create a table with format described in bcp.fmt format file and schedule this script to run every 15 minutes (default output time of Avaya CDR collector).
Insert_CDR_to_DB.zip
No comments:
Post a Comment