Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

Overview

Sends HR data combined from the Oracle DW and Person Registry to Enterprise Health, a health requirements tracking platform used by Occupational Health team at Tufts.

The integration runs daily via a job in the Denodo Scheduler that sends data incrementally by checking for rows that are new or changed compared to the data cached the previous day. The feed relies on the fetching of a session ID from Enterprise Health via Lambda to make more rapid, susccessive API calls.

Design

Components

  • Denodo VDP

    • human_resources

      • 01-base_layer

        • 01-connections

          • ds_eh_hr_feed_data_queue

          • ds_eh_hr_feed_session_id

        • 02-base_views

          • bv_eh_hr_feed_data_queue

          • bv_eh_hr_feed_session_id

      • 02-transformations

        • persons_health

        • persons_health_current_cache

        • persons_health_previous_cache

      • 03-integration

        • j_persons_health_country

        • persons_eh_hr_feed_data_queue_history

        • persons_health_current_previous_diff

        • persons_eh_hr_feed_data_queue_incremental

        • persons_eh_hr_feed_data_queue_manual

  • Denodo Scheduler

    • eh_hr_feed_data_queue

  • Lambda

How-To

Force a full data load

Invalidate the cache for persons_health_previous_cache via the Design Studio UI or using this query

ALTER VIEW persons_health_previous_cache
CACHE INVALIDATE ON CASCADE;

Once the cache is invalidated, run the feed job in the scheduler.

  • No labels