Install Talend Data integration open studio on ubuntu linux - 64-bit desktop

Install Talend data integration open studio on ubuntu-12.04.2 - 64-bit desktop

Solution -

1. Get ubuntu desktop installed on your machine/virtual box or your ubuntu linux server.
2. Java is installed and JAVA_PATH is set.
3. Download talend DI open studio from www.talend.com - i downloaded TOS_DI_r101800-V5.3.0.zip and save it. (i saved it under home/user/Downloads)
4. extract this zip file to any folder - i used archive manager to extract it to same location - a new folder TOS_DI_r101800-V5.3.0 is created.
5. I moved this folder to usr/local/ - using sudo mv home/user/Downloads/TOS_DI_r101800-V5.3.0 /usr/local/
6. download xulrunner - i downloaded xulrunner-20.0.en-US.linux-x86_64.tar.bz2 
7. extract above to /usr/local/lib - using - following
1. cd /usr/local/lib
2. sudo tar -xvf /home/user/Downloads/xulrunner-20.0.en-US.linux-x86_64.tar.bz2
8. modified TOS_DI-linux-gtk-x86_64.ini under TOS_DI_r101800-V5.3.0 folder by adding following line to the end of file and saved it.

   -Dorg.eclipse.swt.browser.XULRunnerPath=/usr/local/lib/xulrunner

   create a new starttalend.sh script to run as below 

    #!/bin/sh
        export GDK_NATIVE_WINDOWS=1
        /TOS installation directory/TOS_DI-linux-gtk-x86_64  

   grant execute on this starttalend.sh

   ./starttalend.sh  

9. for some even this also works

   launch talend by executing script below

   ./usr/local/TOS_DI_r101800-V5.3.0/TOS_DI/TOS_DI-linux-gtk-x86.sh

   It will take a while to come up to main screen, but it should come. 

   I got default browser error - but that was only preventing me from 

   home page of talend studio when it opens up - no other issue with 

   jobs and other components of talend.

   References - http://www.talendforge.org/wiki/doku.php?id=doc:installation_on_ubuntu 

Talend: Using tGoogleAnalyticsInput component to fetch dimension and metrics from ga (google analytics)

Problem - Using tGoogleAnalyticsInput component to get data from google analytics in form of dimension and metrics

Solution -  As a per-requisite you have to download tGoogleAnalyticsInput component from talendforge exchange.
http://www.talendforge.org/exchange/?eid=537&product=tos&action=view&nav=1,1,1

Next you have to install this component into your talend installation - by using options mentioned in talendforge exchange.
Once you have done that - all you have to do is drag and drop this component into your job and then enter details required for authentication and data you need.

Service Account Email - "youruniqueid@developer.gserviceaccount.com"
keyFile (*.p12)  - your privatekey.p12 file - give its location
profile-ID - profile id as obtained from google analytics (ga)
start date- date from which you want data from ga
end date - date to which you want data from ga
dimensions - dimensions you need separated by comma like "ga:visitorType, ga:visitCount, ga:daysSinceLastVisit"
Metrics - facts you need to measure against above dimensios like "ga:visitors, ga:newVisits, ga:percentNewVisits"

Make sure your schema definition matches with you dimension and metics name in order as give below

results

schema