cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
155
Views
5
Helpful
2
Replies
Highlighted
Beginner

UCCX Database access for custom reporting on raw data

I understand we can use the API to gather structured data from UCCX, but my Business Intelligence team whats to have access to raw data.  So they can continuously report on call details.  I'm assuming there is a way, because CUIC even gives you the ability to export the SQL query.  Any additional information on this subject would be appreciated.

 

Thank you!

Amos

2 REPLIES 2
Highlighted
Contributor

Hey Amos

 

You can get the data direclty from the informix by using the informix ODBC

 

For call data look into these tables

ContactCallDetail

ContactQueueDetail

ContactRoutingDetail

 

For agent data

AgentConnectinDetail

AgentStateDetail

 

I would suggest you make a scheduled job that gets the data from informix and put them into the datawarehouse (Daily, og what ever is best for you)

 

Best regards Thomas

Highlighted

Thanks for your reply Thomas. Do you know if there's any procedure documentation on how to set this up?