Hello comunity,

We work on a self maintenance project for the final user. Our users execute a few etl jobs by macro on a web report(the users only have permissions to see the report manager). Sometimes this etl jobs have errors or warnings, due to permission, users are unaware of the etl execution state.
For this reason we need recreate on a web report the etl status monitor. To do this, we think to create a Dynarange with ODBC connection against the internal H2 db (h2.hist.db on Jedox Suite\tomcat\webapps\etlserver\data\db\etl_history). After install the ODBC driver we cant create de ODBC DSN connection.
Someone have any experience with internal H2 ODBC connection?

Thanks for all

HI Seaben

At first moment i thought to create a LOG Cube with h2 tables like sources, but this option are discarted for a one reason, its a post hoc process and lose a so important info, the status of the job in real time. With a ODBC dynrange against de H2 query and the auto refresh option (10 seconds are the minimun time to refresh) it's possible create a real time monitor layout on web report.


Well this its the theory, to perform it i "only" need connect to the h2 db