System Configuration Options (2.9)

This page describes additional configuration options and how to modify them.

Modifying Settings

To modify settings:

Click the Management icon in the application menu.
In the General section, click System Configuration.
The page then displays the current values for the settings.
Below the Settings headings, there is a list of names, each of which corresponds to a group of related settings.
Optionally click a group name to quickly scroll to that group.
Make edits as needed. See the reference information later on this page.
Click Save.
Or click Revert to cancel your edits.

The Business Scheduler group includes one setting:

Enabled—Specifies whether the Business Scheduler is enabled; this tool enables data engineers to run recipes, run snapshots, and build cubes.

The Data Loader group includes the following settings:

Delta Schema Prefix—Specifies the schema prefix to precede any tables used to track staging deltas.
File Import Minimum Rows—Specifies the minimum number of rows required for a file to be loaded, excluded the header row if any.
Max Permissible Columns In Schema—Specifies the maximum number of columns that a table can have when loaded.
Snapshot Data Retention In Days—Specifies the number of days for which a snapshot will be kept until it is deleted. Use –1 to retain snapshots indefinitely.
Staging Data Retention In Days—Specifies the number of days for which staging data will be kept until it is deleted. Use –1 to retain staging data indefinitely.
Staging Schema Prefix—Specifies the schema prefix used for the names for all staging tables. Changing this has no effect on previously generated tables.

The Recipes group includes the following settings:

Dropped Records Report Path—Specifies where to generate reports about dropped records.
Dropped Records Report Retention In Days—Specifies the number of days for which a dropped records report will be kept until it is deleted. Use –1 to retain these reports indefinitely.
Max Dropped Records—Specifies the maximum number of records to drop when using SQLQuickLoad before reverting the load.
Reconciliation Report Path—Specifies where to generate reconciliation reports.
Reconciliation Report Retention In Days—Specifies the number of days for which a reconciliation report will be kept until it is deleted. Use –1 to retain these reports indefinitely.
Reconciliation Report Row Count—Specifies the number of rows to be sampled for every failed reconciliation rule when generating the reconciliation report.
Validation Report Path—Specifies where to generate validation reports.
Validation Report Retention In Days—Specifies the number of days for which a validation report will be kept until it is deleted. Use –1 to retain these reports indefinitely.
Role For Pending Index Build Tasks—Specifies the workflow row to receive workflow tasks for pending index builds.

The Snapshots group includes the following setting:

Snapshot Schema—Specifies the prefix used for the first part of the name for all snapshot tables. Changing this has no effect on previously generated tables.

The Streaming group includes the following setting:

Persister Table Projection Timeout—Specifies the maximum length of time to wait (in seconds) for a table projection to occur before streaming data into the table. If the table is not found within this timeout period, streaming does not occur.

The System group includes the following settings:

Connector Temp Files Base Path—Specifies where data connectors will store files before loading them. Applies to only some connectors.
Logs Retention In Days—Specifies the number of days for which entries in the Messages Log kept until they are deleted. Use –1 to retain Message Log entries indefinitely.
Session Timeout In Minutes—Specifies how long to wait for user action on a page before a refresh is required. This option applies only to pages that automatically poll the server, such as the Business Scheduler Dashboard.