JDBC

Parameters

Description

Data source

List of available JDBC connections

Only JDBC connections for that you have the Usage privilege are available. Select a JDBC connection. See Manage data sources and drivers for details.

Refresh rate (

)

Specifies the time until the source file is read in again. Default value is 12 h.

SQL query

Input field to enter any SQL query command.

e.g., SELECT * FROM <table name>

Note:

Technically, execution of DDL (data definition language) and DML (data manipulation language) commands, such as create or insert is not prohibited, however, we recommend that you do not run this type of command with MashZone NextGen. To minimize the risk of accidental changes to the database schema used, we recommend accessing the database schema via a role or user with only a read-only privilege.

Insert parameter (

)

Inserts user defined input parameters at cursor position. The button is only clickable if at least one user input parameter, e.g., Text user input, has already been inserted in the feed definition.

Note:

A textual representation of your input parameter will become part of the SQL statement. This may lead to the execution of harmful SQL code or exposure of data, especially if the parameter is of type text and depends on arbitrary user input. It is strictly recommended to only use parameters which can be guaranteed to be harmless if inserted into the SQL query.

Parameter options (

)

Enables you to set input parameter options

Authentication

Specifies a HTTP basic access authentication or an existing authentication defined in the MashZone NextGen administration.

User name and password are required for accessing the source file.

Expand (

) / Collapse (

)

Expands or collapses the SQL query input box.

Configure columns

Configures the columns list. Unselect a column for excluding it from the result data. Entering a New name for a column will cause that to be used instead of the original column name in the result. Clicking Reset columns will reload the column list from the data source and undo all changes in the list.