datasource

Forms: Datasource

The Datasource defines a connection to an external database.

Form: Datasource Details

The following fields are configured on the Details tab:

FieldDescription
NameName of the datasource.
EnabledTick when the configuration is complete and the database collector is ready to be used.
Driver ClassThe driver used to access the source database. Drivers will be implemented for each underlying database technology, e.g. Oracle, MySQL.
Anonymous Export AllowedWhen this flag is ticked, the datasource can be used by an exporter as part of the work done in executing a task e.g. when processing a scheduled task. In this mode, the datasource will use the configured anonymous username and password. If anonymous export is not allowed, the datasource cannot be used by an exporter during the execution of a task. The datasource can only use the logged in user's credentials (see Use user credentials below).
Use User Credentials on ExportWhen this flag is ticked, the current logged in user's own CenterView username and password will be used to connect to the target database when an exporter is used interactively. Note that this means that the username/password must be set up on the target system by a Database Administrator. Please note: there are two other configuration items that affect datasource behaviour:
  • Privilege 'Allow anonymous updates on datasources'. Only a user with this privilege can modify the 'Anonymous export allowed' flag on a datasource.
  • System Configuration. parameter 'Allow anonymous export by default'. This causes the 'Anonymous export allowed' to be true by default on all new datasources.

The following fields are configured through separate tabs on the form:

FieldDescription
Datasource InstancesSee the Datasource Instance Details form.
DescriptionDescription of the datasource.

Form Icons

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

Adds a datasource instance to the list. See the Datasource Instance Details form.

Deletes the selected datasource instance from the list.

Shows the list of tables visible for this datasource using the default login details. See the Table Details form.

See Also