Choosing ETL / ELT Solution

ETL

• Extract

• Transform

• Load

ETL plays a vital part in moving data across.

Many ways ETL can be implemented.

Popular ones

GUI Tools such as SSIS, Pentaho, Talent

Scripting Tools such as Bash, Python

ELT

• Extract

• Load

• Transform

In big data platforms such as Hadoop, and Spark, you can load a JSON, or CSV file and start using them as is. This technology can even parse compressed .gz / .bz2 files

Extensively used when dealing with Semi-Structured databases.

(Register with Databricks community edition)

https://community.cloud.databricks.com/login.html