In this document we are covering how you can connect to Mongo and another RDBMS (like mysql, oracle, sqlserver etc) and do a crossdb join and create reports. Pre-requisite : – Helical Insight (version 5.0) installed – Apache Drill (version 1.20) installed Useful links : https://www.helicalinsight.com/connecting-mongodb-using-apache-drill/ https://www.helicalinsight.com/drill-installation-helical-insight/ NOTE : Above documents might be using different
Read More
Helical Insight application mainly hosted on Apache tomcat application server. There are multiple ways using which we can enable SSL on apache tomcat for ex. HTTPS proxy redirection, AJP redirection, IIS, NGINX, HAProxy, configuring SSL details at apache tomcat level etc. The SSL certificate can be applied at any of the webserver or directly at
Read More
In this blog we are going to cover how to improve the performance of your Helical Insight instance. When all of these steps are followed it will improve the performance a lot. a. Cache preparation and speeding up the cache preparation:As soon as a user creates the database connection on our datasource page our application
Read More
By default Open Source BI product Helical Insight gets installed on Apache Tomcat. In this blog, we will learn how to migrate this from Apache Tomcat to Apache web server. For Apache Web server default HTTP Port is: 80 and default HTTPS port is: 443. Similarly for Apache Tomcat default HTTP port is 8080 and
Read More
In this document, we have explained how we can do load balancing in Helical Insight application using Tomcat. The cluster consists of a set of connected Tomcat Servers that work together so that, in many respects, they can be viewed as a single system. Each node sets to perform the same task, controlled and scheduled
Read More
This blog gives details of the installation of Apache Drill in embedded mode, i.e., to use Drill on a single node. If you wish to install Drill in distributed mode, follow the instructions here. Pre-requisites: We have tested with Apache Drill 1.14 Linux, Mac OS X, and Windows: Oracle or OpenJDK 8 Windows only: A
Read More
Introduction: Using this blog you will able to enable the Secure Socket Layer(SSL) in the apache-tomcat web server to access the application using HTTPS. This blog is applicable when you are using self-sign certificate and Helical Insight is being used in a stand alone mode not embedded within a third party application. Prerequisite: 1. Java
Read More