This page is for data modellers who want to connect to an external database, either to load data or to export processed data back to a database.
...
- a name
- a driver class. This should match the type of datasource you are connecting to, e.g. Oracle; see Driver Classes.
- The protect during import flag can be used to prevent this datasource being updated or deleted during import.
To prevent orphaned datasources, when a parent application is deleted by the import, its datasources will also be deleted. - Remember to set the enabled flag to make the datasource active.
- Most importantly, ensure you have configured at least one datasource instance.
The toolbar has the standard icons and
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
For information about other property tabs, see Property Tabs.
Basic Settings
| Field | Description | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Name | Required. Enter the name for this datasource object. You will use this name to specify this datasource object in other collector and exporter objects. | ||||||||||||||||||
| Enabled |
| ||||||||||||||||||
| URL | Enter the URL to connect to the datasource; see Connection URLs below. what | ||||||||||||||||||
| Allow Anonymous Export | For datasources connected to an exporter being run by a task, such as a scheduled task. The target database must permit anonymous updates.
The datasource can only use the logged in user's credentials (see Use user credentials below). | ||||||||||||||||||
| Use User Credentials on Export | For datasources connected to an exporter being run interactively, when a user clicks
| ||||||||||||||||||
| Protect during import |
| ||||||||||||||||||
| Password | Password for connecting to the datasource with the Anonymous Username. I've ticked Allow Anonymous, and Use User, but I'm not seeing any fields where I can specify which user credentials to use. This option has gone. | ||||||||||||||||||
| Driver Class | Select the driver class for the type of database to which the datasource object connects.
|
...