Description

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

Click to build the package and download the table from the source. If the package name already exists for the table record, the table is refreshed (i.e., data is downloaded from the source database). If the package name does not exist, a package is immediately scheduled to be built and the table is refreshed. The Refresh icon is disabled for DBMotoMirror package type because the refresh is run by DBMoto® instead of Collect.

NOTE: If the data in the target source 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.

Click to import system group tables from Common to facilitate adding sources.

Click to build the package that downloads tables from the source.

NOTE: If the data in the target source 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.

Click to download the tables from the source.

NOTE: If the Target Source uses an IG Universal Connect data source, clicking Refresh executes the Boomi Process.

NOTE: If the data in the target source 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.

Displays database where data is refreshed from and stored in the target. Source is configured when adding a data source in System Administration.

Displays valid database connection type from the source to the target.

Displays name of the System Type if importing group tables from a System Type delivered in Common.

NOTE: Click the + icon to open the System Types page in Common in a new tab to add a System Type, if needed.

Displays the schema of the source database that contains the tables. The SCHEMA OWNER doesn’t have to match database user ID. Default value is dbo

If enabled, the source is active. Only tables from active sources are downloaded during the refresh process. The default value is Active.

Click to open the Tables page to add, edit and delete tables for a source.

Click to open the Target Source Group page to build packages, refresh or filter on tables in a group.

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

Description

Click to build a package that downloads tables from the source.

NOTE: If the data in the target source 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.

Click to download the tables from the source.

NOTE: If the Target Source uses an IG Universal Connect data source, clicking Refresh executes the Boomi Process.

NOTE: If the data in the target source 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.

Displays database where data is refreshed from and stored in the target.

Displays valid database connection type from the source to the target. Connection Types are configured under Configuration > Connection Types > Sources. Default value is SQLSERVER.

Displays the schema of the source database that contains the tables. The Schema Owner doesn’t have to match database user ID. Default value is dbo.

Displays additional information about source, for example, DBA or business contact information.

Displays name of the System Type if importing group tables from a System Type delivered with Common.

NOTE: Click the + icon to open the System Types page in Common in a new tab to add a System Type, if needed.

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

Displays date and time of the most recent test connection.

Displays date and time when the manual refresh started.

Displays date and time when the manual refresh completed.

Description

Displays table name of the renamed table in the target database. At run time, “<TableName>” is replaced by the processing table name.

Displays schedule for when target tables are refreshed with source data. Options are controlled in Common > Configuration > Schedules. Default value is Do Not Download any tables.

If enabled, primary key indices are refreshed from non-SAP sources.

If enabled, all previously refreshed tables are deleted and tables (and primary keys and indices) are rebuilt each time the package is built. This setting ensures the most recent table schema is downloaded. Default value is Disabled.

NOTE: It is recommended that the Delete Target Table On Build check box be disabled if the package type to download table data is set to SAP Data Services. In this case, if the check box is enabled, dspCompose™ WILL delete every record in the target table during the Final Finish process (during which data posted in the target ERP system by the request is downloaded to tables).

Data Services

If enabled, the data is NOT deleted before it is refreshed when the Refresh icon is clicked on the horizontal view. Data Services must be set to CDC (Change Data Capture) for each table in the source.

Displays database connection type when using Data Services.

Click to open the Target Sources - DataServices Connection page to edit the database connection settings for Data Services.

Boomi

Displays the name of the IG Universal Connect data source registered in Common used when the Boomi Processes are executed.

NOTE: This field only displays if the source is an IG Universal Connect data source.

Displays the name of the atom, the default execution environment where the Boomi Process runs.

If this field is blank, the Process executes against the default atom registered with the IG Universal Connect data source.

NOTE: This field allows the user to run the Target Source refresh against a registered atom other than the one assigned to the default data source. Use this feature for testing purposes if there are multiple atoms set up on different DSP® server environments and the tests should be run against the different environments registered under the single tenant.

NOTE: This field only displays if the source is an IG Universal Connect data source.

Description

Displays user ID to log into SAP. Used for RFC and SAP Text data downloads.

Displays encrypted password to log into SAP. Used for RFC and SAP Text data downloads.

Displays the name of the client within the SAP instance. Used for RFC and SAP Text data downloads.

NOTE: The information in this field is used to filter the data downloaded from the source. The filter runs against the MANDT column.

If enabled, data is downloaded for all clients in the SAP instance. Used for RFC and SAP Text data downloads. Default value is Disabled.

If enabled, builds primary keys without the client field (usually MANDT). This feature can only be used if only 1 client is downloaded (i.e., All Clients is disabled).  Used for RFC and SAP Text data downloads. Default value is Disabled.

Displays SAP instance name used for the source refresh.

Displays default language of the SAP instance.

Displays system number used to log into SAP so Collect can refresh Pool Table data.

Displays server host used to log into SAP so Collect can download Pool Table data from the source.

Click to test connection to SAP. This process doesn't test the validity of the SAP User ID or Password, or verifies the SAP User ID has access to SAP tables; only verifies SAP User ID has access to SAP.

Sap Optional

Displays option for RFC namespace, as in, the type of SAP transport that is used. The default option is configured in Common > Collect Parameters.

Values are:  NAMESPACE, NONNAMESPACE

BackOffice Associates® owns the namespace /BOA. The NonNamespace transports begin with ZBOA. Check with BASIS team to find out if you are running NAMESPACE or NONNAMESPACE.

Displays the server host name if SAP Load Balancing is used to download SAP table from the source via RFC. Refer to SAP documentation for details about Load Balancing.

Displays the logon group name if SAP Load Balancing is used to download SAP table from the source via RFC. Refer to SAP documentation for details about Load Balancing.

Description

Click to download tables from the source into a new System Type group with the same name as the source. This process is helpful for source database systems where many tables must be created and downloaded. A System Type group is added for each schema with the naming convention of <source>_<schemaowner>. Refer to Create System Type Groups from the Fetch Process.

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

Click to build System Type groups from existing source tables after the source is configured. A System Type group is created with the naming convention <Target>_<Source> and the schema owner is defaulted to dbo for the group. Refer to Create System Type Groups from Existing Source Tables.

Fetch Table Options

Click to activate tables in the fetch table process.

Description

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

Any user or group who is assigned the Data Controller role must have a user account in the DSP. 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.

Displays the nature of the data in the target source, identifying whether it contains personal data and so must be purged for regulatory compliance.

Options included with the DSP 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 DSP 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.

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

A Collect Administrator must enter a date for a target source 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 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 Targets, Tables and this page are inactive. The table can no longer be refreshed either manually or automatically.

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