PDA

View Full Version : Using definition from the metadata editor



dogfuel
05-04-2007, 06:07 PM
I understand the priority is to source data for the Pentaho Reporting/Anaylsis/Ad-hoc tools, but is there any plan to present the business views as a datasource to other tools?

Easier said than done, but the ability to write queries against the abstract business views designed in the MD tool (addressing it as a JDBC data source???) would change the world.

MattCasters
05-05-2007, 06:38 AM
Everything is present in the metadata to make information available through standard JDBC connections and SQL.
That info is even stored in the CWM model.

We are also working on a way to execute selections as Transformations and go from there.
There have been plans to put a JDBC driver over a transformation, but I'm no big fan and nobody seems to want it.

Matt