PDA

View Full Version : Problem about connection with multi schemas.



Amber
04-26-2008, 12:02 AM
Our tables are located in many schemas, and I want put them in one business module, but PME(Pentaho Metadata Editor) has the limitation of one business module can only contains tables from the same connection. I use the SQL tab of Connection property dialog to execute a set schema SQL statement to set a default schema for the connection, or I get errors when importing physical tables, even after doing this I still can't import tables in schemas other than the default one.

MattCasters
04-26-2008, 08:09 AM
This issue has been fixed for a while now:

http://forums.pentaho.org/showthread.php?t=58221