Skip to main content

Ask An SA: ETL vs ELT, The Business Case for CDC [Video]

Like most technology sectors, the data integration and data management spaces are an alphabet soup full of acronyms. Our Solution Architect team – the amazing members of Team Green that help our customers find success with Matillion products – are constantly being asked: “Which of these acronyms should we pay attention to, and why? These are a few of their answers to the most common questions.


“Why choose ELT over ETL?”


If you are considering  Matillion, you have a modern data platform built in the cloud. So you already know how quickly cloud data warehouses help companies achieve faster time to value, and that cloud-native solutions like Matillion ETL use the economics and power of the cloud to handle big and varied data volumes. They do this by using an ELT (extract, load, transform) approach. 


On legacy technologies, the ETL (extract, transform, load) approach is used to perform data transformations before you load your data into a target data warehouse. But the modern ELT approach allows you to move data directly into your cloud data warehouse and then perform the necessary transformation: faster, and more cost-effectively. When enterprises employ a modern data environment and cloud-native tools, it is easier to proactively use data to find insights – and save big on provisioning costs.


Read: The pros and cons of ELT and ETL.

“Change Data Capture (CDC):  Why should I care?”


For up-to-date, near-real-time data, it’s important to keep up with changes to that data equally quickly. CDC is a set of software design patterns used to determine (and track) data that has changed, so that action can be taken using the changed data, no matter how quickly you are moving.


When you implement CDC, you can keep your cloud data warehouse and your source database in sync, reducing the need for more complex transformations. Matillion offers CDC functionality for AWS-hosted instances. CDC works directly with several AWS products: DMS, Lambda, SQS, and S3.  Follow this blog walkthrough to learn how to get started


Additionally, our partnership with HVR enables enterprises to get analytics-ready insights with real-time data replication and transformation. 

Find out what 2021 trends – and acronyms – you should know


This year will see more data trends across integration, management, and transformation as enterprises work to figure out how to put all of their data to work. 


Tune in to our upcoming webinar on 2021 data trends to learn about emerging trends and technologies that you should keep an eye on this year. 


  • Will 2021 be the year that Data Fabrics prove positive ROI? 
  • How will data integration technology support AI and ML? 
  • Are the Data Lake’s best days still to come?


Register for our webinar “Top Data Integration Trends For 2021” here

The post Ask An SA: ETL vs ELT, The Business Case for CDC [Video] appeared first on Matillion.