The Datasource defines a connection to an external database. You need to define at least one of these in order to push and pull data to and from external database systems.
It has a name and a driver class (which should match the kind of datasource you are connecting to, e.g. Oracle, MySQL, SQLServer etc.). The protect during import flag can be used to prevent this datasource being updated or deleted during import. Remember to set the enabled flag to make the datasource active. Most importantly, ensure you have configured at least one datasource instance.
...
A Datasource Instance defines connection details to a database. A number of instances can be defined to allow for several connections under a single Datasource. At least one Datasource Instance must be defined for each Datasource.
| Field | Description |
|---|---|
| Name | Name of the Datasource Instance. Used to identify the datasource instance in collectors and exporters. |
| URL | URL to connect to the datasource. See example connection strings below. |
| Anonymous Username | Username for connecting to the datasource when the credentials of the PhixFlow user should not or cannot be used, for example in a scheduled task plan. |
| Password | Password for connecting to the datasource with the Anonymous Username. |
| Advanced | |
| Check Query | See Advanced Configuration below. |
| Description | A description of the datasource instance. |
A datasource instance has must have a name, a URL, and a username and password used to connect to the external datasource. The URL should be in one of the following formats:
...