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

[Dennis Heim]

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<mailto:dennis.heim at cdw.com>
www.berbee.com<http://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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090715/5050182a/attachment.html>