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
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
Thanks for your reply Thomas. Do you know if there's any procedure documentation on how to set this up?