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

Thursday 25 February 2016

Pentaho CE 6.0 BA Server Gmail/Yahoo Mail Server Configuration testing (less secure & more secure options for gmail)

Hi Folks,

It been a long time I wrote something useful in Pentaho CE. (Oops..!!! Busy with Jaspersoft)
I have been trying to connect to my gmail for testing scheduling options for reports in it. (Hmmm..!!! I didn't get a chance till today to look in to it from the time when I started exploring Pentaho CE 4.5)

Today, after many trails & discussions with known folks who works on pentaho enterprise, I have successfully connected to my gmail account from Pentaho CE Server
(You may find how to schedule reports in upcoming posts).

I hope this post will help you in configuring the same or your company email for scheduling.

If you had already done it, you can ignore reading it or you can suggest your friends to refer this step by step guide.

Here you go.!

Environment Set up : 
1) Pentaho BA Server 6.0 community edition
2) My gamil acccount
3) Proxy free/Fire wall free network.


With gmail there are 2 secure options
1) Less secure options
2) More Secure Options 

For less Secure Options :

Step 1 : Turn ON less secure option for your gmail account.
1) In your gmail, click on your account picture symbol that you can find at top left corner.
2) Click on "My Account" -> (or you can directly go visit this site : https://myaccount.google.com/?utm_source=OGB)
3) Click on Sign In Security tab -> Scroll down completely till you see an option at little right bottom saying "Allow less secure options".
4) By default it is OFF so make it ON (this means you can access your gmail account in less secure options - for instance few mobile phone email accounts for gmail or apps like pentaho server).

Yeah..!! Its Mobile World Now.. Security matters for open social accounts.

NOTE : Click on images for best view of content placed.
Screen shots for above steps :
Image-1 

Image-2 : 


Step 2 : Configuring gmail SMTP settings in Pentaho BA Server. 
1) Login into the Pentaho BA Server 6.0 CE as an admin 
2) From the drop down of Home -> Select "Administration"
3) Click on middle option which is "Mail Server"
4) Give all the parameters of gmail SMTP as shown below
 Host Name (SMTP) = smtp.gmail.com
 port =587
 Use Authentication = checked
 User Name = sadakar.1988@gmail.com 
 Password = <Password>
 Server Type = SMTP (SMTPs also works for gmail - I have tested and worked for me)
 Email From Address = sadakar.1988@gmail.com ( You can give your name instead email ID)
Use Start TLS = checked (if don't check the setting might not work)
Use SSL = checked ( optional, but I have checked it)

NOTE : TLS is mandatory to check but SSL is optional in my experiment.

That's all .! You are done. Click on "Test Email Configuration" button and on successful message click on "Save"button.

Images for above steps :
Image-3: 

Image-4:

Image-5: Testing notification mail ( Smiles :-) )
 

This way one can setup gmail for yor pentaho BA 6.0 CE server.

For More Secure Options : 

 Alternatively, a more secure option is to configure your gmail server to use 2 step authentication and add Pentaho to the list of trusted applications as follows:

1.    In Google, go to My Account /Sign In & Security / Signing in to Google and change the 2-step Validation from OFF to ON.

2.    This will prompt you for a phone number and some other information. A verification code will be send to the phone number you enter. Enter this code to complete the 2-step authentication.

3.    In Sign-in & Security / Signing in to Google/ go to App Passwords (This will show up under 2-step Verification once it is enabled.

4.    Select Other from the dropbox, and enter Pentaho. Then click on Generate to generate the password.

5.    Go back to your Pentaho Mail Server configuration and enter this generated password under the password box.
6.    Test again.


NOTE : Areas of interest to check other places but need not to do anything with them. 
1) email-config files  under pentaho-solutions folder
<>\biserver-ce-6.0.1.0-386\biserver-ce\pentaho-solutions\system\smtp-email
 email_config.xml
email_config_gmail.xml

2) Go yahoo too in the same way of gmail (the just change is your SMTP , email passoword)
    Need not change the port number i.e., yahoo also worked with 587 port (465 has not worked).

 


I hope this helps you.! Please hit the share button to help the community.

Thank you.
Until Next post
Sadakar


Monday 8 February 2016

CCC Charts basic & Advanced Properties in Pentaho CDE - How to Guide ? (PPT)

Hi Folks,

CCC charts in CDE has got many properties. I have written a how to guide(PPT presentation) on it.
I hope you will find it useful for quick understanding and how to use them on charts to have more interactive visualizations.

This guide will helpful to you start with basic then move on to complex areas of properties. 

Below is a sample screenshot of the presentation, to read more about it download the presentation.

NOTE : This presentation has some 4 to 5 slides, collecting more properties with examples and will update the PPT. You can find updated date and what will be added after first line of this post in future. 

** Click on Images to get the best view of the content placed

Image-1 : 


 Download section : 
Click Me 

NOTE: Presentations are password protected, please send a request to have a copy.
Thank you :-) :-) 

Pre Execution, Post Execution , Pre Change, Post Change , Post Fetch in Pentaho CDE - All in one Guide with Examples(PPT)

Hi Folks,

I have explained how to work with Pre/Post-Execution, Post Fetch and Pre/Post Change in CDE.
Earlier, I had written multiple articles on the same concepts.

In this presentation, I have clubbed all of them. With this clubbed information, you can easily understand when to use which scripting option on components in CDE.

I hope you will find it informative and find it useful for quick understanding.

NOTE : This presentation has some 4 to 5 slides, collecting more properties with examples and will update the PPT. You can find updated date and what will be added after first line of this post in future. 

Sample Images of Presentation : 
** Click on images to get the best view of the content on them

Image-1 : 
Image-2: 
Download Presentation : Click Me

NOTE : This presentation is password protected, please send a request to get a copy.  
              ( You will not get a preview when trying to download)

Thank you. :-) :-)

Sunday 7 February 2016

Extension Points in Pentaho CDE - All in one Guide (PPT)

Hi Folks,

In this presentation, I have clubbed all the information about "Extension Points" in Pentaho CDE.
I hope you will find it interesting and useful for quick development of interactive CCC Charts in CDE.

You can find a list of extension points in my previous post here :
http://pentaho-bi-suite.blogspot.in/2014/07/tipbase-axis-extension-points-in.html

High lights of Clubbed
1) What are extension points in CDE ?
2)  How to apply for CCC Charts ?
3)  Resources for finding extension points ?
4) Quick search from existing examples and use in your dashboards

NOTE : This presentation has some 4 to 5 slides, collecting more properties with examples and will update the PPT. You can find updated date and what will be added after first line of this post in future. 

Sample Slides : 

** Click on Images to get the best view of content : 

Image-1

Image-2 : Quick  Search from Existing Examples


Download PPT here :  Click Me

NOTE :  This presentation is password protected. Send a request to get the password.


Thanks
Sadakar