Pentaho Announces Extreme Scale In-Memory Analytics

Pentaho press release :

 

 Users can now analyze big data with speed-of-thought performance and high availability

TDWI World - Orlando, Fla. — Octobre 31, 2011 —

Pentaho Corporation, the business analytics company providing power for technologists and rapid insight for users, today announced the latest release of Pentaho Business Analytics including major improvements to data analysis performance, scalability and reliability with support for cloud-scale distributed in-memory caching systems, new performance tuning aids, and support for analysis of more big data sources. These new capabilities are available today in the latest release of Pentaho Business Analytics, with the new product name representing Pentaho’s comprehensive and integrated business intelligence, data integration, data mining and predictive analytics capabilities.
This release provides the benefits of an in-memory solution without the limitations of an in-memory only architecture. Now, business users experience in-memory performance while IT gets a sound, scalable and manageable analytics platforms built on proven data warehousing and BI best practices. New features include:

• In-memory analytics– Pentaho’s data analysis capability now supports Infinispan/JBoss Enterprise Data Grid and Memcached, with the option of extending to other in-memory cache systems. Infinispan and Memcached can cache terabytes of data distributed across multiple nodes, as well as maintain in-memory copies of data across nodes for high availability and failover. Using these in-memory caching systems results in more insight through predictable speed-of-thought access to vast in-memory datasets.
• In-memory aggregation– granular data can now be rolled-up to higher-level summaries entirely in-memory, reducing the need to send new queries to the database, resulting in even faster performance for a wide range of analytic queries.
• New analytic data sources– adding to Pentaho’s unmatched list of native big data platform support, native SQL generation is now supported for the EMC Greenplum Database and the Apache Hive data warehouse system for Hadoop.  This optimizes interactive data exploration performance when using Greenplum, and for Hive this makes it possible to design analytic reports offline then schedule them for background execution.

More informations here

Pentaho 4 is out

Pentaho 4 demo is here : demo.pentaho.com

Your Excel exports requests in Web with Kettle and Pentaho BI Server ( TechTip)

A very interresting post from Sylvain Decloix on osbi.fr about Excel Exports with Kettle.

Pentaho Data Integration (Kettle) est souvent très utile pour générer et délivrer de façon simple des fichiers Excel à destination d’utilisateurs finaux. On peut en effet joindre un fichier « au résultat » d’une transformation afin de l’envoyer ensuite par mail aux personnes souhaitées via l’étape « Envoi Courriel » (cliquer sur les images pour les agrandir) :

Cependant, comment faire pour permettre à un utilisateur final de télécharger à la demande le fichier Excel via un navigateur web, en filtrant éventuellement les données à exporter au travers de paramètres présentés via un formulaire Html (listes déroulantes, cases à cocher…) ?
Réponse: avec un serveur Pentaho !

The continuation on osbi.fr

Dynamic User Console Logos

The following topic covers how the Pentaho User Console logo can change based on the user id or role of the user that logs in.
This is performed by adding the UrlRewriteFilter Java Web filter to the Pentaho BI Server installation.

Read more at the Pentaho Evaluation Sandbox.

Dynamic Step Metadata with PDI

Did you know that Pentaho Data Integration includes Experimental Transformation steps?   Experimental steps encourage proactive testing and critical feedback from the user community. The reported results are used to harden the product for the next revision. You can always provide your feedback, suggest new features and report issues  here on our tracking site for any of Pentaho’s product offerings.


Transformation steps already ........ read more of this topic and download a working sample here at the Pentaho Evaluation Sandbox.

Customize default users in Pentaho Login page

To customize default user list in loginpage, perform the following steps:

1. Navigate to \biserver-ce\tomcat\webapps\pentaho\mantleLogin\
2. Open Loginsetting Properties file.
3. Modify userid, username and password as per your requirement.

e.g., userIds=citbi
userDisplayNames=CITBI
userPasswords=100%sec

4.Save the file and retart the BIServer and admin console.

Info glanée sur le forum Pentaho

Change the admin console password in Pentaho Admin

A tester :

To change the admin console password in Pentaho Admin Console page perform the following:

1. Navigate to BI Server (biserver-ce-3.6.0-stable)\administration-console\resource\config
2. Open Login Properties file.
3. Get the MD5 encrypted text for your password (visit http://md5-encryption.com/ to create md5 encrpted password)
4. You will get something similar to 'vsdsdrfew232fesfq23'
5. Now replace 'admin: OBF:23f223ef23resf5ess' with 'admin: MD5:vsdsdrfew232fesfq23'
6. Restart your server and try login using your new password. If any issue clear your browser cache and try again

Info glanée sur le forum Pentaho

Stable builds of BI Server and Suite Clients 3.7.0 have been posted to SourceForge

Pentaho BI Server 3.7.0-stable: https://sourceforge.net/projects/pen.../3.7.0-stable/

Pentaho Report Designer 3.7.0-stable: https://sourceforge.net/projects/jfr.../3.7.0-stable/

Pentaho Design Studio 3.7.0-stable: https://sourceforge.net/projects/pen.../3.7.0-stable/

Pentaho Metadata 3.7.0-stable: https://sourceforge.net/projects/pen.../3.7.0-stable/

Paramétrage de Pentaho BI Server

La mise en œuvre de Pentaho BI server nécessite de toucher à quelques fichiers.
Voici la liste des fichiers sur lesquels je suis intervenu pour mettre en œuvre mon serveur de test ainsi qu'une brève description des propriétés modifiées, ou de celles dont j'ai compris l'utilité.

Cette liste n'est bien entendu pas exhaustive et à pour vocation d'être mise à jour au fur et à mesure de mon avancée sur la solution Pentaho.


Paramétrage de base :


Fichier : 

Pentaho\biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml

Propriétés :

solution-path : vide par défaut, inchangé.
base-url : par défaut http://localhost:8080/pentaho/ à remplacer par l'Url du serveur pour que l'accès distant fonctionne.
locale-language : vide par défaut, inchangé. valeurs possibles : fr, de, ca...
locale-country : vide par défaut, inchangé. Valeurs possibles : FR, DE, CA...

Masquer les utilisateurs par défaut (Joe...)

Fichier : 

\biserver-ce\tomcat\webapps\pentaho\mantleLogin\Loginsetting.properties

Propriétés :

Change #showUsersList=true to 'showUsersList=false'

Save the file and retart the BIServer And admin console.