[ Video Overview: Extract-Transform-Load (ETL) Using LabKey Server
[ Video Update: ETL Enhancements in LabKey Server v15.1
Extract-Transform-Load functionality lets you encapsulate some of the most common database tasks, especially (1) extracting
data from a database, (2) transforming
it, and finally (3) loading
it into another database. LabKey Server ETL modules let you:
- Assemble data warehouses that integrate data from multiple data sources.
- Normalize data from different systems.
- Move data in scheduled increments.
- Log and audit migration processes.
To use ETL functionality you build it into a simple module. The following topics will get you started developing ETL scripts and processes and packaging them as modules: