Collect

Targets H

Targets V

Use this page to Register Targets.

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

Field

Description

Test Connection

Click to test the connectivity to a data source, which verifies the database User ID and Password login is connected to the target database. Does not test the validity of the SAP login credentials or DSN connection.

Refresh

Click to manually extract a copy of data from all registered sources and load into target. 

NOTE: If the data in the target has been purged manually, or the retention expiration date for that object has passed, it cannot be refreshed and this icon is inactive. Refer to Purge Data for more information.

TARGET

Displays database target where tables are refreshed with source data.

CONNECTION TYPE

Displays valid database connection type from source to target. Connection Types are configured under Administration > 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.

Sources

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

Metrics

Click to open the Target Source Metric Charts page to view monthly, weekly and daily download results for target/source combination.

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 Administration > 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

Queue ID

Displays queue used for all Collect table downloads under the selected target.

To prevent processing backlogs and inefficient Stewardship Tier usage during the execution of large Collect refreshes, the queue ID can be set at the target, target source, or table level. Refer to Assign a Queue to a Refresh for more information.

If this field is blank, the Stewardship Tier assigns the queue ID in this priority order:

1. Target source table

2. Target source

3. Default (set on the Parameters - Collect page)

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

Field

Description

Data Controller

Displays the user responsible for the processing of personal data in the target.

Any user or group who is assigned the Data Controller role must have a user account in the Stewardship Tier. Data Controller must have access to the target based on their assigned security role and security key.

NOTE: The Collect Administrator must check the WORK FLOW SUMMARY check box for the target and Data Controller on the Workflow Summary User Settings page. The Data Controller is added to this page automatically. If the check box is not checked, the Data Controller will not receive a warning email that data is going to be purged.

Data Classification

Displays the nature of the data in the target, identifying whether a target contains personal data and so must be purged.

Options included with the Stewardship Tier are:

  • Personal — This object contains data that must be purged by a certain date. The Retention Expiration Date field must be completed for this object (for example, Customer Addresses, Employee Records, Business Partner Tax IDs).
  • Public —This object contains data that does not need to be purged (for example, Units of Measure, Material Descriptions, Country Codes).
  • Restricted — This data does not need to be purged, but is marked as restricted access (for example, Company Chart of Accounts, Recipes, Work Orders).

NOTE: These options are delivered with the Stewardship Tier and cannot be updated; however, a Common Administrator can create custom classifications on the Data Classification page in Common. Refer to Add Custom Data Classifications and Information Types for more information.

Retention Expiration Date

Displays the date when the data in the target, target sources, and tables will be automatically purged when a Service page runs.

A Collect Administrator must enter a date for a target with a data classification of Personal or for any custom classification with the Retention Period Warning feature enabled.

A different retention expiration date can be set at the target source and table level.

If no date is set for the object, the data is not purged.

NOTE: Updates to this field are audited. An e-signature is required.

NOTE: Once this data has passed, the Refresh and Build and Refresh icons on the this page, and the Target Sources, and Tables pages are inactive. The target can no longer be refreshed either manually or automatically.

Data Collection Reason

Displays reason for extracting the data. Any time the target is processed, the data should only be used for the reason identified in this field.

Purge Data

Click to manually delete all data in all tables (including check tables) at the target, target source, and table levels.

NOTE: Data is automatically purged on the Retention Expiration Date when a Service page runs once daily.

NOTE: After data is purged, the table(s) cannot be downloaded again for the target, and the Collect refresh will not pull data into the table. The Refresh and Build and Refresh icons on the Targets, Target Sources, and Tables pages are inactive.