Skip to end of metadata
  • Created by Former user, last modified by Former user on Sept 13, 2007
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 6 Next »

Overview

The SQL Query Action executes SQL queries against relational databases.
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.

Result Set Type - Specifies the type of result set to use when returnin the query results. The options are:

    • Live Result* - The query results are fetched from the dabase server on an as needed basis using a data set cursor. This is the preferred option when the data sets being returned are expected to be very large. Performance is slower but memory usage is reduced.
    • In-Memory Result Set - The query results are returned in their entirety from the database server and cached on the BI server.
      Query - The SQL query to be executed.
      Password - The password to use when connection to the database.
      JNDI - Connect using the specified JNDI name.
      Shared - Connect to the database using the named shared connection. See the Relational Connection Action for further details
      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.

RTFM

  • No labels