- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
0 Likes
Total Likes