Target Sources H

Target Sources V (All Tabs)

Use this page to:

To access this page:

  1. Click Collect > Targets in the Navigation pane.
  2. Click the Sources icon for a Target.

Target Sources V (All Tabs)

Target Sources H

Use this page to:

This page contains the following tabs:

General tab

Advanced Settings tab

Field

Description

Rename Table Template

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

Schedule ID

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.

Download Keys Indexes

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

It is checked by default.

Delete Target Table On Build

If checked, 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 unchecked if the package type to download table data is set to SAP Data Services. In this case, if the check box is checked, 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

Do Not Delete Data

If checked, 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 when using DBMoto or Data Services.

NOTE: This check box displays if a Data Services ID is selected.

Data Services ID

Displays the repository used for the target source.

If this field is blank, the repository set at the target level is used for the target source.

Setting a repository for a target source is useful if there are a large number of jobs to run.

This repository is used for the target source Data Services repository, where Data Services jobs for the source system can be registered and run against.

NOTE: Set a repository for each target or target source. There is a limit on the number of Collect jobs that can be created in a single Data Services repository. Consider creating and registering an additional repository for separate target sources to minimize the chance of overloading the communication between Collect and Data Services.

Data Services Connection Type

Displays database connection type when using Data Services.

Connection Settings

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

Boomi

Boomi Data Source

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.

Boomi Atom Override

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.

Sap Settings tab

Field

Description

SAP User ID

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

SAP Password

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

Client

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.

All Clients

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

Remove Client From Key

If checked, 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 unchecked).  Used for RFC and SAP Text data downloads. Default value is unchecked.

Instance

Displays SAP instance name used for the source refresh.

Language

Displays default language of the SAP instance.

SAP System Number

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

SAP Server Host

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

Test Sap Connection

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

Rfc Name Space Option

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.

SAP Msg Server Host

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.

SAP Logon Group

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.

 

Action tab

 

Field

Description

Fetch Tables

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.

Reset

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.

Build Groups

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 Source Tables.

Fetch Table Options

Activate Fetched Tables

Click to activate tables in the fetch table process.

 

 

Data Protection

Use this tab to: