Business Intelligence Passing Parameters in Pentaho Data Integration Part 1 By Nikhilesh Passing Parameters From Parent Job to Sub-Job/Transformation in Pentaho Data Integration (Kettle) - Part 1 Part -1 : Using setter and getter methods : 1.Set variables in parent job/transformation. 2.Get variables in sub-job/transformation. Make data easy with Helical Insight. Helical...
Business Intelligence Passing parameters in Pentaho Data Integration Part 2 By Nikhilesh Passing Parameters From Parent Job to Sub Job/Transformation in Pentaho Data Integration (Kettle) -Part 2 In part 1, I have mentioned about passing parameter values down to sub-job/transformation using setter/getter methods. Please refer my previous post for part 1 Passing...
Business Intelligence Creating a Project in SpagoBI Studio By Nikhilesh Creating a project in SpagoBI Studio SpagoBI Studio is an eclipse based BIRT reporting software and creating a project in SpagoBI studio is very much easy and recommended too as all our reports / documents will be organized in better...
Business Intelligence Creating a Folder in SpagoBI Server By Nikhilesh Creating a folder under Functionalities Tree in SpagoBI Server In general Spago BI uses its own functionalities tree which allows to better organize documents / reports by grouping them in folders. Although in built Folders are provided to organize (Analytical...
Business Intelligence How to Replace Various Characters Using Jasper Studio By Sohail How to Replace Various Unwanted Characters during Reporting Using Jasper Studio Reporting in Business Intelligence is the representation of Data in a more meaningful manner so at times we need to follow some few formats to make our data to...
Business Intelligence Logout Page Customization in Jaspersoft By admin Logout Page Customization in Jaspersoft : When we click on Log out link in jaspersoft or when the session expires , it is always redirected to Jaspersoft Login...
Business Intelligence Command Line Execution and Redirection Process in Pentaho (Kettle) By Nikhilesh Command line execution in Pentaho (Kettle) : Pentaho provides two command line utility tools to execute your job/transformation from outside of spoon. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab...
Business Intelligence EDI – Electronic Data Interchange Introduction By admin Introduction Standardisation is needed in every field to create uniformity. Same is the case with data exchange, Without a standard format, each company would send documents using its company-specific format and, much as an English-speaking person probably doesn’t understand Japanese,...
Business Intelligence Switch Data Source Based on user logged in Jasper Server By Nikhilesh Switch Datasource based on user logged in Jasper Server This tutorial shows you how to switch two different jdbc datasource using custom datasource in jasper server. Cosider you have two jdbc datasource in jasper server and you want to select...
Business Intelligence Implementing Loops in Pentaho Data Integration By Nikhilesh Issues while implementing loops in Pentaho Data Integration Generally for implementing batch processing we use the looping concept provided by Pentaho in their ETL jobs. The loops in PDI are supported only on jobs(kjb) and it is not supported in...
Business Intelligence Using Parameters in iReport By admin USING PARAMETERS IN iREPORT Most basic knowledge any new learner would have of word parameter -“ parameter is a limit or boundary which defines the scope of a particular process or activity ”. And technically we can define it...
Business Intelligence Batch Process Implementation in Kettle By Nikhilesh Batch Process Implementation in Kettle (Pentaho Data Integration) In order to implement the batch process we needs to have the looping logic. But I did not find any component or suitable method in kettle to create those loops. Make data...