SF Connectors aren’t robust enough to account for loading data based on a combination of logical factors, i.e. when you need to load users based on values in a different object than User.
For example, we want to load in external contractors but only when they have been assigned to a Project in SFDC.
Discovered yesterday that Load to User only support Update, not Upsert. This is very restrictive. Need to have the ability to Insert and Upsert into the user table.