...
The query columns must match up to any Streams saving the data.
...
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
The following fields are configured on the Details tab:
| Field | Description | |||
|---|---|---|---|---|
| Name | Name of the database collector. | |||
| Datasource | The datasource that this database collector will collect from. | |||
| Query String | Query toStatement Expression | 1570898204 to be processed by the database collector to retrieve data from the database. | ||
| Allow Non-Scheduled Collection | If this is turned on, then the database collector will run as part of any ad-hoc Analysis Engine run which requires this data. If not, it will only run as part of a scheduled Task Plan under the Analysis Engine. | |||
| Enabled | Tick when the configuration is complete and the database collector is ready to be used. | |||
| Advanced | ||||
| Timeout | A timeout for the query. | |||
| Datasource Instance Expression | The datasource to which this database collector is connected may list multiple database instances from which the data may be read. Each Datasource Instance is identified by a unique string. This expression should evaluate to a plain text string which allows the database collector to determine the specific instance to use. If the expression is blank then the database collector will assume that there is only one instance and will use that one by default. If there is more than one instance and no expression is provided here then an error will be thrown during analysis since the database collector will be unable to determine which instance to use. | Allow Non-Scheduled Collection | If this is turned on, then the database collector will run as part of any ad-hoc Analysis Engine run which requires this data. | If not, it will only run as part of a scheduled Task Plan under the Analysis Engine.|
| Description | ||||
| Description | Optional: A description of the database collector. | |||
...
Note the use of directly entering a PhixFlow Expression into SQL to calculate values. Expressions must be surrounded by curly braces i.e. start with a '{' and end with '}' and take the form of a standard PhixFlow Expression . In the example above the from and to dates of the stream period are referenced through the special Internal Variables .
If the dates include a time element, use the query string:
...
| Anchor | ||||
|---|---|---|---|---|
|
HELPDEVTODO - not yet in property editor or hover menu
Clicking 
runs the SQL and pops up a Data Grid showing the first page of returned data. It is not necessary to save the query to use this option.
...
From the hover menu from a database collector on a Model View, clicking creates a new Stream with the attributes implied by the query. The If the Datasource Instance Expression has been entered then the expression will be used to select the datasource, otherwise the first Datasource Instance alphabetically will be used. The new Stream will be shown on the modelling pane connected to this Database Collector.
...
PhixFlow wraps the query with a "where 1= 0" to avoid a long running statement.
Form Icons
HELPDEVTODO - only generate stream icon currently viewable only in hover menu
The form provides the standard form icons as well as the following:
...
...
...
See Also
...