[cisco-voip] CCM 4.1.3 CDR -> CUCM 7.1.2 CDR

[wazab]

You can refer him to this link which contains the field descriptions for
your version of CUCM.
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_1_2/cdrdef/cdrf
des.html#wp1210820



-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of c3voip
Sent: Wednesday, July 15, 2009 9:10 PM
To: 'Ryan Ratliff'; 'Dennis Heim'
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CCM 4.1.3 CDR -> CUCM 7.1.2 CDR

Is there an example flat file somewhere that I can give to my DBA to play
with?

Thanks,
-C

-----Original Message-----
From: Ryan Ratliff [mailto:rratliff at cisco.com]
Sent: Wednesday, July 15, 2009 2:01 PM
To: Dennis Heim
Cc: c3voip; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CCM 4.1.3 CDR -> CUCM 7.1.2 CDR

To clarify Dennis' question the method CUCM 5.x and later uses for automatic
CDR/CMR upload is via flat files.  To get them into an SQL server you would
need to take those flat files and use whatever method you wish to import
them.

-Ryan

On Jul 15, 2009, at 1:54 PM, Dennis Heim wrote:

Can you billing system pull records from flat files?



Dennis Heim
Network Voice Engineer
CDW  Advanced Technology Services
11711 N. Meridian Street, Suite 225
Carmel, IN  46032

317.569.4255 Office
317.569.4201 Fax
317.694.6070 Cell

dennis.heim at cdw.com
www.berbee.com



From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip- 
bounces at puck.nether.net] On Behalf Of c3voip
Sent: Wednesday, July 15, 2009 1:49 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] CCM 4.1.3 CDR -> CUCM 7.1.2 CDR



I am preparing for an upgrade from a CCM 4.1.3 Cluster with off- 
cluster CDR to CUCM 7.1.2.



Our current billing system is set up to pull from an MS SQL server,  
since that is what CCM 4.1.3 uses.



Since our billing system is tied in with many of our other IT systems  
billing functions, changing it is probably out of the question.



My question: Is there a way to import the Informix DB CDR into the  
current MS SQL database?



I am not a DBA by any stretch, but do I just need a server to copy  
the CDR's from the CUCM to that is running Informix then use an ODBC  
driver to run queries to copy the data from Informix to my existing  
SQL database?



Is there documentation on this somewhere?



Thanks,

-C

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip