Marienlyst had a need to track actual vs planned hours and transfer that data to their Business Intelligence system. Shifts are tracked in a 90-day window - current month, previous month and the coming month. The integration collects the planned hours for the coming day at midnight each night. At 10 in the morning the following day it collects the approved actual hours, builds a report in CSV-format and uploads it via SFTP to a site where the BI-system can fetch it. Data is stored for intermediate use in Appivos cloud database. The integration has a UI where the data can be viewed, additional aggregated reports can also be collected and downloaded in Excel-format.