Forms: Datasource
The Datasource defines a connection to an external database.
For an introduction to datasources, see Collecting Data from a Database and Exporting Data to a Database.
Form: Datasource Details
The following fields are configured on the Details tab:
| Field | Description |
|---|---|
| Name | Name of the datasource. |
| Enabled | Tick when the configuration is complete and the database collector is ready to be used. |
| Driver Class | The driver used to access the source database. Drivers will be implemented for each underlying database technology, e.g. Oracle, MySQL. |
| Anonymous Export Allowed | When 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 Export |
When this flag is ticked, the current logged in user's own PhixFlow 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:
|
The following fields are configured through separate tabs on the form:
| Field | Description |
|---|---|
| Datasource Instances | See the Datasource Instance Details form. |
| Description | Description 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. |