Simple ETL pipeline using Apache Nifi

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

Apache Nifi Flow