...
To create a new Reference Data profile configuration, click the New Configuration button button in the upper left part of the Desktop window, and then select Reference Data Profile from the menu.
...
| Setting | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Database | This is the database the agent will connect and send data to. Click the Browse... button to get a list of all the database profiles that are available. For further information see 8.6 Database Profile. If changes have been made in the selected database selected, click the Refresh button to display the updated data in the retrieve updated db metadata that will be reflected in the table selector when adding entries into the Tables section of the configuration dialog. The Reference Data profile is supported for use with Derby, Oracle and PostgreSQL databases. | ||||||||||
Enable Enhanced Logging | When you perform any of the following operations, entries are written to the System Log, and DB Ref event notifications are generated:
Select Enable Enhanced Logging to include information about executed SQL statements in the event notifications. For more information about DB Ref events, see 4.3.4 DB Ref Event. | ||||||||||
Table | This is a table in the selected database. | ||||||||||
| Read | Select this check box to enable read access to the selected tables. Users of the profile can query and export data. | ||||||||||
| Write | Select this check box to enable write access to the table data. Users of the profile can insert and import data. If Read is also selected, users of the users can edit existing profile can insert, update, delete and import data. | ||||||||||
| Last Update | Select this check box to enable the Last Update feature. Last Update allows users to add specify two extra columns into in the table that will be used to automatically record the username and timestamp of when an entry was updated.
| ||||||||||
| User Column | This is where you can edit the user column name for the Last Update feature. | ||||||||||
| Timestamp Column | This is where you can edit the timestamp column name for the Last Update feature. |
...
The Reference Data profile - Advanced tab
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||