Infomart - which database for ETL Job History?

NICE CXone API & Integrations
1

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 :slight_smile:

2

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 :smiley:

wooo! hehe

1 Like