Blog

What is ETL?

Where does ETL stand for?
Extract, transform and load

What is ETL?

ETL is a three-phase data integration process that Extracts, Transforms, and Loads data from multiple sources to a consistent data store that is loaded into a data warehouse or other unified data repository.

ETL processing is typically executed using software applications but it can also be done manually by system operators.

How is ETL used?

ETL was introduced in the 1970’s as databases grew in popularity. Over time it became the primary method to process data for data warehousing projects. Through a series of business rules, ETL cleanses and organises data to address specific business intelligence needs. It transforms transactional data to be used in business intelligence software and analytics tools.

Today Modern ETL or ELT is often used within the cloud computing environment. There are different open source products available.

Nowadays ‘classic’ ETL is still used for:

ELT or modern ETL is used for:

ETL or ELT?

With the rise of cloud computing the demand for this data integration process shifted from ETL to Extract, Load, Transform. After extracting the data it is loaded as-is into the cloud data warehouse. The data is then transformed using the power and scalability of the target cloud platform.
If you are on premise and the amount of data sources is limited, ETL solutions still work fine. However we expect ELT to be the future.

ETL and Dovetail

Dovetail is an iPaaS. It handles data flow, and it therefore has a lot more functionalities then just ETL or ELT. Dovetail combines application and data integration in one tool, and routing and transforming data can be handled as part of those data integrations.
Do you want to know more about the capabilities of Dovetail?
Or click here if you would like to read more about what iPaaS is.

Related resources

Automated processing of all sales order related flows

As a sales organisation, you aim for a streamli...

Challenges with entering data in multiple systems

What challenges or pain points do you face? And...

The impact of human error rates in manual data entry across multiple systems

How does human error in data entry effect your ...

Types of integration

There are many different types of integration; ...