09-04-2020 02:19 PM
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
09-06-2020 10:18 AM - edited 09-06-2020 10:19 AM
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
09-08-2020 10:34 AM
Thanks for your reply Thomas. Do you know if there's any procedure documentation on how to set this up?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide