Extract-Transform-Load (ETL) 3rd-Party Platform

An Extract-Transform-Load (ETL) 3rd-Party Platform is a data integration platform that can be used to build ETL systems.

• Context:
  • It can range from being a ETL Platform Package to being a Cloud-based ETL Platform.
  • It can (typically) provide ETL Platform Capabilities, such as data transformation operations and data connectors.
  • …
• Example(s):
  • Informatica ETL Platform, Talend ETL Platform, Etleap ETL Platform, Ab Initio Platform, Matillion ETL Platform, ...;
  • an ETL Service, such as: AWS Glue ETL Platform.
  • dbt Platform.
  • …
• Counter-Example(s):
  • a DBMS Platform.
  • an ML Platform.
• See: ETL Development Model, ELT Pipeline, Data Stream Processing Platform.

---

---

References

2019

• https://blog.panoply.io/17-great-etl-tools-and-the-case-for-saying-no-to-etl
  • QUOTE: ... ETL has been a bedrock process of data analytics and data warehousing since the beginning, but the increased pace of data usage and the nosediving price of storage mean that it’s often necessary these days to get data in front of analysts as quickly as possible. Because the Transform step in an ETL pipeline can often be a chokepoint in the data pipeline, that means that some more modern data warehousing companies are switching to an ELT-based approach, where the transformation step is pushed to the end of the process, or even delayed until the point of query by analysts. ....

---