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

[c3voip]

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