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...
ETL Change Data Capture(CDC) Capture Changes Made at Data Source By Sai Kavya Sathineni Change Data Capture(CDC) Change data capture (CDC) is the process of capturing changes made at the data source and applying them throughout the enterprise. CDC minimizes the resources required for ETL ( extract, transform, load ) processes because it only...
Jaspersoft Adding New Custom Fonts in Jaspersoft Studio and Jasper Server By Ramu Vudugula To display the report using the custom fonts I.e new fonts which do not exist in the Jasper we have to use “font extensions” process. Using this we can add any kind of font in the report. Here I am...
Jaspersoft Create Alphabet Row Numbering in Table Component of Jasper Report By admin Prerequisites: Jasper Server 6.4.0 Database: Foodmart In this blog, we learn to display a simple numbering to row in table component using an alphabet instead of numbers. Make data easy with Helical Insight. Helical Insight is the world's best open...