Over the next few weeks, part of the engineering team at Pentaho will be working towards making it easier to get access to your data. The two use cases we’re addressing in the short term include accessing your SQL data, along with uploading a flat file (CSV, Excel) to drive a report or chart from within Pentaho’s user console. Our general approach for both of these scenarios is to use Pentaho’s Metadata layer to abstract the querying of data sources. This allows us to use a common interface and common widgets in our client apps. To do this, we’ll be extending Pentaho Metadata to include new physical model implementations. The team has started to prototype some of these capabilities. We’ve added a web services layer to Pentaho Metadata, and also have started work on the physical models as well as our common widgets, which use our Java / GWT XUL UI framework.
We’re also spending a lot of time thinking about the long term direction of our metadata layer. I’ve created a community project page for the Metadata project, with links to documentation, binaries and source to make it easier to get involved in the project. Doug will be hosting a live community webex in the next couple of weeks to have a general conversation about where we should take the metadata layer. We want to make it as easy as possible for folks to start using Pentaho, and we’re going to make that possible through our rich and easy to use metadata layer.