Avatar

Community Advisor

Hi,

 

Make sure you have the table's key in the connector activity.

To relate the sfdc tables to Campaign tables, create a local copy using template references to the wizard-generated library, then materialize and configure per normal.

 

As far as using the connector for non-trivial tasks, it's essentially impossible to do correctly by hand, and I've seen very shaky implementations as a result:

  • Schemas require all cols to be mapped, sfdc tables can have 100+ cols and there can be 10+ tables
  • Connector activities require all cols to be mapped, with delta options configured, etc
  • Update activities require all cols to be mapped
  • Clients never know exactly which tables they need, and there will be a couple rounds of adjustments
  • Tables can change over time

 

FWIW I wrote a simple script that does all the above, requiring end user to just run without any configuration or effort.

 

Thanks,

-Jon