Community Connection: New Pentaho Data Integration, Pentaho Reporting Releases Available
================================================== ==================
Pentaho Data Integration 2.4 Released
--------------------------------------------------
We are proud to announce the release of Pentaho Data Integration 2.4. This exciting new release features significant improvements in performance, scalability and ease-of-use.
Highlights of this release include:
*Remote monitoring and execution of transformations
*Clustering support
*Unified job and transformation editor
*Numerous new steps and transformation objects
*And much, much more...
Thanks to all of our contributors who helped in the development and testing
of this fantastic new release.
Download Pentaho Data Integration 2.4 at http://www.pentaho.org/download/ today!
Modified Javascript Values Step: Community Addition to PDI 2.4
-------------------------------------------------------------------
Every once in a while we get big donations in terms of source code in the Kettle project. One of these donations came in the form of a new and improved JavaScript engine for Kettle. It was written by Martin Lange who needed a high performance Javascript engine for one of his clients. Martin is one of the people behind German company Proconis, http://www.proconis.de/.
The new Javascript engine step has achieved huge performance compaired to the regular "Javascript Value" by using the core Rhino embedding system to create new conversion functions. In the new step, Martin has extended the Javascript function library with new efficient functions, including date handling. Not only does this provide serious performance gains but we can also start building a more re-usable library. The system is easier to re-use because it no longer relies on the internal Value objects exposed by the Kettle environment, but rather leverages Javascript itself.
If that is not enough, Martin created a new tabbed user interface, http://www.pentaho.com/images/kettle_javascript.jpg, to allow for multiple scripts to be loaded and executed, with pre and post execution scripts, color coding and much more. This is the initial release of the new step, but I'm sure we'll hear much more about this step in the future.
Cheers,
Matt, Kettle Founder and Chief Architect
Pentaho Report Designer 1.2 RC1 Available
-------------------------------------------------------------------
We're happy to tell you that Pentaho Report Designer 1.2 RC1 is now available for download at http://www.pentaho.org/download/latest. We would really like to get as much testing and feedback as possible from everyone to make this the best release possible, so please feel free to hit the forums at http://forums.pentaho.org/forumdisplay.php?f=142
with your bug reports, questions and comments!
Highlights of Pentaho Report Designer 1.2:
* Easily begin report creation using templates with the embedded Pentaho Report Design Wizard.
* Access data sources including relational, OLAP (Mondrian aka Pentaho Analysis), XML and Java methods.
* Preview and Run reports in PDF, HTML, Excel, CSV and RTF.
* Publish reports directly to the Pentaho server.
Subreports Beefed Up in Pentaho Reporting 0.8.8
-------------------------------------------------------------------
Pentaho Reporting maintenance release 0.8.8-01 is now available http://sourceforge.net/project/showf...ckage_id=45618 from Sourceforge.net. This release stabilized greatly the new subreporting features, as detailed in the release notes http://sourceforge.net/project/shown...group_id=51669. Note that the subreporting functionality is not yet available in the Pentaho platform or design tools.
Improvements to Pentaho Reporting 0.9.0
-------------------------------------------------------------------
If you missed the release last month, The Pentaho Reporting 0.9.x codeline is ushering in the new era of reporting. This release is a full rewrite of the old codebase, incompatible with all previous releases, and as of yet, incompatible with the Pentaho platform. With this release, we shift our reporting paradigm from absolutely-positioned, banded reports into document oriented reports. This month, we have released Pentaho Reporting 0.9.0-02 http://sourceforge.net/project/showf...ckage_id=45618, the first maintenance release to provide fixes to our 0.9.x codeline. Fixes include stabilizing subreports, better support for empty datasets and much more.
Try it out http://sourceforge.net/project/showf...ckage_id=45618 and give your feedback in the forums http://forums.pentaho.org/forumdisplay.php?f=125!
Pentaho Reporting 0.9.x Roadmap: What's Your Take?
---------------------------------------------------
Next up on the Pentaho Reporting 0.9.0 roadmap - Charting.
For the charting, we are currently in the process of collecting the requirements for the chart-components. It would be a great help to get you, the reporting community, to send our feedback, suggestions and feature requests http://forums.pentaho.org/forumdisplay.php?f=125, so that the result is closer to the user's needs.
At the moment, Thomas, the project founder and lead architect, is planning to include chart-backends for:
* JFreeChart (the standard charting engine in Java)
* OpenOffice Charts (for perfect exports for OpenOffice documents)
* JCharts (an alternative Java charting engine)
* Dojo.Charting (AJAX Charting for HTML exports)
What we are looking for? FEEDBACK http://forums.pentaho.org/forumdisplay.php?f=125!
* What chart types should have priority (should be implemented first)?
* What use cases should we address?
* Is there anything special we should take care of?
And more generally:
*What do our users expect from a reporting engine?
*What can be improved on today's reporting engine (any engine!)?
TDWI Radio News: Open-Source BI, Moving Beyond the Myths
-------------------------------------------------------------------
The Data Warehouse Institute recently interviewed Pentaho CEO Richard Daley, inquiring about the affairs and future of Open Source Business Intelligence. Tune in to this TDWI Radio News interview http://www.esj.com/business_intellig...torialsID=8302 to learn:
*What's included in Pentaho's technology stack
*Which companies are using Pentaho's tools
*How Daley & Co. make their money
*How far down the road Pentaho is looking
Pentaho Finalist in Jolt Product Excellence Awards
-------------------------------------------------------------------
For the past 16 years, the Dr. Dobb's Jolt Product Excellence Awards have been presented annually to showcase products that have "jolted" the industry with their significance and made the task of creating software faster, easier, and more efficient. This year, Pentaho has been chosen as a finalist in the Enterprise Tools category!
Dr. Dobb's Awards and Events Manager Rosalyn Lum comments "Competition to stay ahead is fierce and competition fosters innovation. This year's Jolt Award finalists represent those companies that keep innovation alive."
Congrats Pentaho team and Pentaho community! The final selections will be announced in March at the 20th Software Development Conference & Expo West at the Santa Clara Convention Center. Go here http://dmnnewswire.digitalmedianet.c...fterinter=true for the whole story.
New Tech Tips Online
-------------------------------------------------------------------
Two super tech tips published this month - thanks to Mike and Chris for making the effort to share their expertise with the rest of us!
MDX Calculations:Set Functions
http://community.pentaho.org/techtip/articles/mdx_calculations_set_functions.php
Using AJAX to Drive Dependent Report Parameters
http://community.pentaho.org/techtip...rameters.ph p
February Training Sessions
-------------------------------------------------------------------
It's not too late to sign up for February training sessions with Pentaho. Pentaho Training sessions offer the fastest route to becoming a "solution-ready" developer with the Pentaho Open BI Suite.
Building Analytic Solutions Using Pentaho
http://www.pentaho.com/elqNow/elqRedir.htm?ref=http://www.regonline.com/118034
Orlando, FL USA
February 6 - February 9
Operational Business Intelligence Using Pentaho
http://www.pentaho.com/elqNow/elqRedir.htm?ref=http://www.regonline.com/118041
Orlando, FL USA
February 19 - February 22
Building Analytic Solutions Using Pentaho
http://www.pentaho.com/elqNow/elqRedir.htm?ref=http://www.regonline.com/119644
Toronto, Canada
February 26 - March 1
Working with the Projects
-------------------------------------------------------------------
Not sure where to find all the tools you need to be a committer in the Pentaho projects? Here's an on-ramp to contributing to the projects, the locations of the core tools of a successful Pentaho developer:
* Downloads - http://www.pentaho.org/download/
* Get the Source Code - http://community.pentaho.org/getthecode/
* The Forums - http://forums.pentaho.org/
* Issue Tracking with JIRA - http://jira.pentaho.org
* Documentation Wiki - http://wiki.pentaho.org
* Tech Tips - http://community.pentaho.org/techtip/
Where do you start? Email communityconnection@pentaho.org [mailto:communityconnection@pentaho.org].
JFreeReport's Name is Changing
-------------------------------------------------------------------
As announced roughly a year ago, we are planning to rebrand JFreeReport to make it part of Pentaho Reporting. This change should be non-disruptive, and will not affect the projects java namespace or technical documentation.??What you will see is a new logo, a changed community subdomain, and high-level references to Pentaho Reporting rather than JFreeReport.??This change is being made in partnership with jfree.org, and the jfreechart project to avoid potential community confusion.
Thank you for your patience while we make the transition.
Meet the Team
-------------------------------------------------------------------
Will Gorman
Pentaho Software Developer
Tell us a little about your engineering career to date.
I started my career at GE Research, where I worked on projects ranging from
aircraft engine expert systems to medical informatics focused on predicting
Alzheimer's progression.
When did you first become interested in open source?
Back in college, I started dabbling with Linux for my server needs.
Since then, I've released most of my spare time software projects as open
source. Two projects that I'm most proud of are JAIMBot, a AOL IM Robot
architecture and and ImageIM, a plugin for GAIM that allows people to send
screenshots easily over IM.
What projects do you work on at Pentaho?
My focus to date has been working within Pentaho's BI Platform, specifically
user interface and security enhancements.
What do you like most about working for Pentaho?
My favorite part about working here are the people I work with. The
engineers here are top notch and their passion for open source is
infectious. We work together in an open lab environment, which makes each
day extremely entertaining.
What do you do in your spare time?
In addition to spending time with my wife and son, I'm always coming up with
ideas to work on in my spare time. One of my favorite hobbies is
BattleBricks, a competitive Lego robotics group that I started with a group
of friends.
2007-01-26 15:09:21 UTC by gmoran-pentaho
Pentaho Community Connection
===========================================================================
---------------------------------------------------------------------------
Pentaho Open BI Suite 1.2 GA Now Available
---------------------------------------------------------------------------
Happy Holidays -- Pentaho Open BI Suite 1.2 is Generally Available!
We have reached the finish line! Pentaho 1.2 is now generally available.
Together,
* we have gone through three release candidates,
* found 925 issues and enhancements,
* and resolved 650 (over 70%) of the reported issues and enhancements.
Although we are moving on to the next version, we will continue to improve
the 1.2 release with better documentation and updates for critical
improvements and issues. The Release Candidate forum will be locked for new
posts; however, the content will be searchable and available. Additionally,
we have improved our documentation (see the Introducing... the Documentation Wiki
in this newsletter).
Download the 1.2 release now at http://www.pentaho.org/download/latest.php !
We thank you for your support and help through this year of intense
development and growth. Stay tuned for announcements concerning more ways
for you to get involved with the project!
---------------------------------------------------------------------------
Introducing... the Documentation Wiki
---------------------------------------------------------------------------
In conjunction with the release of Pentaho Open BI Suite 1.2 GA, the Pentaho
team has moved all of the project documentation to a new wiki format. We are
excited to have all documentation in a format that encourages community
collaboration, feedback and contributions.
Check out the new documentation at http://wiki.pentaho.org . Feel free to
comment and give us feedback at http://forums.pentaho.org/forumdisplay.php?f=236
on the new wiki in our documentation forum.
---------------------------------------------------------------------------
Advanced Implementation Workshop: A Unique Opportunity
---------------------------------------------------------------------------
Pentaho is a business intelligence platform in the extreme. Its many
standards-based interfaces provide almost unlimited flexibility and the
ability to integrate BI into a variety of enterprise architectures, both up
and down the stack.
The Advanced Imlpementation Workshop is an intensive hands-on workshop,
guided by the Pentaho development and product management teams, giving
participants insight into the design philosophy and deployment scenarios
intended for Pentaho and supported by Pentaho Management Services.
Emphasis is placed on points of integration with 3rd-party security APIs,
application servers, portals and source code control systems.
This is a 3 day workshop, offered January 30, 2007 to February 1, 2007. Cost
is $995 USD per attendee; attendance is limited. Take advantage of this
unique opportunity and register today at http://www.regonline.com/Checkin.asp?EventId=117047 .
---------------------------------------------------------------------------
Pentaho Featured on Google Code
---------------------------------------------------------------------------
Google Code (http://code.google.com) is featuring Pentaho's AJAX-based integration with the Google Maps API.
Pentaho's example was selected as a compelling and innovative example of the flexibility and power of the Google Maps API.
To see the Google Maps integration in action, download the Pentaho Open BI Suite Pre-Configured Installation (PCI) demo
at http://www.pentaho.org/download/latest.php .
In the samples that ship with the PCI, navigate to Solutions, Samples, Steel Wheels, Dashboards, Google Maps. There you will find an interactive
sample that demonstrates mapping with Pentaho Dashboards and Pentaho sample data.
Download the Pentaho demo and test drive Google Maps integration today at http://www.pentaho.org/download/latest.php .
---------------------------------------------------------------------------
Software Quality Reporting for JIRA Now Available
---------------------------------------------------------------------------
Software Quality Reports for JIRA/Bugzilla (SQR) provides reporting and
analysis on top of the very popular JIRA and Bugzilla issue tracking
systems. SQR is an out-the-box, packaged solution built upon the Pentaho
Open BI Platform. It provides an end to end solution for delivering valuable software quality
information to product managers, project managers, development managers, and software engineers.
Software Quality Reports includes:
* Extract Transform and Load (ETL) Mappings
* ETL Jobs
* Reporting Data Models (ie, Dimensional Models, staging tables, summary tables, aggregates)
* OLAP Schema Definitions
* Operational Reports
* Analytic Reports
Take a look at SQR for JIRA today at http://sourceforge.net/projects/qareports/ .
---------------------------------------------------------------------------
Latest Project Releases
---------------------------------------------------------------------------
We're proud to announce the release of the next generation in open source
reporting - JFreeReport 0.9.0. Download the 0.9.0 version
http://sourceforge.net/project/downloading.php?group_id=51669&filename=jfreereport-0.9.0-01.zip
and test drive the new engine today.
---------------------------------------------------------------------------
New Training Offered
---------------------------------------------------------------------------
Pentaho training is growing to cover the critical needs of Pentaho
developers and users! New content and expanded sessions make Pentaho training even more
comprehensive and packed with everything you need to be "solution-ready".
Check out the sessions available at http://www.pentaho.com/services/training/
in early 2007.
---------------------------------------------------------------------------
Pentaho Project Forums
---------------------------------------------------------------------------
Visit the new Pentaho projects forums at http://forums.pentaho.org/.
The JFreeReport, Mondrian, Kettle, WEKA and Pentaho forums now share the
same community home - a faster, more customizable environment, conducive to
collaboration and project development.
Send us your thoughts on the new forums via our Migration Support Forum at
http://forums.pentaho.org/forumdisplay.php?f=136 .
---------------------------------------------------------------------------
Get Involved!
---------------------------------------------------------------------------
Beta Program Team Members Wanted!
We are looking for active community members and partners to participate in
upcoming Beta programs. By participating in Beta programs, you will gain
early access to the latest Pentaho product offerings and get the chance to
work directly with the Pentaho development team.
Go here for more details: http://www.pentaho.com/beta/
...
Weigh in on the Hefty Job of Internationalization
It is our mission to build the best toolset for the development community
around the best business intelligence suite. With the introduction of the
documentation wiki, we have encountered new localization challenges.
Read about it here, http://forums.pentaho.org/showthread.php?t=49970,
and weigh in, your opinion matters!
==============================================================
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives at http://community.pentaho.org/newsletter/archive.php .
Email: communityconnection@pentaho.org
Forums: http://forums.pentaho.org
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
2006-12-22 15:20:29 UTC by gmoran-pentaho
The new Mondrian forums are at http://mondrian.pentaho.org/forum !
Pentaho, Mondrian, Kettle, JFreeReport and WEKA now share the same forum home - a full-featured, super fast, personalizable forum home! Many thanks to our community beta testers who have been trying out the new forum software and providing feedback throughout the testing period.
In the interest of making this the best possible resource for our community, we have migrated the threads from all prior forums into the new forums. If you are already a member of these projects, visit the Migration FAQ at http://community.pentaho.org/faq/forum_migration_faq.php to learn how to use your existing account or merge your multiple accounts. If you are new to the community, register for a new account and welcome to the Pentaho projects.
All of the project leaders, the project teams and the Pentaho Community Connection are thrilled to be bringing an awesome new set of collaboration tools to you, our community. Please give us your comments, questions and concerns on the new forums in our Migration Support Forum at http://forums.pentaho.org/forumdisplay.php?f=136 . We love to get your feedback!
Finally, check out the Migration FAQ for more improvements coming in 2007!
kind regards & welcome to the new forums!
Pentaho Community Connection
2006-12-11 18:30:54 UTC by gmoran-pentaho
Pentaho Community Connection
--------------------------------------------------------------
We are pleased to announce that on December 10, 2006, we will be moving the Pentaho project forums to a new, faster, more full-featured forum site. This move includes the forums for the Pentaho project, the Mondrian project, the Kettle project and the JFreeReport project.
The objective for moving the project forums is simple and sincere - we wish to provide the very best community environment for all of our communities to work, play and develop in. All of the project forums have room to grow toward this objective. Each project (ie., Mondrian, Kettle, Pentaho) will have it's own portal into the forums for those community members who wish to remain focused on the individual project. We also now have the added benefit of providing integrated resources for the community that is using multiple Pentaho projects or the entire BI suite.
We are very well aware that moving a project's forums is very much like moving a home for an open source project, and have taken care to "pack all the valuables" carefully. Our first effort at making sure the community is informed and involved is this pre-announcement of the move. We are asking for your comments, concerns and feedback on our plan for handling the move. You can review the Forum Migration FAQ ( http://community.pentaho.org/faq/forum_migration_faq.php ), and post your thoughts in the Migration Support Forum at http://forums.pentaho.org/index.php?option=com_simpleboard&Itemid=275&func=showcat&catid=49 . We will migrate the Migration Support Forum and keep it live for 90 days after the move or until we feel that all communities have settled in to their new forums comfortably.
We also invite anyone in the community to preview the test forum site that we have set up to validate the move. Email communityconnection@pentaho.org for instructions on how to access the test site.
--------------------------------------------------------------
--------------------------------------------------------------
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives at http://community.pentaho.org/newsletter/archive.php .
Email: communityconnection@pentaho.org
Forums: http://forums.pentaho.org
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
2006-12-04 19:08:43 UTC by gmoran-pentaho
Pentaho Community Connection
--------------------------------------------------------------
Pentaho Releases First Milestone Build of Pentaho Metadata
--------------------------------------------------------------
Pentaho has released the first milestone release of Pentaho Metadata(PMD)
including the new Metadata Editor(PME)!
Released under the Mozilla Public License (MPL), Pentaho's new open source
metadata capabilities enable administrators to define a layer of abstraction
to shield the common business user from the complexities of underlying
databases. Administrators leverage their deep understanding of source
systems to convert complex tables, relationships, indexes, and other
concepts foreign to a business user, into a user-friendly model reflecting
how they think of their business - in terms like customers, products and
markets. These "business views" can be further enriched by defining security
parameters that limit data access to authorized users, default formatting
for data fields, column suppression, and additional translations for
business views used in multi-lingual deployments.
Pentaho Metadata is built using the Common Warehouse Metamodel (CWM)
standard created by the Object Management Group (OMG) to allow for
interoperability with existing metadata stores as well as third-party
databases, metadata repositories, and ETL tools. Pentaho's metadata-driven
query engine uses JDBC and ANSI standard SQL to allow for the broadest
possible choice of proprietary and open source databases including Oracle,
IBM DB2, Microsoft SQL Server, MySQL, PostgreSQL and others.
Download the first milestone release, documentation and source from
http://www.pentaho.org/download/latest.php .
Send us your feedback in our Metadata forum at http://forums.pentaho.org/ .
--------------------------------------------------------------
Pentaho Introduces Web-based Ad Hoc Query and Reporting
--------------------------------------------------------------
We are pleased to announce new web-based ad hoc query and reporting
capabilities for the Pentaho Reporting module of Pentaho's BI suite. The new
functionality utilizes an innovative new open source metadata layer that
facilitates self-service query and reporting by shielding end users from the
complexities of underlying databases and thereby lowering the technical
barriers to customized report creation.
Pentaho now provides tailored reporting capabilities for application
developers, power users, and business users alike within a common
architecture and report format. Read more about it in the
press release
( http://www.pentaho.org/news/releases/20061121_web_based_ad_hoc_query_and_reporting.php ), or
preview the new web-based ad hoc query and reporting tool in a recorded demonstration at
http://www.pentaho.com/products/demos/ .
--------------------------------------------------------------
New Open Source Solution Available: Software Quality Reports For JIRA
--------------------------------------------------------------
We are happy to release another great solution into the open source business
intelligence (BI) arena: Software Quality Reports for JIRA! This is an
extension to the Software Quality Reports for Bugzilla solution.
Software Quality Reports for JIRA/Bugzilla (SQR) provides reports and analysis on top of the very popular
JIRA and Bugzilla issue tracking systems. Implemented as a "solution" built using the Pentaho BI Suite, it
provides an end to end solution for delivering valuable software quality information to product managers, project
managers, development managers, and software engineers.
Software Quality Reports includes:
• Extract Transform and Load (ETL) Mappings
• ETL Jobs
• Reporting Data Models (ie, Dimensional Models, staging tables, summary tables, aggregates)
• OLAP Schema Definitions
• Operational Reports
• Analytic Reports
Take a look at SQR for JIRA today at http://sourceforge.net/projects/qareports/ .
Post your comments and feedback in the project forums at http://sourceforge.net/forum/?group_id=172805 .
--------------------------------------------------------------
--------------------------------------------------------------
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives at http://community.pentaho.org/newsletter/archive.php .
Email: communityconnection@pentaho.org
Forums: http://forums.pentaho.org
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
2006-11-28 20:32:38 UTC by gmoran-pentaho