Marienlyst needed 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 solution: An Appivo-developed integration that collects the planned hours for the coming day at midnight each night. At 10 in the morning the following day the integration 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 also stored for intermediate use in Appivo's cloud database, and access via a secure reporting interface. The reporting interface also provides access to additional aggregated reports, downloaded in Excel format.