Description

Uses the Pentaho Metadata Query Language (MQL) to perform a query against Pentaho Metadata.

Inputs and Outputs

MQL - The MQL query to be performed.

Output Name - The name of the resulting output dataset. Following actions can refer to the data set using this name.

MQL Designer

The MQL Designer facilitates the authoring of MQL through the use of a simple to use UI. In order to use the MQL Designer from within the design studio, the action sequence being edited must reside inside a valid pentaho solution. At the root of the solution there must exist a metadata.xmi file that is properly configured.

MQL Preview

The MQL Preview button allows the user to preview the data that will be returned from the MQL Query. For preview to work, the JDBC driver jar file for the database you are trying to use must be in the plugin classpath. At add a new JDBC driver to your plugin classpath, the jar should be dropped into the <eclipse_install_directory>/plugins/org.pentaho.designstudio.editors.actionsequence_x.x.x/third_party/lib directory. You'll then need to edit <eclipse_install_directory>/plugins/org.pentaho.designstudio.editors.actionsequence_x.x.x/META-INF/MANIFEST.MF and add your new jar to the bundle classpath.

Once this is done MQL queries can be previewed.