Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Description

Performs relational database queries using MDX against a Mondrian ROLAP data source.
!sqlquery.png\|align=center,thumbnail!

Inputs and Outputs

Database Connection Type - Specifies the type of connection to be used to connect to the database.

  • JDBC - Connect using a standard JDBC connection. The following inputs must also be provided.
    • JDBC Drive - Name of the JDBC driver class to use when connecting to the database.
    • Database URL - The database connection URL.
    • User Name - The username to use when connecting to the database.
    • *Password - The password to use when connecting to the database.
  • JNDI - Connect using the specified JNDI name. The following inputs must be provided:
    • JNDI Name - The JNDI data source name.
    • Role - The Mondrian role to use with the connection.
  • MDX - Connect using the specified MDX connection string.
  • Shared - Connect to the database using the named shared connection. See the Shared Relational Connection action for further details

Query - The MDX query to be executed.

Run Query - Determines when the query is to be executed. The options are:

  • Immediately - The query is run immediately by the Pentaho BI server.
  • From Pentaho Subreport - The query is prepared for execution, with the intention of being run later in the action sequence by a subreport within a JFree Report. See the JFree Report action for further details.

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

  • No labels