Overview
The SugarCRM collector allows you to collect data from any module configured in the SugarCRM environment. The SugarCRM account used by DataBlend must have permission to access the desired data.
Configuration
|
Field |
Required/ Optional |
Comments |
|---|---|---|
|
Type |
Required |
SugarCRM |
|
Name |
Required |
Descriptive free-text name for the collector |
|
Data Source |
Required |
Select a pre-configured data source from the drop down or click Create New to create a new data source. |
|
Credential |
Required |
Select a pre-configured SugarCRM credential from the drop-down. |
|
Schema Name |
Required |
Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run. |
|
Module |
Required |
Select a SugarCRM module from which to select data. This list is populated dynamically based on the credentials selected above. |
Select one or more fields from the selected module to collect.
If you know the name of the field you wish to collect, use the Search box to filter the list of available fields.
Please note that comparisons are case sensitive.
|
Operator |
Description |
|---|---|
|
AND |
Logical operator. Use to combine two other filters, where both are true. |
|
Equal To |
<Property> equals <Value>. |
|
Greater Than |
<Property> is greater than <Value>. |
|
Greater Than Or Equal To |
<Property> is greater than or equal to <Value>. |
|
In |
<Property> matches one of the specified <Values>. |
|
Is Not Null |
<Property> is not null. |
|
Is Null |
<Property> is null. |
|
Less Than |
<Property> is less than <Value>. |
|
Less Than Or Equal To |
<Property> is less than or equal to <Value>. |
|
Not In |
<Property> does not match one of the specified <Values>. |
|
Or |
Logical operator. Use to combine two other filters, where either one is true. |