EVL – ETL Tool

Read Components

There is a generic ‘Read’ component (see Read), which read source file(s) and parse them based on file suffix from location based on URI Scheme. It can also read a table based on URI.

But for example in the case you need to read and parse particular file format from an input flow, there are also specialized components which parse such format:

Reading various file formats

• Readevd – parse EVD,
• Readjson – parse JSON,
• Readparquet – read Parquet, a columnar file format,
• Readqvd – read QVD, Qlik’s file format,
• Readxls – parse old-style MS Excel,
• Readxlsx – read MS Excel,
• Readxml – parse XML.

And in the case you need to use some DBMS specific options to read a table, there are also DB specific read components:

Reading tables and streams

• Readkafka – read Kafka topic,
• Readmysql – read MySQL/MariaDB table,
• Readora – read Oracle table,
• Readpg – read PostgreSQL table,
• Readtd – read Teradata table.