Data Warehouse Heartbeat
Does your agency access the Data Warehouse (DW) for reporting purposes? If so, you are probably aware of the lag that can sometimes occur in the DW, causing the data to be out of sync with the actual Accela Production database. There is a simple query that you can execute in the DW to find the “heartbeat” or the last updated date and time that the DW was in sync with the Production database:
select * from accela.stream_heartbeat;
Marion County, who heavily relies on the DW, even wrote a report for end users to generate that shows the last updated date and time using this query so that they are aware when there is a lag.
Your comment will be posted after it is approved.
Leave a Reply.
Please be aware that this content is relevant at the time it is published, but as time goes on may become out-of-date. We will do our best to keep the content alive and relevant.
© COPYRIGHT 2019. ALL RIGHTS RESERVED.