Ignore User

An Ignore user is a user whose changes should be filtered out when sending updated records to a datastore. Ignore users are used by many applications to prevent records from getting stuck in an endless loop between two datastores.

For example, assume you are integrating customer data from SQL Server into Salesforce. You have a Map called FromSQL_Customers_ToSF that integrates a new record from SQL Server Customers into Salesforce Customers.

In the Query Block for this Map, we added the following filter:

LastModifiedByID is not equal to "<Salesforce User ID>"

Without this filter, the Map that integrates Customer records from Salesforce to SQL Server (FromSF_Customers_ToSQL) determines that there is a new record in Salesforce Customers, which it integrates back into SQL, which determines that there is a new SQL Customer record, and so on.

With the filter, the record is integrated into Salesforce, but, because the filter ignores new records from SQL where the Salesforce user is the ModifiedbyID user, the record is not re-integrated.

Related Topics

TIBCO Scribe® Online Connector For Microsoft Dynamics GP