ETL工具...它们的作用是什么？请外行 [英] ETL tools... what do they do exactly? In laymans terms please

问题描述

我最近接触过一些ETL工具，例如Talend和Apatar，而我想知道这些工具的目的/主要目标是非专业人士。谁主要使用它们，并且，如果您使用它们，从我的角度看，它们的性能比仅仅编写某种类型的脚本还要好。

I have recently been exposed to some ETL tools such as Talend and Apatar and I was wondering what exactly the purpose/main goal of these tools is in laymans terms. Who primarily uses them and if you use them, how they are (from my understanding) better than just writing some type of scripts.

推荐答案

ETL代表提取/转换/加载。这些工具从一个来源获取数据，然后将其转移到另一个来源。您可以采用独特的方式将模式从源映射到目标，在数据移入目标之前对其进行转换和清除，并以高效的方式加载目标。您可以将ETL作业安排为批处理过程。

ETL stands for "Extract/Transform/Load". These tools take data from one source and move it into another. You can map schemas from the source to the destination in unique ways, transform and cleanse data before it moves into the destination, and load the destination in an efficient manner. You can schedule ETL jobs as batch processes.

这些数据源可以是关系数据库，电子表格，XML文件等。

Those data sources can be relational databases, spreadsheets, XML files, etc.

谁使用它们？取决于您所说的用途。它们只是代码，在大多数情况下，它们是作为常规操作的一部分安排的。没有最终用户功能。它们完全是供程序员创建和操作的。

Who "uses" them? Depends on what you mean by "uses". They're just code and most of the time, they're scheduled as part of regular operations. There are no end-user features. They're totally for programmers to create and operations to operate.

脚本的优势？没有。它们是用特定领域语言（DSL）编写的脚本，完全专注于从源中提取，转换和加载到目标。脚本中最有趣的部分是每个阶段的逐字段映射。

Advantage over scripts? None. They are scripts written in a domain-specific language (DSL) focused entirely on "extract" from source, "transform" and "load" to destination. Most of the interesting part of the script is the field-by-field mappings at each stage.

这篇关于ETL工具...它们的作用是什么？请外行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！