Pentaho Failed to Establish the VPN Connection By admin Warning - Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version I recently faced this issue while trying to connect to the VPN on version 6.2.0.0780 on Windows 8 Here are the...
Jaspersoft Displaying Full Label Name using Jfree Chart in Jasper Studio By Satya Gopi Perquisites : JasperStudio ,Eclipse We came across one issue, when we created a Stacked Bar Chart using JFree chart the label names are not visible totally as below Screenshot. Query results: Stacked Bar Chart: By using class customizer we can...
Pentaho Create Custom Template in Pentaho Dashboard By admin This blog explains the process of creating a custom template in Pentaho Dashboard. Pentaho provides few templates in Pentaho dashboard by default. When we want to create a dashboard with template which is different from the existing, we need to...
AWS Triggers in AWS Glue By Sai Kavya Sathineni To find AWS Glue Triggers, follow the below steps: Login to AWS Console Search for AWS Glue service Click on AWS Glue service Under ETL, click on Triggers AWS Glue has 3 types of triggers Schedule Job events On-demand Schedule...
Open Source Business Intelligence Passing Parameter to a Stored Procedure Activity in Azure Data Factory By Ramu Vudugula Requirement: I have a SQL procedure which has the input parameters. How can I pass the parameters to that SQL procedure in a data pipeline in Azure Data Factory Make data easy with Helical Insight. Helical Insight is world's best...
Pentaho Transpose Rows to Columns using Pentaho Data Integration By Sohail Sample Data In the data given below, it is expected to pivot column Week from rows to columns. Following data is the number of vehicles sold by particular user in a week for two different user accounts. Make data easy...
Pentaho How to Add Filters in CDE Dashboard By Mounika This blog explains the process of adding filters to the dashboard and create a connection with parameters of the components in the dashboard. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool....
Pentaho Create CDE Dashboard with CCC Charts in Pentaho By Mounika This blog explains the process of creating a CDE dashboard in pentaho using CCC charts component. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Prerequisites: Foodmart database Pentaho 6.0.1.0.386 Below is...
Business Intelligence Performance Improvements in Apache Drill By Satya Gopi Prerequisites: ApacheDrill We are firing a query in Apache drill it is easily taking 3 minutes for fetching just 1 column from a Table,so to overcome we have used to 2 Performance Improvements Partition Pruning Parquet meta data caching Partition...
Jaspersoft Splitting a Detail Band into 2 Columns or More in Jasper By Satya Gopi Prerequisites: JasperServer 6.4.2,Jasper Studio Databases: Foodmart Recently we have come across one requirement like one table has 2 columns and in the report itself we have lots of empty space, to eliminate that empty space we have printed the table's...
AWS Fetching AWS Glue Connection Details By Sai Kavya Sathineni There might be requirements where you have to fetch the details from the connection defined in AWS Glue Data Catalog and use them in your Glue job for connecting to the database (to store logs into database). Make data easy...
Jaspersoft How to Connect to KDB database in Jaspersoft By Mounika To Connect to KDB database in Jaspersoft follow the below steps: Open Jasper studio and create a data adapter. KDB requires a separate jar file called ‘jdbc.jar’.Below is the jar file. JDBC.jar file Include this jar file in Driver Classpath....