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.

• Tutorial: Extract-Transform-Load (ETL) - Develop an ETL module.
• ETL: Configuration and Schedules - Configure the refresh schedule.
• ETL: Column Mapping - Transform columns in an ETL process.
• ETL: Stored Procedures - Use a stored procedure as a transformation.
• ETL: SQL Scripts - Create table schemas with sql scripts.
• ETL: Logs and Error Handling - Logging and error reporting.
• ETL: Remote Connections - Extract data via a remote connection.
• ETL: Examples - Example ETL modules.
• ETL: Reference - File references, directory structure.

Related Topics

• External Schemas and Data Sources
• SQL Query Browser