CUIC DataSource for IDS DB

Unanswered Question
Feb 21st, 2012
User Badges:


Can someone provide me with reference or instructions for how to add an Informix Database (like Call Manager Database) into CUIC DataSources?

I read that it is possible to generate reports using the CDR database from the Call Manager.



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Aaron Harrison Tue, 02/21/2012 - 02:55
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015


There's no direct infromix access to CUCM - it's all via SOAP/AXL.


Kris Lambrechts Tue, 02/21/2012 - 05:57
User Badges:
  • Cisco Employee,

The CUCM Appliance model does not have a CDR database as such. CDRs are written as flatfiles on CUCM and then you have a choice to consolidate them into the CUCM CAR database for reporting or SFTP them out to a third-party server. If you'd want to run CUIC reports against the actual CDR records you'd need to re-impor them into a database on the 3rd party server and report against that.

Besides that, the CUCM firewall does not allow external access to the Informix database. CVP's Informix database does allow this and instructions are available in the guides.



justine.joubran Wed, 02/22/2012 - 02:34
User Badges:

Thanks Kris,

You always have very informative answers.

Have you tried the "ReportXML - CallDetailReport.xml" report? Any idea if this report actually works?

I have read inside the XML code of this report that it uses 2 tables:

- TerminationCallDetail table from the HDS Database

- CallDetailRecord (most likely to be related to Call Manager)

I know that CUIC does not support 2 datasources for the same report. So, theoretically, this report should not work. However, it is posted on the Developers forum

Has this report worked for anyone? How?



Kris Lambrechts Wed, 02/22/2012 - 04:45
User Badges:
  • Cisco Employee,

Hey Justine,

I hand't seen that report before but quickly grepped through the file, there's only one SQL query in there.


datename(m,a.DateTime) as Month,


from Termination_Call_Detail a left join Call_Type b  on a.CallTypeID=b.CallTypeID

left join Peripheral c on c.PeripheralID=a.PeripheralID
left join Service d on d.SkillTargetID=a.ServiceSkillTargetID
left join Skill_Group e on e.SkillTargetID=a.SkillGroupSkillTargetID
left join Agent f on f.SkillTargetID=a.AgentSkillTargetID

left join Person g on g.PersonID=f.PersonID

left join Skill_Group h on h.SkillTargetID=e.BaseSkillTargetID

left join Route i on i.RouteID=a.RouteID

left Join Trunk_Group j on j.TrunkGroupID=a.TrunkGroupID

order by a.DateTime

These are all tables from a UCCE HDS database, this has nothing to do with CUM. They just gave the report a confusing name.



justine.joubran Tue, 02/28/2012 - 06:04
User Badges:

Thanks Kris,

It turned out that I had to add a new datasource that points to the HDS as the 2 DataSources already created (UCCE Historical and UCCE Realtime) were pointing to AWDB (this was advised by TAC).

The CallDetailReport needs a DataSource that connects to the HDS. Otherwise it is not possible to import it.

Thanks again,



This Discussion