SFDC CDO to Marketo real(ish) time. Help! Pease.

[Joshua_Bauer]

A key part of our system architecture requires triggering updates to Marketo off changes/updates to customer SFDC objects. I have read the current discussions on the topic and the dicussions are either old or there is no definitive solution in place. So, I need to ask .

1.) Is the best way to accomplish then by creating mirror objects in Marketo and syncing between to two?

2.) Does the above solution require APEX work to keep the the triggering of deltas constant? ( Our organization is, like most places, on a time crunch and without a true SFDC dev.)

3.) Is there something a little more simple to solve this issue or at least approximate it without mirroring objects?

Any and all help here is appreciated. Thanks!

[Jay_Jiang]

If you're going to be using the info in smart campaigns and flows, you'll need to use apex or a process builder to copy the field values from the customer object to the contact or account object where marketo can pick it up natively, otherwise if you're just using it in emails, you can sync it where you'll have access to records through velocity and a couple of filters + a trigger.

As for syncing SFDC custom objects, as long as the custom object is related to the Lead, Contact or Account object, it can be synced natively. Go to Admin > Salesforce object sync to turn it on - you don't have to "create" a whole custom object in marketo from scratch

[SanfordWhiteman]

Go to Admin > Salesforce object sync to turn it on - you don't have to "create" a whole custom object in marketo from scratch

Joshua is trying to get update triggers, though. That's the pain point & won't happen with SFDC COs, which is where the mirror object notion comes into play.

[SanfordWhiteman]

Every workaround for this is gonna be a hack of some sort. I think the mirror CO is the worst option of all, though.

Like Jay says, you can use Process Builder or Apex to update a flat field on the lead.

When faced with this need I prefer to create another object, call it Customer Update in this case, and sync that to Marketo. Use PB to create the CO record. That allows you to use ​the Added to Customer Update​ trigger and also gives you a lightweight audit trail.

If it truly needs to be real-ish time (like realer-ish time than the built-in Marketo sync) then you can use an outbound message, or an Apex callout, from SFDC to Marketo.