Open Source Business Intelligence Blog

BEST PRACTICES WHILE USING HELICAL INSIGHT:

In this blog we are covering the best practices which should be followed while using Helical Insight to create your reports, dashboards, embedding, Single Sign On, optimal performance, higher security etc. DATASOURCES: a) Dynamic DB Switching : – There are certain cases when we would like the report or dashboard to all together switch to

adhoc, adhoc datasource, adhoc report module, adhoc reports, database, datasoruce, exporting report, mongodb datasource, Table Shadow

Share with

Excel Usage with Helical Insight

In this blog we would be discussing and explaining how can connect to Excel as a datasource using Open Source BI product Helical Insight via Apache Drill. You can refer to our other blog to learn how apache drill can be used to connect to other kind of flat files like CSV TSV Parquet JSON

adhoc datasource, apache drill, datasoruce, export excel, filter expressions

Share with

NoSQL SPECIFIC FUNCTIONS

In this specific blog we would be covering db specific functions which are specific to NoSQL databases like Mongo etc present in the version of Helical Insight 4.1. Some of these functions like handling of JSON are now also are present for newer versions of databases like Postgress, MySQL etc JSON Specific function 1) You

Big Data, database, database driver, NoSQL, SQL

Share with

Setting up JWT in Helical Insight

With version 4.1 GA of Helical Insight we are also supporting JWT as well. JWT offers a lot of advantages like enhanced security, sessionless mode support when implementing load balancing server at Helical Insight, another method of SSO implementation and more. In a stateful architecture, when the load or session is shifted to another server,

helical insight, jwt, setting up JWT

Share with

Use Helical Insight as an alternative to out-of-cycle Oracle Reports

May’2021: If you are still using Oracle Reports, you will soon need to find an alternative for your reporting needs as the current oracle reports are reaching end of life cycle. Open Source BI product Helical Insight is an excellent tool that can replace Oracle Reports and offer you much more. For starters, Helical Insight

adhoc, adhoc report module, adhoc reports