Extracts data from a preconfigured JDBC database.
You can configure JDBC data sources in the ARIS Connect Administration. See Add a JDBC data source for dashboards for details.
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>. |
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. See SQL statement parameters for details. |
Expand ( Collapse ( |
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. |