Data write-back / editable table support in Helical Insight Enterprise 6.1 GA

Technical queries
#1

Hello Helical Team,

We are using Helical Insight Enterprise Edition 6.1 GA.

I would like to know whether Helical Insight supports data write-back to the database. For example, after displaying data in a tabular report or dashboard, can users edit certain fields or add new records and save those changes back to the database?

I found this older forum post about updating DB rows using Report CE, custom data table plugin, AJAX, and HWF:

However, that approach seems to require quite a lot of custom work. Since we are using Enterprise Edition 6.1 GA, is there any easier or more recommended way to implement this? For example, is there any built-in write-back/editable table/data entry feature in Enterprise Edition 6.1, or do we still need to implement it using custom JavaScript + HWF/custom API?

Our expected use case is:

  1. Display data in a table report/dashboard.
  2. Allow users to edit selected columns or add new rows.
  3. Save the changes back to the database with proper validation and permissions.

Could you please suggest the best/recommended approach for Helical Insight 6.1 Enterprise Edition?

Thank you.

#2

Hi,

Generally BI tools are meant for read operations i.e. firing Select kind of queries, getting the response and showing on the frontend. Our product has also been designed keeping that kind of requirement in mind, which is why CUD (Create, Update, Delete) kind of operations are difficult to achieve.

However, if you still are having such kind of write back requirement then the solution is creating a custom workflow. Custom workflow can be created in the enterprise version as well. For now it can be written using any IDE, saved in a folder and invoked.

We are sharing one workflow example file ExportToCSV_v1.zip (1.6 KB).

If you still need some help in understanding / creating / write back HWF (Helical Work Flow) file creation you can email us on support@helicalinsight.com