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

Linux – DEB

i.e. Ubuntu, Debian, etc.

sudo apt-get install gcc g++ zlib1g-dev libxml2 libsnappy-dev libicu-dev \
  gettext-base binutils coreutils bsdmainutils procps \
  info man-db sqlite bash-completion |
  dos2unix libncurses-dev libncurses5-dev

Then install EVL package itself. Package name might have different name, it depends on the edition. For example for Debian it would be:

sudo apt-get install evl-utils_2.8.0-1_all.deb
sudo apt-get install evl-tool_2.8.0-1_amd64.deb

EVL – ETL Tool

Table of Contents

Linux – DEB