EVL – ETL Tool

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

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
Release Notes
- Version 1.0
- Version 1.1
- Version 1.2
- Version 1.3
- Version 2.0
- Version 2.1
- Version 2.2
- Version 2.3
- Version 2.4
- Version 2.5
- Version 2.6
- Version 2.7
- Version 2.8
Installation and Settings
- Linux – RPM
- Linux – DEB
- Other Unix systems
- Settings
  - Compiler
  - Project
- Text Editor
  - Vim
EVL Overview
- ETL in general
- EVL approach
- Terminology
- EVL Jobs
- EVL Workflows
- Scheduling
Main EVL Command
- Usage
- Examples
- Options
- Environment
- evl project
- evl run
- evl workflow
EVD and Data Types
- EVD Structure
  - Comments
  - Inline EVD
- EVD Options
- Default Values
- Compound Types
- String
- Integral Types
- Decimal
  - Declaration in mapping
  - Manipulation, comparison
- Float and Double
- Date and Time
Components Common
- Common Options
Basic Components
- Assign
- Cat
- Cmd
- Component
- Cut
- Departition
- Echo
- Filter
- Gather
- Generate
- Head
- Lookup
- Merge
- Partition
- Sort
- Sortgroup
- Tail
- Tee
- Trash
- Uniq
- Validate
- Watcher
Mapping Components
- Aggreg
- Join
- Map
Read Components
- Read
- Readevd
- Readjson
- Readkafka
- Readmysql
- Readora
- Readparquet
- Readpg
- Readqvd
- Readsqlite
- Readtd
- Readxls
- Readxlsx
- Readxml
Run SQL Components
- Runmysql
- Runora
- Runpg
- Runsqlite
Write Components
- Write
- Writeevd
- Writejson
- Writekafka
- Writemysql
- Writeora
- Writeparquet
- Writepg
- Writeqvd
- Writeqvx
- Writesqlite
- Writetd
- Writexlsx
- Writexml
Commands
- Cancel
- Cp
- Chmod
- Crontab
- End
- Fr
- Log
- Ls
- Mail
- Manager
- Mkdir
- Mv
- Rm
- Rmdir
- Run
- Set
- Skip
- Sleep
- Spark
- Status
- Test
- Touch
- Wait
EVM Mappings
- Output Functions
- String Functions
- Checksum Functions
- IP Addresses Functions
  - IPv4 Functions
  - IPv6 Functions
- Randomization Functions
- Anonymization Functions
- Logical Functions
- Encryption Functions
- Mathematical Functions
- Other Functions
  - first_not_null
Joins and Lookups
- Lookup tables
  - Declaration and load
  - Methods
Utils
- csv2evd
- csv2qvd
- evd2sql
- guess-timestamp-format
- json2evd
- pg2evd
- qvd2csv
- qvd2evd
- evl_increment_run_id
- qvd-header
EVM Functions Index
EVD Data Types Index
Variables Index
General Index

Version 2.8

Released

2023/04

New mapping functions

‘fail()’, ‘is_equal()’, ‘log()’, ‘warn()’
Math functions: ‘abs()’, ‘ceil()’, ‘floor()’, ‘max()’, ‘min()’, ‘pow()’, ‘round()’, ‘sqrt()’, ‘trunc()’

New component

‘Wc’ – Count records and bytes

New data types

‘interval’
‘time’

EVL – ETL Tool

Table of Contents

Version 2.8