Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Sunday 30 August 2015

TIP : Copy files from Windows10 Host to Ubuntu 15.04 Guest installed in VMWare

Hi Folks,

Find below steps to copy files from Windows Host machine to Ubuntu Guest installed in VMware.

Software Used
1) Windows 10 as Host
2) Ubuntu 15.04 server(not desktop Ubuntu) as Guest
3) VMWare Work Station 10.01
4) WinScp 5.7.5
5) Internet is on Wi-Fi

1)  Install open ssh server in Ubuntu terminal
     Example : sudo apt-get install openssh-server

2) Download WinSCP in Windows
    Download Link : https://winscp.net/eng/download.php

3)  Check VMware internet connection
     #  VM-> Settings ->Virtual Machine Settings window will pop up
     # Select Network Adapter (NAT) and check NAT option in Network connection Tab.



4) Find the ipaddress using ifconfig on Ubuntu terminal
   Example : 192.168.1.128

5) Note down the sudo su username and password of Ubuntu
   Example : User name : hasini and password is hasini

6) Open WinScp and click on Advanced settings
     Left side Environment tab -> Shell
     Right side : In shell tab and shell property choose sudo su -
 

7) Now, provide the credentials of Ubuntu server in WinScp
(If you won't follow this, you will get can't copy error error

8) Click Login to get connect to Ubuntu server and happy file coping.

  Testing : Copy a file from windows directory to ubuntu directory

 Before copying  a file: 

After copying : Drag and drop the file (In above image point 2 to point 4)

NOTE : Alternative way to copy files
1) Copy files tmp folder of Ubuntu
2) Go to tmp folder and using mv command move the file to the target directory in ubuntu.

:-) :-)

Did you find it useful ? Please share for community guys like us..!

Reference :
https://it4beginners.wordpress.com/2011/10/27/connect-to-ubuntu-from-windows-using-ssh/
https://community.bitnami.com/t/how-to-transfer-files-to-server-winscp-gives-permission-denied/1365/2

Tuesday 25 August 2015

Upgrade Ubuntu Server 14.04 to 15.04 - in VMWare Work Station 10.0.1 build-1379776

Hi,
Follow below steps to upgrade Ubuntu Server (Not the desktop) from 14.04 to 14.10

Software I used :
Host   :   Windows -10
Guest : 14.04 server installed in VMWare Work Station.
Virtual Machine : VMWare 10.01

1) check update-manager-core is available or not from server command line editor.

2) If it is not available install it
   command :
       sudo apt-get install update-manager-core

3) Change Prompt=lts to Prompt=normal in release-upgrades file

4) File location : /etc/update-manager/release-upgrades
     Navigate to this directory do the point-3 changes.

5) Save the file and run below command to upgrade
    Upgrade command : sudo do-release-upgrade

6) It will check for new servers and if available upgrade starts

Thanks . Do you find it useful, If yes, share it.


Click on Image for best view of the content 


References : 
1) http://askubuntu.com/questions/5763/upgrading-from-the-command-line
2) http://www.ubuntu.com/

:-) :-)

Thursday 20 August 2015

Basics of writing AND and OR conditions in Filter rows Step in Pentaho Data Integration (aka Kettle ETL)

This post is intended to the beginners of Kettle ETL on writing AND and OR conditions in Filter Step 

Let us take this problem statement (taken from community pentaho forums).

Reference : 
http://forums.pentaho.com/showthread.php?192116-How-to-load-the-different-targets-in-PDI-based-on-multiple-condition

Target1 will have records where Salary < 50000 and Dept_id =10 or 20 and
Target2 will have records where Salary > 50000 and Dept_Id=30 or 40 and
Target3 will have the rows which don't satisfy Target-1 and Target-2 conditions.

Software used : Windows 10, PDI- 5.4 CE stable , Java 1.7 installed


Sample source data : 
Transformation Design  

Combination of AND and OR conditions in Filter rows step

To do the negative of the condition just click on empty condition box appeared left top corner.
You can find the "NOT" keyword which will negative the condition written. 

NOTE : send the true and false data to target steps as shown in above image. 

outputs  - 3 target outputs based on conditions we took in problem. 
Target-1 output : <50000 and 10 & 20 are as dept


Target-2 output : >50000 and 30 and 40 are as dept


 Target-3 : rows which don't satisfy the conditions of Target-1 and Target-2 

I hope this use-case helps some in understanding AND and OR conditions usage in Filter rows step in Kettle ETL 

Download Example : Don't wait - Click Me..!!!

- Sadakar Pochampalli

Pentaho Data Integration use case : add value fields changing sequence and Java script concat & indexOf methods usage

This post is based on a thread posted in pentaho community forums.

Link :
http://forums.pentaho.com/showthread.php?192121-Incrementing-variable-values


Problem Statement :
Add row numbers to child values of a filed. ( the first field in the image is the input )

Solution :




Java script : 

var res = field.concat(seq); // con-cat the "field" column with "seq" column.

var indexOfParentValue=res.indexOf("ParentValue"); //identify the "String position" and returns 0 or -1

if(indexOfParentValue ==0){
var finalField=field;
}
else{
var finalField= res;
}

NOTE that compatibility mode is un-checked in MJavaScript Step.

Download : Download example here

I hope this helps - how to write java script methods in Kettle ETL.

- Sadakar Pochampalli








Wednesday 5 August 2015

CST - Community Startup Tabs in Pentaho 5.4 CE - Example : User based dashboard access on logging

This post is a workout on how CST(Community Statup tabs) works with Pentaho CE BA server.

Documentation from webdetails site has been put in below PPT for easy and quick understanding with an example.

(You may not find new information in PPT but you may quick understand the usage of the plug-in once you gone through the presentation).

Software used :
Pentaho BA Server 5.4 CE, C-Tools 15.x version (CDE,CDF,CDA,CGG and CST).

CST allows you to set which tabs will automatically load when a particular user logs into the PUC.

1) User based
2) Role based
3) Default rules.

Notice that the example in presentation is based on Userbased access for dashboards in a project folder called "Dashboards". (no roles are created for this example).

DOWNLOAD - PPT  ::  CLICK ME

Quick Snapshot : ( Click the images to get the best view of the content )






References : 
1) http://forums.pentaho.com/showthread.php?179716-CST-Community-Startup-Tabs-%28Revamped%29
2) https://github.com/webdetails/cst
3) http://www.webdetails.pt/ctools/cst/
4) http://forums.pentaho.com/showthread.php?153494-Pentaho-CE-5-Customize-Home-Page