[cisco-voip] SQL dips

[Ryan Ratliff]

1. There is no SQL database on CUCM 7 there is only the informix  
database and no, it cannot be moved.
2. It will be much easier in the end to export the flat files, write  
up some quick script (or find one on the internet) to import the flat  
file data into a SQL database, and let them run their reports from  
there.

The AXL web interface does give them the ability to run queries  
against the database directly but when you do this you are competing  
for resources on the server that processes your phone calls.

I'm not sure where you got the idea that any database was getting  
moved but that just isn't possible with the appliance based CUCM.

-Ryan

On Aug 26, 2009, at 9:16 AM, Kevin Dunn wrote:

Okay I think I have a firm grasp on what these guys are asking for:

They don't want a flat file, but rather the actual SQL Database, in  
CCM 4.1 they exported teh CDR to their SQL server and performed the  
queries from there.

1.  If I remove the SQL database from CUCM 7.0 what will that break?
2.  Can I add a login to the CUCM7.0 just for running queries (read  
only)?

I think it is going to be easier to train the db guys how to log into  
CUCM and run their queries than it will be to move the data.  I am  
afraid of what will break if the database is moved.

Kevin

On Fri, Aug 21, 2009 at 12:08 PM, Dennis Heim <Dennis.Heim at cdw.com>  
wrote:
With the appliance model you would need to setup a CDR/billing server  
via sftp (have had problems in the past with ftp). It will push flat  
files to this server. Then you would need to put those into a db. Then  
you would have your CDR source in an sql db. There are 3rd part cdr  
apps out that that will do all that for you.


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 Kevin Dunn
Sent: Friday, August 21, 2009 12:43 PM
To: Cisco Voice
Subject: [cisco-voip] SQL dips


In CCM 4.1 we pulled the CDR and moved it to an external SQL server,  
so my boss and other directors could quesry 911 calls and  
International calls by department, while not actually manipulating the  
CCM server.


Now that we have upgraded to CUCM 7.0.2 I notice there are run sql  
commands and enduser is actually a table in the SQL database now, not  
just stored in directory.


My question:  How difficult is it to copy the CDR instead of moving  
it?  I would like to push the CDR/CAR to the SQL server like before  
but keep the original copy on the CUCM Publisher.  Can I do that (if  
so how)?


Is anyone else doing that?


The reason is my director is "an SQL guy" who doesn't like the canned  
reports from Cisco, he wants his own queries.  So my thought is if  
there are ample [run sql SELECT whatever from Whatever] commands he  
needs we may not need to MOVE the CDR and Car, rather he can learn to  
get the information from teh new CUCM server without destroying it.


Thoughts, Comments?


Kevin


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