Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SettingDescription

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:

  • Commit changes to the database
  • Perform import operations

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.

Info
titleInfo!

Manually editing the User and Timestamp column from the Reference Data Management web UI is disallowed.


Info
titleInfo!

When creating tables to include the User column and Timestamp column, ensure that these columns are not UNIQUE and does not have any PRIMARY KEY constraints.

The datatype for the user column should be set as VARCHAR and datatype of the timestamp column should be set as TIMESTAMP.


User ColumnThis is where you can edit the user column name for the Last Update feature.
Timestamp ColumnThis is where you can edit the timestamp column name for the Last Update feature.

...