Databases Update Data in MySQL Database Using Sequelize and Nodejs By admin Sequelize is an ORM tool which is used to save data from node application to the databases like MySQL, Postgres and many others and a Model is basically a table in the database. Make data easy with Helical Insight. Helical...
Pentaho Export Mondrian Schema to Excel using PDI By Mounika This blog explains how to create a job in PDI which can export Mondrian schema which is in XML format to excel. Consider below a sample of Mondrian Schema: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <Schema name="TransactionType"> <Dimension highCardinality="false" name="Dim Customers" type="StandardDimension"...
Data Visualization Binary Gaps with Python By admin Recently I saw a question on-line to find the Binary Gaps in a Binary Number. What is a Binary Gap? A binary gap within a positive integer N is any maximal sequence of consecutive zeros that is surrounded by ones...
Jaspersoft High-Chart Label Formatting By Ramu Vudugula High-chart label Formatting Prerequisites: Jasper Server 6.4.2 Database: Foodmart In this blog,we trying to formatting the x.axis label in StackedColumnSpline chart. In chart,it shows store_type-Wise, Store-wise Store_Sales, Store_Cost and Unit_Sales with following dataset query. “select s.store_type, s.store_name,sum(store_sales) as sales,sum(Store_cost) as...
AWS Email Notification for AWS Glue Job Execution By admin AWS glue provides various services for sending email notifications based on events in job execution. This blog discusses sending an email notification of an ETL job in AWS glue based on the state change of AWS Glue job. This approach...
Jaspersoft Usage of Virtualizers in JasperServer/Studio By Satya Gopi Before going to the virtualizers we need to know how a Report is generated in Jasper: Generally the reports are created using Jasper Studio or Adhoc Reports which creates a jrxml file, once it complies we will going to get...
Pentaho Data security for Interactive Report in Pentaho By Mounika This blog covers the process of applying data security for interactive reports in Pentaho based on logged in user. Pentaho Interactive Reporting is a drag-and-drop, browser-based design environment for interactive reports that allows you to quickly add elements to your...
AWS Passing and Accessing Parameters in AWS Glue Job By admin Glue job accepts input values at runtime as parameters to be passed into the job. Parameters can be reliably passed into ETL script using AWS Glue's getResolvedOptionsfunction. The following is an example which shows how a glue job accepts parameters...
Jaspersoft Changing Default Save Folder for Adhoc Views in Jasper By Satya Gopi Prerequisites: Jasper 6.4.0 Enterprise Database: Foodmart Here we can see how we can change the Default Save Folder path for ad-hoc views. If we need to choose a dynamic path, like logged user folder name as the default location, for...
Databases Saving Image to MYSQL and displaying it using Nodejs and Sequelizejs By admin In this blog, we will go through the process for storing the image data to the database rather than storing image URL to the database using Node application and Sequelizejs Make data easy with Helical Insight. Helical Insight is world's...
ETL Basic ETL with Spark (pySpark) By admin Moving from our Traditional ETL tools like Pentaho or Talend which I’m using too, I came across Spark(pySpark). Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail...
Pentaho Data Source Creation for Interactive Report in Pentaho By Mounika This blog covers the process of creating a data source for interactive reports in Pentaho. Pentaho Interactive Reporting is a drag-and-drop, browser-based design environment for interactive reports that allows you to quickly add elements to your report and format them...