Pentaho HOW TO COMPARE FILES & FOLDERS IN PENTAHO By admin Introduction: Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. We will use the “File Compare”job entry to compare the contents of two files and control the flow of the job. When...
Pentaho How to Get Data from XML in Pentaho By admin Introduction: "Get Data From XML" can read data from 3 kind of sources (files, stream and url) in 2 modes (user can define files and urls at static mode or in a dynamic way). Options Available: Files Tab Content Tab...
Pentaho How to Get Multiple Files and Merge in Pentaho By admin Introduction:The Get File Names step allows you to get information associated with file names on the file system. The retrieved file names are added as rows onto the stream. Make data easy with Helical Insight. Helical Insight is world's best...
Pentaho How to Delete Files in Pentaho By admin Introduction: When working on ETL flows, its sometimes useful to store information in temporary files as long as you clean those files up when you are finished. Pentaho Data Integration (aka Kettle or PDI) has two steps for deleting file(s)...
Pentaho Working with REST Client and JSON In Pentaho By Sohail Today we will be looking into REST API Component In Pentaho. So data can be from many source, one source of data can be the internet. As PENTAHO is a ETL tool, it provides us with components to help fetch...
Pentaho Cascading Filters in CDE Dashboard By admin This blog explains the process of cascading filters in CDE dashboard. Prerequisites: Foodmart database Pentaho 6.0.1.0.386 Consider the below dashboard with 2 filters i.e. Country and State.The requirement is that when we select a value in country drop down, State...
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...
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...
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...
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"...