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

Monday 22 June 2015

Learn Pentaho BI suite(CE) - Pentaho Schema Workbench - Analysis - OLAP - Cubes - Multi Dimensional Databases course structure

Learn Multi Dimensional Database using Pentaho mondrian OLAP Cubes.
 
* Click Images and navigate to get better view of the content.




Sample Slides : 



NOTE : Adding course content in construction with more topics and advanced concepts.

Sunday 14 June 2015

Learn Pentaho BI suite - Pentaho Data Integration (a.k.a Kettle ETL) course structure

Click the images to get best view of the content.


Download Detailed Course content here

MySQL : field doesn't have a default value in MySql when inserting values into a table


On the command prompt issue below command then try inserting the values.

mysql> set @@sql_mode = '  ';
Query OK, 0 rows affected (0.00 sec)

Example :
mysql> INSERT INTO nb (id) VALUES(3);
Query OK, 1 row affected, 1 warning (0.00 sec)

References:
https://netbeans.org/bugzilla/show_bug.cgi?id=190731

Tip : Install mysql driver in Pentaho Data Integration (Kettle)


1) Download mysql-connector-java-gpl-5.1.35.msi from

2) Execute the .msi file. (As soon as you click on run button it executes and disappears). 

3) It'll create MySQL folder inside "Program Files(x86)". (Not the "Program Files")
    Go to below location "C:\Program Files (x86)\MySQL\Connector.J 5.1" and find 
     the "mysql-connector-java-5.1.35-bin.jar" file.

4) Copy this driver to lib folder of kettle .
i.e.,. copy driver in : pdi-ce-5.4.0.0-128\data-integration\lib

5) Start PDI and try giving connection to a mysql database .

Example : 




Resources : 
1) http://stackoverflow.com/questions/18894416/install-mysql-jdbc-driver-msi