Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following fields are configured on the Details tab:

FieldDescription
NameName of the database collector.
DatasourceThe datasource that this database collector will collect from.
EnabledTick when the configuration is complete and the database collector is ready to be used.
Allow Non-Scheduled CollectionIf 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.
Datasource Instance ExpressionThe 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.

The following fields are configured on the Query String tab:

FieldDescription
Query StringQuery to be processed by the database collector to retrieve data from the database.

The following fields are configured on the Description tab:

FieldDescription
DescriptionA description of the database collector.

Anchor
dbCollectorQueryString
dbCollectorQueryString

...

Code Block
{="'" + _out.CustName + "'"}

Similarly dates in expressions preceded by = must be formatted as required by the syntax of the source database.

...

The form provides the standard form icons as well as the following:

See Also