cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1997
Views
5
Helpful
2
Replies

UCCX Database access for custom reporting on raw data

amoskraus
Level 1
Level 1

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

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

Please rate helpful posts and if applicable mark "Accept as a Solution".
Thanks, Thomas G. J.

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