JDBC

Extracts data from a preconfigured JDBC database.

You can configure JDBC data sources in the MashZone NextGen Administration. For details, see Manage data sources and drivers.

The following parameters are available.

Parameters

Description

Data source

List of available JDBC data sources.

Only JDBC data sources for which you have the required privilege are available.

Select a JDBC data source.

Refresh rate ()

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

SQL query

Input field to enter any SQL query command, for example, SELECT * FROM <table name>.

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 (Insert parameter)

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

For details, see RAQL and SQL statement parameters.

Expand (Expand)/

Collapse (Collaps)

Expands or collapses the query input box.

Authentication

Specifies an HTTP basic access authentication.

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

Configure columns

Configures the columns list. You can unselect a column to exclude it from the result data. If you enter a new name for a column, this name is used in the result instead of the original column name. If you click Reset columns, the column list is reloaded from the data source and all changes in the list are undone.