EVL – ETL Tool

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

Copyright © 2017–2023 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.

Table of Contents

Version 2.0



New features
  • EVL Job Manager renamed to EVL Workflow
  • Man pages
  • Standalone components (i.e. components can be used from command-line)
  • Handy mapping functions applied for group of columns – ‘in_to_out()
  • PostgreSQL connectivity
  • String manipulation functions added:
    length’, ‘starts_with’, ‘ends_with’, ‘substr’,
    hex_to_str’, ‘str_to_hex’,
    str_compress’, ‘str_uncompress
    str_index’, ‘str_rindex
  • Shared lookup tables – one lookup can be used in several mappings
  • Sort within a group – sort already grouped data
  • Read/Write Parquet files
  • Incremental unique Run ID
New utilities
  • evl_increment_run_id
New components
  • Echo
  • Lookup
  • Readparq
  • ReadPG
  • RunPG
  • Sortgroup
  • Writeparq
  • WritePG
New commands
  • Fr’ – to handle File Registration
  • Ls
  • Rm
  • Spark’ – to run Spark jobs