Skip to content

NEWUnify Agents (MCP): governed AI access to finance data. Early access.See Unify Agents

GLOSSARY

What is ETL?

DEFINITION

ETL is the process of extracting data from source systems, transforming it into a target shape and loading it into a destination such as a data warehouse.

Also called: ETL, ELT, Data pipeline

How it works

Extract pulls data from applications and databases. Transform cleans, joins and reshapes it. Load writes it to a warehouse or lake for analytics. Modern stacks often use ELT, loading raw data first and transforming it inside the warehouse. ETL serves internal analytics; it usually runs in batches and is owned by data teams rather than product engineers.

Example

A finance team extracts invoices from the ERP and orders from Shopify every night, loads them into a warehouse, and joins them to build a revenue dashboard.

In integrations

ETL tools move data into your warehouse for your own analysis. Unify Int solves a different problem: customer-facing integrations inside your product, with auth for each of your customers, write-back and webhooks. The two can coexist, and normalized data from the Unify Graph is easier to load downstream. If your goal is internal reporting, ETL is the right tool. If your goal is a feature your customers switch on in your product, you need customer-facing integrations instead.

Related terms

Related products and solutions

Get started

Connect once. Build everything else on top.

Request sandbox access, or book 30 minutes with an engineer to map your integrations.

Free sandbox access. No credit card. Reply within one business day.