ETL Monitor on a Web Report

    ETL Monitor on a Web Report

    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


    Jorge López Hernández

    Business Intelligence Consultant

    +34 912 868 220– jlopezhernandez@quental.com
    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 :thumbsup: :thumbsup:


    Jorge López Hernández

    Business Intelligence Consultant

    +34 912 868 220– jlopezhernandez@quental.com