CDR reports with external application

Unanswered Question

We have CCM 4.1.3 and we use a 3rd party app eGlue to pull reports from SQL (CDR) database.

We are in the process of upgrading to CUCM 6.x and I'm not sure how I can access the CDR databate, as it's on Informix and the appliance is locked down.

I read somewhere that I can use AXL, but I'm still not clear.

Any ideas?

thanks in adv,

:JoeL

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 2 (1 ratings)
Loading.
Jaime Valencia Thu, 03/26/2009 - 13:36

you can also use SOAP to access CDR, there are already some 3rd party billing servers designed for linux appliances

HTH

java

if this helps, please rate

Sascha Monteiro Thu, 03/26/2009 - 14:08

it's easier to use the ftp push from the cucm.

Go to Serviceability -> Tools -> CDR Management

add a billing application server, just make sure you have ftp or sftp running on the receiving server

kraghavansag Fri, 03/27/2009 - 23:39

yes. I will also go with this approach of pushing cdr to an external ftp server. You can run a free ftp server software like freeftpd which will take care of both ftp server(for cdr management) and sftp server (scheduled backup & patch installation).

thanks for the responses guys...

I get the flat files through sftp fine..

I could not get anything from the programming reference...

I am trying to upload the flat files back to an SQL server, so that my users can run the same sql queries to obtain the reports...has anyone done this.?

I can get a few things to work but I'm still struggling getting multiple flat files to the same table, making sure that the column header doesn't get added multiple times, automating the process of running import wizard to import files to the database...

has anyone taken this crazy path...if so pls help..thanks..

joel

Actions

This Discussion