In this article, we will compose a simple ETL pipeline using Apache Nifi. We want to read Excel File and convert it to a csv file using Apache NiFi ConvertExcelToCSV Processor.
Prerequisites
- install Apache Nifi (we used $ brew install nifi)
- basic knowledge of ETL concept and data integration tool
Data Pipeline
Apache Nifi is web based data integration tool. Make sure your processors are inside a Processor group. In order to create a simple ETL pipeline using Apache Nifi, we will use only two Processors and Funnel :
- getFile
- ConvertExcelToCSVProcessor