Collect
Package Types
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. NOTE: The component is referred to as Assemble in the help. The package type is still CranPort. |
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. |
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). |