The Data Integration & ETL (Extract, Transform, Load) Service enables the secure and efficient transfer of data between source systems (such as Taleo, Canvas, HealthStream, and HRIS) and internal platforms like HRHub, LMS, and reporting dashboards. This service supports automated workflows, scheduled data synchronization, and one-time data migrations.
By centralizing data processing, transformation, and loading operations, this service ensures consistency, improves reporting accuracy, and supports real-time and batch data availability across systems.
Authorized MUHC Teams and System Owners
- Scheduled & On-Demand ETL Jobs
- Automated daily, weekly, or hourly data syncs.
- On-demand data pulls for urgent or ad-hoc needs.
- Source System Integrations
- Connectors available for Taleo, Canvas, PeopleSoft, Cornerstone SBX, UKG, and other internal systems.
- Secure data extraction using APIs, flat files (CSV, XML, JSON), or database links.
- Data Transformation & Mapping
- Business logic applied to raw data (e.g., date formatting, ID translation).
- Standardized data mapping to fit downstream system schemas.
- Validation & Error Logging
- Automated checks for missing fields, incorrect formats, and inconsistencies.
- Errors logged and flagged with notifications to responsible teams.
- Monitoring & Audit Trail
- Full audit logs of ETL activity for compliance and troubleshooting.
- Email alerts for success, failure, and retry attempts.
To request a new integration or modify an existing ETL process, submit a ticket.