In a Reference Data profile configuration, you can select the tables that should be available for query and editing via the Reference Data Management dashboard, or RESTful interface. For information about these interfaces, see the Reference Data Management Dashboard or RESTful Interface for Reference Data Management.
...
To create a new Reference Data profile configuration, click the New Configuration button from the Configuration dialog available from Build View, and then select Reference Data Profile from the menu.
The contents of the menus in the menu bar may change depending on which configuration type has been opened in the currently active tab. The Reference Data profile uses the standard menu items and buttons that are visible for all configurations, and these are described in Common Configuration Buttons.
To open an existing Reference Data profile configuration, click on the configuration in the Configuration Navigator, or right-click on the configuration and then select View Configuration.
...
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 Database Profile. If changes have been made in the selected database, click the Refresh button to retrieve updated db metadata that will be reflected in the table selector when adding entries into the Table Tables section of the configuration dialog. The Reference Data profile is supported for use with 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 DB Ref Event. |
Tables | Configurations of selected tables are listed here. |
...
In the Advanced tab, you can configure additional properties. You can use these parameters to tune the performance of database operations.
...
| Info |
|---|
Info!prefetchSize determines the maximum number of records that can be exported via the Reference Data Management UI. |
...