Targets H

Targets V

Use this page to Register Targets.

To access this page, click Collect > Targets in Navigation pane.

Targets V

Targets H

This page has two tabs:

General tab

Use this tab to Register Targets.

Field

Description

Target

Displays database where tables are refreshed with source data.

Connection Type

Displays valid database connection type from source to target. Connection Types are configured under Configuration > Connection Types.

Schema Owner

Displays the schema of the target database that contains the tables. The Schema Owner doesn’t have to match database user ID.

Collation Type

Displays language option for text data in the target  database.

Values are: General Latin Case-insensitive, General Latin Case-sensitive

Default value is General Latin Case-insensitive, which means the collation uses Latin characters and is case insensitive.

Refresh Index Option

Displays the options to build indices or the primary key of registered tables. Select an option to increase download and network performance.

Values are: Build Indices and Primary Keys, Build Indices only, Do Not Build Indices and Primary Keys. Default value is Do Not Build Indices and Primary Keys.

Description

Displays additional information about the target, e.g., DBA or business contact information, or when the target can be deleted from server.

Data Services ID

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to view data service configuration, which is managed in Common > Configuration > Data Source Registry.

Sources

Click to open the Target Sources page to register source database where data is refreshed from and stored in the target.

General Information

Refresh Started On

Displays date and time when the manual refresh started.

Refresh Completed On

Displays date and time when the manual refresh completed.

Test Connection Status

Displays results from the most recent test connection, either from the Service page or when the Test Connection icon was clicked

Test Connection On

Displays date and time of most recent test connection.

Action

Build Index

Click to schedule the rebuild process for all indices in the Target Source Table index. Only registered indices and keys are rebuilt.

Reset

Click to reset a running refresh. This process activates the Refresh icon and triggers the batch job schedule to calculate new run dates for next scheduled refresh. Reset doesn’t impact processes currently running. Reset the target if download process backs up due to network problems.

Data Protection

Use this tab to: