It is possible to use MongoDB with Open Source BI product Helical Insight. There are two methods via which we can use Mongo inside Helical Insight. Method 1 : Via Dremio Method 2: Via Drill. Read on to learn how to connect via Apache Drill. Users can connect to MongoDB in Helical Insight via Apache
Users can now directly upload flat files like CSV, JSON, Parquet, TSV, Avro and Sequence Files to Helical Insight. Following steps need to be followed. Step 1: Download, install and start Apache Drill. To learn how to install Drill. Step 2: Configure the middleware to support flat files. Step 3: Go to Data Sources page.