Helical Insight supports various relational, columnar, NoSQL databases as well as flat files. This blog shows how to connect to MS Access in Helical Insight. Step 1:Go to the Datasources page and click on MS Access. You will be prompted to download the relevant database driver. Download the driver from the link on our blog
Read More
Login with credentials and click on the file browser. Then we get folders and files list, select the required report using search bar option. Now, we need to right click(or double click ) on our report. We can see options like Open, Open in New Window, Delete, Rename, Share & Properties. Click “Open” to open
Read More
Approach Helical Insight(BI) -> Fire SQL Query -> Map Cassandra with hive (one-time activity) -> Fetch data from Cassandra Just in Time This approach involves creation of mapping tables in Hive meta-store of SPARK which have one-to-one mapping to Cassandra DB tables. Helical Insight can connect to this Hive meta-store using SPARK’s Thrift Server which
Read More
In this blog, we have discussed the steps involved in connecting Helical Insight to Apache Druid. In order to start creating analytics with Apache Druid, follow the below given steps: 1. Download this folder Druid_Configure Files.zip and unzip it. 2. The file named “avatica-1.17.0.jar” is the JDBC driver for Apache Druid. Upload the JDBC Driver
Read More
In this post (Accessing Reports / Dashboards Created Using Helical Insight Publicly), we were passing authentication details (username and password) in the URL along with directory and file name. In this post, we hide those authentication details and just pass directory and file name to the URL. We will write a simple JavaScript code that
Read More
There might be certain cases in which people might be interested in embedding report / dashboard built using Helical Insight solution on their website which can then be used by anybody, without the need to login i.e. it should be accessible publicly. In this article we will cover how to access report/dashboard created using Helical
Read More
We Can Use Neo4j Graph Database with EFW reports: Note: This blog is applicable for HI Version Helical Insight v1.0.0 Follow these steps to use Neo4j Graph database with helical insight: Step 1: First we have to Download Neo4j JDBC driver to Neo4j graph database with HI You can download Neo4j driver from here Step
Read More
NOTE: This blog is relevant to version 3.0, 3.1, 4.0 and 4.1 of Helical Insight and will not work for any other version. You can know the version from the bottom left (above file browser) or from the admin page. This article briefs you about how you can completely white label and change the look
Read More
A marker identifies a location on geographical maps. HI map Customization allows user to define multiple markers within or outside the highlighted region.
Read More
This customization allows user to define polygon on a geographical map. Click here for Fullview. Know more about how to generate a default geographical Maps
Read More