ESP dSeries Workload Automation

 View Only

Work with Report Results stored in database (discussion)

  • 1.  Work with Report Results stored in database (discussion)

    Posted Mar 23, 2023 09:55 AM

    Sorry for the repost... I was unclear about the differences between "Discussion" and "Question" type threads.

    I would like to be able interact programmatically with report results that are stored in the ESP DE database.  There are a number of reasons for this that, for brevity sake, I won't enumerate here.  Suffice to say, the options provided in the client to get at the results are too limited to meet my requirements.

    I've found where report results are stored in the database.  It is stored as a BLOB in ESP_SS_REPORT_RESULT.DOCUMENT.  I've been able to pull that column data out and make a file out of it.  It doesn't appear to be encrypted, rather it seems to be more-or-less human readable, but the format is not something I recognize.

    I know the reports ESP DE generates are based on BIRT-- an open source software package.

    I assume client is able to leverage these packages and reverse what's stored in the database which allows the users to interact with it from inside the client.  

    What I'm looking for are clues as to how the client interacts with this data to reproduce the report, so that (hopefully) I can build my own code to interact with this data.



    ------------------------------
    Erik Schminke
    Systems Engineer
    ITS Tech Services
    Hormel Foods Corporation
    ------------------------------