Forms: Database Collector
A Database Collector reads data from a PhixFlow Datasource. It holds the SQL that will be sent to the datasource to retrieve data.
The query columns must match up to any Streams saving the data.
Form: Database Collector Details
The following fields are configured on the Details tab:
...
| Field | Description |
|---|---|
| Description | A description of the database collector. |
Form Icons
The form provides the standard form icons as well as the following:
Creates a new Stream with the attributes implied by the query. The new Stream will be shown on the modelling pane connected to this Database Collector. To use this feature, the supplied query must be pure SQL i.e. should not contain embedded expressions (as described above). PhixFlow wraps the query with a "where 1= 0" to avoid a long running statement. | |
Clicking this icon runs the SQL and pops up a Data Grid showing the first page of returned data. |