I am running CUCM 7.1.3 and I am wanting to write my own web application that will let me query data from the CDR database. I keep finding resources that show on the older systems (when they ran Windows) you would just connect to the sql server and query. I fear that it's not so simple these days and there is a different method of doing so. My guess is some kind of SOAP or XML call ?
You can also qry directly the DB
CDRonDemand SOAP Service
If this helps, please rate
UCM will FTP flat files of the CDR records to a server of your choosing. It's up to your application to parse them and load the records into SQL.