Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

CDR CCM4:does database deleted if I use flat file

hi,

I'm still working on a CCM4.2 that is working in live.

His CDR is still working on CCM Database,not in Flat File.

If I'll use flat file, does the database still have the CDR like in CCM5, and 6

regards,

Antra

6 REPLIES
Cisco Employee

Re: CDR CCM4:does database deleted if I use flat file

Not sure what you mean by that, all the CUCM releases use flat files as the 1st step before sending the info to the respective DB.

The fields have changed and so does the method. In Windows you had CDR/CAR DBs, in Linux only CAR DB exists.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Community Member

Re: CDR CCM4:does database deleted if I use flat file

I want to use a billing system like stonevoice. So i want flat files.

So if i'll use flat file, does CDR is will still inserted in the CM database?

With this I'll have at the same the same time the flat file data and DB data.

regards,

antra

Cisco Employee

Re: CDR CCM4:does database deleted if I use flat file

If you take the flat files before they're processed and uploaded to CDR, CDR DB will be empty.

Not sure how/where your system will pull the flat files and if it will just copy or cut the files.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Super Bronze

Re: CDR CCM4:does database deleted if I use flat file

Hi

Don't get hung up on the mechanics of what will happen with the flat files - just let CCM put them into the DB as it is designed to do.

If StoneVoice support CM4 for their billing software, it will access the data from the database. Just follow their instruction manual...

If they don't support CM4, get different software.

Keep it simple :-)

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Community Member

Re: CDR CCM4:does database deleted if I use flat file

Thank yo for answers,

I want to do this because the CCM system will be upgraded to 8. Operating Systems are differents.

So I want take the modularity : The CCMAdministrator want to have the CAR output from CCM, and the billing system want to have its output with the billing software because it gives good reports and graphical chart.

.

Super Bronze

Re: CDR CCM4:does database deleted if I use flat file

Hi

So it works like so in CM4.x:

  • CCM service outputs flat files
  • CCM CDR insert service inserts files to the 'CDR' SQL DB.
  • From there, CAR has it's own database named 'CAR' or something similar that is seperate to the CDR DB. It has it's own service that reads from the CDR database into the CAR DB.
  • Your CDR package should do the same thing - read from the CDR DB into it's own DB.

There's no reason why CAR and the third party app can't coexist without any problems - lots of my customers do this.

When you upgrade to CM8.x, it will work a little differently - CAR will be compatible with the new mechanisms in CM8, and will read data in to it's own DB as it does on 4.x

The third party app if compatible with CM8.x will use one of the new 8.x mechanisms - usually CM is set to FTP the flat files off to an FTP server that is part of the third party app server.

So on both versions, you can enable and configure CAR as well as having a third party app configured.

Regards

Aaron

Please rate helpful posts and mark answered questions that you've got a satisfactory response from to help identify useful content in the forums...
https://supportforums.cisco.com/docs/DOC-6212

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
186
Views
0
Helpful
6
Replies
CreatePlease to create content