Description

Performs relational database queries using MDX against a Mondrian ROLAP data source.
Image RemovedRetrieves data from XML documents using XQuery query language.
Image Added

Inputs and Outputs

Database Connection Type Source Of XML - 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.
  • Role - The Mondrian role to use with the connection.
• 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 OLAP Connection action for further details

Mondrian Schema File - The location of the Mondrian schema file. This is only needed when using a JDBC or JNDI connection.

Query - The MDX query to be executedsource of the XML that is to be queried.

• XML Document - The XML is located with the specified XML file.
• XML String - The XML is located with the specified XML string.

Query - The XQuery to be performed.

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[studio:Pentaho Report] action.

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