...

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.

Design

WIPThe 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

  • enterprise-health

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.