You can get the data direclty from the informix by using the informix ODBC
For call data look into these tables
For agent data
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.