SugarCRM Source

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

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 source component dialog.


Setup

Use the parameters below to set up the component.

Parameters

SUGARCRM

Select an existing SugarCRM connection manager.

Related Topics: SugarCRM Connection Manager

BatchSize

Specify the number of rows to be retrieved as a batch.

Module

Select the SugarCRM module.

Query

Specify the WHERE clause. Optional.

OrderBy

Specify the ORDER BY clause. Optional.

IncludeDeleted

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).
IncludeLink

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).

How to modify the source dynamically at runtime

The source “module”, “query” and “order by” parameters are available in the data flow properties list. Follow these steps to set up an expression:

  • Right-click on the data flow canvas and select the Properties menu.
  • Scroll down and find the property named like [SugarCRM Source].[Module]. This is the property containing the module.
  • Scroll down and find the Expressions property. Set up an expression to modify the module dynamically.