View Full Version : Documentation

11-22-2006, 07:26 AM
Is there any documentation for the Metadata or Ad Hoc Query tools? I did not see any in the downloads area.


11-22-2006, 09:35 AM
Hi Jason,

you'll find documentation for the metadata tool in the docs folder of the distribution after you unziped it.

I don't know about the adhoc query tool.

Berst regards,

11-22-2006, 10:44 AM
Thanks. I found the documentation and started reviewing it. Everything looks OK until the section on Publishing a MetaData Model where it states that it requires Pentaho Reporting - Web Based Adhoc Query and Reporting 1.5.1 milestone release. I have not seen this anywhere. Do you know where I can find it?

11-23-2006, 12:17 AM

from what I understand of all the press releases, FAQs etc. this is the situation:

The ad hoc query tool, which uses the meta data layer, will be a professional offering and right now only a flash demo is available to the public.
(Ad hoc query tool FAQ http://community.pentaho.org/faq/waqr_faq.php)

The other reporting tools (Designer etc.) do not support the meta data layer at this time, but will in the near future. (Meta Data FAQ http://community.pentaho.org/faq/pentaho_metadata.php)

What you can do so far, in the open yource version, is to download the Metadata Editor and test it for features and bugs to support its development process. That will ensure that a good editor is available once the meta data layer becomes usable in the reporting tools.

Maybe Pentaho wants to clarify if I stated the situation correctly.

Best regards,

11-23-2006, 12:38 AM
Absolutely Ingo, that's pretty much the situation. I'm sure if it weren't thanksgiving hollidays in the US, we would have had many more reactions on this subject.

If any feedback exists on the subject of Pentaho metadata or the metadata editor, feel free to contact me as I'm the guinea pig that wrote that stuff.

All the best,

Matt (mcasters at pentaho dot org)

01-02-2007, 12:38 AM
I thought it was too good to be true until I hit "Note: Requires Pentaho Reporting - Web based Adhoc Query and Reporting 1.5.1 milestone release". Any plans to add this to the open source product?

Some feedback for the next release: import relationships using the foreign keys defined in the DB; import table and column comments from the database and add related metadata fields for the corresponding meta data objects. Also, I wasn't able to utilize an existing JNDI data source for an Oracle DB (your application froze). JDBC was ok.

Since you are using the CWM...any plans to import EUL from discoverer, project from MSTR, universe from BO, or catalog from cognos? not sure if it is possible or worthwhile, but wondered if you thought about that possibility.



01-02-2007, 08:44 AM
Hi Chris,

We are actually in the process of building a revised plan for Pentaho Metadata (& Editor) and I will put your feature requests on the list.

The good news is indeed that we use CWM, the bad news is that we use CWM and that this in fact means that the data probably can't be imported just like that.
That being said, there are already a partner working on a bridge from BO. (native, not through CWM)
Once that is done, the next platforms would probably be easy too.

If anybody wants to play with the Pentaho Metadata API, I created an eclipse test project (PMDTest) to show the possibilities.
You can download it over here: PMDTest.zip (http://www.kettle.be/dloads/PMDTest.zip)

All the best,


01-13-2007, 04:15 PM
Thanks for your reply Matt. This reply came at right time when I was evaluating Kettle followed by MetaData Editor.
I was wondering whether it is too difficult to integrate MetaData Editor with Spoon?

I would like to use the the Metadata Editor to define the business views from physical tables and use Spoon for any additional transformation. Finally use the Kitchen/Pan to export the data as per the business views.

Is it possible provide directions on these integration solutions among these tools?


05-05-2008, 05:47 AM
I was creating a domain using Metadata Editor and the domainl finally consisted of 10 business models.I wish to save it now and import it as an xmi and perform reporting tasks.But as the domainl is quite huge,it is not getting saved even after taking a lot of time.Does Metadata Editor support huge domains?Can you please throw light on this issue.


05-05-2008, 09:33 AM
Divya, don't hijack threads.

As for your problem: try to give the editor a bit more memory to work with.


05-08-2008, 02:41 AM

Sorry for posting multiple threads and thanks for the reply. Can you please suggest me as to how to allocate more memory to the Pentaho Editor?I've tried increasing the virtual memory as the disk has enough space. I have also increased the memory option in the Meta Editor Batch file. But, the domain is not getting saved.Can you please help me out with this.