UCCX Database access for custom reporting on raw data

[amoskraus]

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

[Thomas G. Johannesen]

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

[amoskraus]

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