Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: mark on September 16, 2010, 09:15:37 AM

Title: Infomart - which database for ETL Job History?
Post by: mark on September 16, 2010, 09:15:37 AM

Hi All,

Using GIM admin console to analyse the job run data seems to be painfully slow (especially with the refreshes).
Anyone know in which database I can find the ETL history so that I can use the data better?

I can see a lot of data in the staging DB (where are DAP connects) in STG_ETL_HISTORY, however time date/time columns only have date in, no time.

Is there a standard place where this would be and which tables should I be looking at or is the format of the column incorrect?

Cheers :)

Title: Re: Infomart - which database for ETL Job History?
Post by: mark on September 16, 2010, 12:15:50 PM

Ok i have found the answer!
the EPOCH time is appended to the JOB_ID in ETL_HISTORY. A quick export into excel, formula to get the 10 digits and a standard conversion to normal time and i can see time and date :D

wooo! hehe