Skip to main content

Posts

How export and import saiku files on Pentaho 5

After install saiku plugin for Pentaho 5 available on marketplace, by default isn't possible export the saiku files (".saiku"). So, in this post I'll explain the configuration you need to do for have this feature. Stop your pentaho server; Open the file <pentaho-path>/biserver-ce/pentaho-solutions/system/importExport.xml ; Add " <entry key="saiku" value-ref="streamConverter"/> " to  convertersMap map; Add " <entry key="saiku" value="text/xml"/> " to the map of  NameBaseMimeResolver bean; Add " <value>.saiku</value> " to the list  approvedExtensionList ; Start pentaho server again and try download one saiku file.  As an example I leave this link for the file, after configured.
Recent posts

OpenShift QuickStart for SuiteCRM

In the last days, I create an OpenShift quickstart for SuiteCRM . You can find the this openshift quickstart on GitHub . First you need create a Openshift on-line account and install the RHC client tools you can find out more in this page:  Getting Started page . After you install RHC client you just need run the following command: rhc app create suitecrm php-5.3 mysql-5.1 --from-code=https://github.com/latinojoel/suitecrm-openshift-quickstart/  After the command above executed with success you can access the following URL: http://suitecrm-$yournamespace.rhcloud.com and I few seconds you will have your SuiteCRM created. The default credentials are username "admin", password "admin". And as you can see in few minutes you have your CRM installed running on OpenShift Cloud. Installation Config This quickstart use PHP 5.x and MySQL 5.x cartridges , and you can configure the automatic install these files: file1 and file2 (like SugarCRM). About S

Pentaho overview using MongoDB (Oporto MUG #2)

  I'm writing this post for share the presentation and resources of my talk on the second meetup  Oporto MongoDB User Group . The talk consist on demonstrate the integration between Pentaho and MongoDB, on the three aspects: ETL, Reporting and Dashboarding. Look the presentation: The data I use is just for demonstration, I didn't care with performance, content or data quality, the goal are just demonstrate how you can integrate Pentaho with MongoDB with simple examples. And show the potential and how easy is integrating with other systems, in this case Google Maps API. In resume, if you want integrate Pentaho with MongoDB, there're two options for do it: ETL: With Pentaho Data Integration (aka kettle) you can use the "MongoDB input" and "MongoDB output" steps for get and save data. The ETL transformations can be use on Pentaho Reporting or CDE using CDA. Programming: This is the best choose for me because I'm familiar with Java develo

How publish Saiku Analytics on OpenShift

Saiku Analytics is a great open source server or Pentaho plugin for explore and vizualize data! About Saiku : " Saiku was founded in 2008 by Tom Barber and Paul Stoellberger. Originally called the Pentaho Analysis Tool, if started life as a basic GWT based wrapper around the OLAP4J library. Over the years it has evolved, and after a complete rewrite in 2010, it was reborn as Saiku. Saiku offers a user friendly, web based analytics solution that lets users, quickly and easily analyse corporate data and create and share reports. The solution connects to a range of OLAP Servers including Mondrian, Microsoft Analysis Services, SAP BW and Oracle Hyperion and can be deployed rapidly and cost effectively to allow users to explore data in real time. " - Meteorite About OpenShift : " OpenShift is a cloud computing platform as a service product from Red Hat. A version for private cloud is named OpenShift Enterprise. The software that runs the service is open-sourced un

A new Pentaho book

A new book about Pentaho is out! The name is  Instant Pentaho Data Integration Kitchen . " The book is about kitchen and how to use the PDI's command line tools efficiently to help people in their day to day operations with Pentaho Data Integration. It is a practical book and it seemed relatively easy to write. "  Sergio Ramazzina I was the technical reviewer for this book and I was very happy because the publisher choose me and is another experience that I really liked. Also, I want to wish them congratulations to the author  Sergio Ramazzina  to write this book and contribute to opensource community.

PDI Apple Push Notifications Plugin is available on Pentaho Marketplace

Since 14 of June, the PDI Apple push notification is available on Pentaho Marketplace. Now, PDI can send push notifications to the two most popular smartphones platforms. Check out what Matt Carters (Chief Data Integration for Pentaho) say about plugins available on Pentaho marketplace in the Pentaho Big Data Architecture presentation of Pentaho London User Group event (at 18 minute):  http://skillsmatter.com/podcast/ajax-ria/pentaho-hadoop-user-stories-beer-pizza-and-more Interested Links: Pentaho Data Integration Marketplace Wiki: Link Pentaho Data Integration Marketplace Source: Link PDI Apple Push Notifications Plugin Wiki: Link PDI  Apple  Push Notifications Plugin Source: Link PDI  Apple  Push Notifications Plugin Artifacts: Link PDI Manager Android App: Link

Run ETL with Pentaho Data Integration using package files

The Kettle have a small functionality to run ETL, it uses Apache VFS that let you access a set of files from inside an archive and use them directly in your processes. However, you can use this for execute ETL in somewhere on the web. Run in file system I create this little sample (a job that executes a transformation). And I compress this two in the zip file. So, I have this zip file on that path in my own computer:  C:\Users\latinojoel\Desktop\sample.zip The command line I need to do for execute ETL, is looks like that: ~\data-integration>Kitchen.bat - file =zip:\\ "C:\Users\latinojoel\Desktop\sample.zip!/job.kjb" -level=Detail -param:MSG= "Wow, It's works. Very funny! :-)" Run from web resource With Apache VFS, you can run a zip file from web too. For example, you can access of my zip file using this  URI . The command line you need to do is that: ~\data-integration>Kitchen.bat - file = "zip: https://dl.dropboxusercon

Pentaho Data Integration notifier job state

This a little sample how create a job notifier of another job is terminated with error or success. The first step is create a job sample that represents job of ETL process (for example, a job that is responsible to populate DW). Create a job example The first step is create a transformation that receive from ${VALUE} variable and if that value match with 'Y' the transformation execute successfully else ${VALUE} have a different value of 'Y' the transformation execute with error. See the following transformation workflow: The second step is create job that execute the above transformation. See the following job workflow: Create the main job Create a transformation notifier In this transformation you'll need define how you can be notified. In this sample you would be notified by email, android push notification (using PDI Manager) and apple push notification (is a new plugin, will be available in the few days). Transformation receive

PDI Android Push Notifications Plugin is available on Pentaho Marketplace

It has been a week that PDI Android Push Notifications Plugin is available on Pentaho Marketplace. The current version is 0.9-GA. More surprises are coming. Interested Links : Pentaho Data Integration Marketplace Wiki:  Link Pentaho Data Integration Marketplace Source:  Link PDI Android Push Notifications Plugin Wiki:  Link PDI Android Push Notifications Plugin Source:  Link PDI Android Push Notifications Plugin Artifacts:  Link PDI Manager Android App:  Link

Now is possible you receive push notifications from Pentaho Data Integration

As I said in my first post in my blog, there are two things I want share with you: PDI Android Push Notifications Plugin : This is a plugin that permit to you send push notifications from Pentaho Data Integration to any android application that enable GCM service. This plugin is written in Scala !!! Check out: https://github.com/latinojoel/pdi-android-pushnotifications . Note: t his plugin yet is a release candidate. PDI Manager Android App : Is a Android App that enable to you receive push notifications from PDI. About PDI Android Push Notification Plugin   Instalation You need Pentaho Data Integration install ed; Do wnload  the plugin from sourceforce , you can find in this link ; Stop your Pentaho Data Integ ration if it's running; Uncompress AndroidPushNotification file; Copy AndroidPushNotification folder to <pdi-folder-installation>/plugins/step s ;   Start your Data Integration and en j oy :-).  Configuration You need to be famili

How create zip files with Maven

In some maven projects is important generate a  compressed file, for example to send by email. So, in this post I will show you how you can generate compressed   files using Maven. In you pom.xml file you need incorporate the  maven-assembly-plugin plugin, something like that: So, as you can see, you need define a bin.xml file in src/assembly/ path, you can define the name and path that you want. Is only mandatory have a specific structure content. That you can see a example below: That example, permit create zip , tar , tar.gz , tar.bz2 . If you want put all dependencies on the compress file, you don't need define includes tag. More details about maven-assembly-plugin :  http://maven.apache.org/plugins/maven-assembly-plugin I hope that information is useful for you. Feel free to comment this post.

Coming something to Pentaho Data Integration

This is my first post in my personal blog, so you are ask why? The answer is because on last days I developed something that I think is very useful to pentaho community. In this moment I don’t want talk very must about that but I can say it’s to improve the quality work of ETL developers. Coming coming….