Parameters | Description | ||
Data source | List of available JDBC connections | ||
Refresh rate () | Specifies the time until the source file is read in again. Default value is 30 sec. | ||
SQL query | Input field to enter any SQL query command. e. g. SELECT * FROM <table name>
| ||
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. | ||
Parameter options () | Enables you to set input parameter options | ||
Authentication | Specifies a HTTP basic access authentication or an existing authentication defined in the Business Analytics administration. User name and password are required for accessing the source file. | ||
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. |