Yesterday, appart from election day pentaho announced the release of the new version of its Business Analytics suite. The new version is 4.8 includes great additions like Mobile, Instaview and many other feature enhancements in the Pentaho Business Analytics Suite 4.8.
Pentaho 48 Overview
Download Pentaho Data Integration 4.4
A new deployment of Kettle was also released, hurry up it is time to get it and try it, the download it from here: www.pentaho.com/download (Enterprise Edition) and coming soon on Sourceforce (PDI Community Edition).
New PDI features
Pentaho Instaview is the fastest way to start using Pentaho Data Integration to analyze and visualize data. Instaview uses templates to manage the complexities of data access and preparation. You can focus on selecting and filtering the data you want to explore, rather than spending time creating source connections and identifying measure and dimension fields. Once the data has been selected, Instaview automatically generates transformation and metadata models, executes them, and launches Pentaho Analyzer. This allows you to explore your data in the Analyzer desktop user interface.
As your data requirements become more advanced, you have the ability to create your own templates and use the full power of Pentaho Data Integration (PDI).
Watch this video and see the Getting Started with Pentaho Data Integration Instaview Guide to understand and learn more about Pentaho Instaview or
PDI Operations Mart
The PDI Operations Mart enables administrators to collect and query PDI log data into one centralized data mart for easy reporting and analysis. The operations mart has predefined samples for Pentaho Analyzer, Interactive Reporting, and Dashboards. You can create individualized reports to meet your specific needs.
Sample inquiries include
- How many jobs or transformations have been successful compared to how many failed in a given period?
- How many jobs or transformations are currently running?
- What are the longest running jobs or transformations in a given period?
- What is the highest failure rate of job or transformations in a given period?
- How many rows have been processed in a particular time period? This enables you to see a trend of rows or time in time series for selected transformations.
The operations mart provides setup procedures for MySQL, Oracle, and PostgresSQL databases. Install instructions for the PDI Operations Mart are available in the Pentaho InfoCenter.
Concat Fields Step
The Concat Fields step is used to join multiple fields into one target field. The fields can be delimited by a separator and the enclosure logic is completely compatible with the Text File Output step.
This step is very useful for joining fields as key/value pairs for the Hadoop MapReduce Output step.
EDI to XML Step
The EDI to XML step converts EDI message text, which conforms to the ISO 9735 standard, to generic XML. The XML text is more accessible and enables selective data extraction using XPath and the Get Data From XML step.
SAS Input Step
The SAS Input step reads files in sas7bdat format created by SAS software. This step allows PDI developers to import files in sas7bdat format.