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
- 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: