Collect

Use Advanced Options

Advanced Options in Collect are features that can be useful in a data migration, depending on the scope and nature of the project.

Advanced Options include:

Manage SAP Text List

SAP Text tables must be registered in Collect in order for text tables to function properly with the Stewardship Tier. SAP Text extracts are used to download text lines, for example, for material and sales orders.  Registering SAP Text tables allows users to create custom downloads of this table type.

To create custom downloads:

  1. Select Administrative > SAP Text Lists in the Navigation pane.

  2. Click Add.

    View the field descriptions for the SAP Text List page

  3. Enter SAP Text table name in TABLE field.
  4. Enter object for table in TEXT OBJECT field if an object is used.
  5. Enter object key for table in OBJECT KEY field if a key for the object is used.
  6. Enter text ID for table in TEXT ID field if an ID must be specified.
  7. Enter default language in LANGUAGE field if the language must be specified.
  8. Click Save.
  9. Click Vertical View to further configure the SAP Text List.

  10. Click Edit.

    View the field descriptions for the SAP Text List page's Vertical View

  11. Enter SQL used to build the custom table in Build SQL Command field.
  12. Enter SQL used to alter the table SQL command used to build primary keys for table in Build Primary Key field.
  13. Click Save.
  14. Add table to the Target Source. Refer to the Register Tables to Source section for more information.

Manage Syniti Data Replication Table Rules

Syniti Data Replication rules remove the leading zeros using a script built into Collect package build process. These entries can be made active or inactive. Entries can be added for custom SAP tables or tables not in the Syniti Data Replication supplied list (Administrative > DBMoto Table Rules where Stewardship Tier Supplied is enabled).

To run Syniti Data Replication Table Rules:

  1. Select Administrative > DBMoto Table Rules in Navigation pane.

  2. Click Add.

    View the field descriptions for the DBMoto Table Rules page

  3. Enter source table in TABLE field.
  4. Enter column name to include in rule in COLUMN field.
  5. Enter function to apply to rule in DB MOTO FUNCTION field.
  6. Verify ACTIVE check box is enabled, allowing Collect to include the field in the build package process.
  7. Click Save.

View Build Skip SPRAS Table List

Language tables and international clients do not want SPRAS filters put on view for tables. This page provides a user with a configurable entry point to control which views will not contain a language filter.

To skip filters:

  1. Select Administrative > View Build Skip SPRAS Table List in Navigation pane.

  2. Click Add.

    View the field descriptions for the View Build Skip SPRAS Table List page

  3. Enter table to include on SPRAS filters in TABLE NAME field.
  4. Click Save.

Collect includes this table for SPRAS filters on the Build View process in both basic and advance build modes.

View Workflow Download Failures

Collect can send workflow emails to notify users when a table download fails. To configure users to receive this email, an Administrator must add users to a security role in System Administration. This security role must have access to the WebApp group WorkFlowFailureAll or WorkFlowFaiureByTargetAccess. Refer to Set Security in System Administration for more information.

To view workflow emails for table download failures, select Administrative > Workflow Download Failures in the Navigation pane.

NOTE: To receive a workflow email that a table download has failed in Collect, a user must be assigned to a security role that has the Collect WebApp group WorkFlowFailureAll or WorkFlowFaiureByTargetAccess assigned. Refer to Set Security in System Administration for more information.

Configure Workflow Summary User Settings

Users receive workflow emails as notifications for various processes, such as when a table fails to download or when a table completes a download. The summary email is sent once daily at a user selected time, but can be sent on demand. Refer to Send Workflow Summary On Demand for detailed information.

To configure workflow summary settings for a user:

  1. Select Administrative > Workflow Summary User Settings in Navigation pane.

  2. Click WORK FLOW SUMMARY check box for the TARGET and USER NAME combination to enable the summary for that user. 

Send Workflow Summary On Demand

The workflow summary email is sent to users with WORK FLOW SUMMARY enabled on the Workflow Summary User Settings page once daily. However, this summary email can also be sent on demand.

To send the workflow summary email on demand:

  1. Select Administrative > Build Summary Workflow in Navigation pane.

  2. Click Build Summary Workflow.

The Workflow Summary Time displays the next date and time when the summary email is scheduled to send. This date and time can be modified as needed.

To modify the date and time when the workflow email will send next:

  1. Select Administrative > Build Summary Workflow in Navigation pane.

  2. Click Edit.

    View the field descriptions for the Build Summary Workflow page

  3. Update the Workflow Summary Time field.
  4. Click Save.

View Workflow Summary History

If users opt to not receive the workflow summary emails, the emails can be viewed from within Collect.

To view summary workflow emails, select Administrative > Workflow Summary History in the Navigation pane.