EVL

Table of Contents


Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2020 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Introduction

EVL originally stood for Extract–Validate–Load, but it’s now a fully featured ETL (Extract–Transform–Load) tool.

EVL is designed with the Unix philosophies of interoperability and “do one thing, and do it well” in mind.

Templates, a high level of abstraction, and the ability to dynamically create jobs, make for a powerful ETL tool.

Characteristics:

  • Versatile, i.e. cooperate with other components of the customer’s solution, solving only particular problem.
  • High performance, written in C++.
  • Lightweight, just install a rpm/deb package or unzip tgz.
  • No Drag’n’drop, but still graphical (EVL Manager), highly efficient development.
  • Managed access to the source code (e.g. git).
  • Linux only, using the best of the system.

Features:

  • Natively read/write1:
    • File formats: CSV, JSON, XML, XLS, XLSX, Parquet, Avro, QVD/QVX, ASN.1
    • DBMS: MariaDB/MySQL, Oracle, PostgreSQL, SQLite, ODBC, (near future: Snowflake, Redshift)
    • Cloud storages: Amazon S3 and Google Storage
  • Hadoop: read/write HDFS, resolve, build and run Spark jobs, Impala/Hive queries
  • Partitioning, to partition data and/or parallelize processing
  • Productivity boosters, to generate jobs/workflows from metadata

For the most recent information about EVL and supported formats and DBs please check https://www.evltool.com.


Footnotes

(1)

Actually any source/target can be used, once available from Linux.