FOREIGN DATA WRAPPER IN POSTGRE SQL     FDWs allow remote access to tables or queries from various external third-party databases or file structures. It allow access from application to data that is in different database format,in a non relational database,not in db at all.   EXAMPLE:   Create a database for all tables CREATEDB …Read More

Memory Group By Vs Group By in Pentaho DI

Memory Group By Vs Group By in Pentaho DI Group By and Memory Group By: These steps are useful to calculate aggregate values for the group of fields. Even though both are useful for same purpose there are some differences and similarities as follows: 1) Group By works  only when the input rows are in …Read More

JSTL sql taglib

The <sql:> tag lib in JSTL The sql tag lib helps to develop a simple jsp database application. This taglib comes in handy with dataSoursetDataSource,  query, transaction and update tags The tag lib can be used by putting the following in the jsp page. <%@ taglib uri=”” prefix=”sql”%> The following syntax makes clear how to …Read More

HTML/CSS Coding Practices

HTML/CSS Coding Practices A lot of coding best practices emphasize keeping code lean and well organized. The general practices within HTML are no different. The goal is to write well-structured and standards-compliant markup. The guidelines described here provide a brief introduction to HTML coding practices; this is by no means an exhaustive list. Write Standards-Compliant …Read More

Document Fragments

The one of the most underrated feature of JavaScript is DocumentFragment. DocumentFragment is a DOM Node-like parent which has node-like properties/methods and is not a part of the actual DOM tree. It can be used for better performance. A DocumentFragment can be created using document.createDocumentFragment method. Example Usage Let us assume that we have to create a long …Read More

The Print When Expression

The Print When Expression The print when expression in Jasper Studio or Jasper iReport is very useful in so many requirements and it is defined as the name itself implies i.e Print /Show a String, Column and so on Based on a condition passed. Now here are some requirements on how/when we can implement The …Read More

Mroonga(Columnar Engine)

Mroonga(Columnar Engine) Database Engine is basically the software which is used for creating, Reading, Updating data in to the database management system(DBMS). Following are few database engines. Engine Name Detail InnoDB InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. MyISAM MyISAM was the default storage engine for the …Read More

PDI Variable / Parameter Behaviour

This article is specifically for those who are new to using PDI and are facing difficulty in understanding how the variables behave when being passed from one job / transformation to another job / transformation. PDI provides set variable component and get variable component to set and get variables in different jobs. The First thing …Read More

How to remove some items in Home page & some Filters options under view list menu in Jasper Server-pro-6.2 with Role based security.

Changes for the Home page Overview: To Make the following changes to the Jaspersoft Home page. Implementation: The feature should be implemented as follows: Remove the “Data Sources” item and its “View Tutorial” and “View List” links Remove the “Domains” item and its “View Tutorial” and View List” links Move the “Reports” item to the …Read More