Write to SFDCLeadId in Informatica | Community
Skip to main content
July 30, 2015
Question

Write to SFDCLeadId in Informatica

  • July 30, 2015
  • 1 reply
  • 1484 views

Hello everybody,

I'm trying to create a mapping in Informatica that writes a SalesForce lead id into the lead's SFDCLeadId field in Marketo. Informatica reports a successful upsert operation. However the change doesn't appear to get written to the Marketo record. When I examine the SFDCLeadId field after the mapping has finished, it is still empty.

Is Marketo silently rejecting the change or is there something else I'm missing.

Thanks for your suggestions!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Kenny_Elkington
Adobe Employee
Adobe Employee
July 31, 2015

SFDC ID is system managed for records in Marketo.  When a new lead is inserted into or pulled from SFDC, Marketo maps the corresponding SFDC id to the Marketo-side lead.  You can use mergeLead to associate a record to that SFDC ID if one with it already exists in Marketo, though.

July 31, 2015

Where can I find the mergeLead functionality?

We are not using the native integration but instead use Informatica to do the integration work.

In our scenario an insert operation triggers a mapping task in Informatica that adds the new lead to SalesForce. As soon as that lead gets written, an outbound message triggers another Informatica mapping that needs to write the SalesForce Id of the new lead into the SFDCLeadId field in Marketo.

Can we trigger mergeLead for this particular lead record via Informatica or with a SalesForce outbound message?

Kenny_Elkington
Adobe Employee
Adobe Employee
July 31, 2015

If you're not using the native SFDC sync, then you shouldn't attempt to write to the native SFDC ID fields at all.  You'll want to create a custom field for this purpose and you should leverage that instead.  I don't know if the informatica connector has implemented merge functionality at this point, but you can find the docs for it here: Merge Lead » Marketo Developers