Overview
The SugarCRM Source Component is an SSIS Data Flow Component for consuming data from the SugarCRM Service. The configuration parameters are provided in the standard Data Flow Component dialogs.
Parameters
Configuration
Use the parameters below to configure the component.
Select an existing SugarCRM connection manager.
Related Topics: SugarCRM Connection Manager
Specify the number of rows to be retrieved as a batch.
Select the SugarCRM module.
Specify the WHERE clause. Optional.
Specify the ORDER BY clause. Optional.
Indicate whether or not to include deleted records in the result. This parameter has the options listed in the following table.
Value Description True Include the deleted records in the result. False Do not include the deleted records in the result (default). Indicate whether or not the module relationship fields should be included. This parameter has the options listed in the following table.
Value Description True The relationship fields are included. Keep in mind this may cause the retrieve process to run more slowly. False The relationship fields are not included (default).
Knowledge Base
What's New
- New: Introduced component.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.