Collect

Package Types

Package Types are ways in which data is downloaded from the source. The following table outlines the various package types supported in Collect:

Package Type

Description

BOA RFC

Uses Remote Function Calls from SAP to download data. This is a modified form of SAPRFC, and BackOffice recommends BOARFC over SAPRFC

BOA RFC using Options

Uses Remote Function Calls  from SAP with the added ability to include extra filters. Only use this if  the BOA RFC options are needed

CranPort                             

Uses a CranPort package.

DBMoto Download

Uses DBMoto® to download the data as a one-time operation.

DBMoto Mirror

Uses DBMoto®’s method of keeping the target table synchronized with the source table.

Excel Import

Reads the data from an Excel file.

IG Universal Connect

Uses a Boomi Process that executes against the IG Universal Connect data source. This package type is set by default for IG Universal Connect data sources and cannot be edited.

ManualCranPort

Uses a custom CranPort™ package created by the user.

Manual Data Services

Uses a custom Data Services package created by the user.

NOTE: The Data Services Job that is run with this package type must follow the naming conventions defined for Collect. Refer to Use the Manual Data Services Package Type for more information.

ManualSSIS

Uses a custom SSIS package created by the user.

SAP Data Services

Uses the Data Services module of SAP. This is the recommended package type.

NOTE: When using this package type, it is recommended that the Delete Target Table On Build check box be disabled in Collect on the Target Sources page’s Vertical View on the Advanced tab. 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.)

SAP Data Services using RFC

Uses Remote Function Calls via Data Services to extract data from an SAP Application instance.

SAP RFC

Uses Remote Function Calls from SAP. SAP provides this package, but BOARFC is recommended.

SAP Text

Uses Remote Function Calls  from SAP to download data only from the tables STXH and STXL with certain parameters that are defined in Collect.

SSIS

Uses an SSIS package (Microsoft).