...
- 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 Relational OLAP Connection action for further details
...
- 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 Pentaho 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.