Marketo/Sugar Integration - Country Field

[Anonymous]

We are using NEPO for integration and for some reason when a lead is syced from Sugar CRM to Marketo it picks up the country as an alpha numeric code.

Now,
We had 2 contacts that existed in sugar; and 1 lead record exist in marketo; I changed country alpha code (which is another issue we are having) in marketo to country USA; then in sugar this changed corresponding company name to contact name. Which is very strange as I did not make any changes to the Company name or lead info. Anyone having similar issues? Or know what might be causing this?

[Anonymous]

Hi Tashmeem,

I'm also using the Nepo connector, it could be due to a lot of factors;

> workflows and rules in Sugar

> which fields are mapped through the connector

> having 2 records in Sugar - there is no way of telling the connector which one to sync with when you change something in Marketo

     - in this case, to identify the process thats occurred and then the exact problem you first need to identify which contact record marketo synced with, so in Sugar, have you added the field; Marketo Lead ID to the displayed fields in Contact and Lead views? If so, this is the easiest way to tell...

> Once you've identified which Sugar Contact MKTO synced with, go to the drop down options in the Sugar record, and select 'view change log' - hopefully you've got the required fields setup to be tracked and this log will give further insight behind the problem.

It is quite odd that it would change the Company name and Contact Name fields when you haven't made changes to those. The only thing I can thing of is that you'r mapping in the connector might be setup incorrectly, which could allow this scenario to occur if for example;

In Marketo you had the following...

Contact Name = Jo Blogs

Email = jblog@acme.com

Org Name = ACME

Country code = USA

And in Sugar you had...

Contact Name = Jo Blogs

Email = jblog@acme.com

Org Name = ACME

Country code = [blank]

And in the connector mapping you had the following...

Contact Name mapped to Org Name

Org Name mapped to Contact Name

Country code mapped to Country code

Email mapped to Email

You make a change in Marketo so it assumes thats the most up to date data, therefore should override whats in Sugar. It looks for a match based on ID or email, it finds a matched contact and syncs. But if you had the mapping a bit wrong, this could explain the error. Marketo would try and push the Org Name to the Org Name in Sugar, but because the mapping tells it to push it to Contact Name then it would do that instead.

A change in either platform triggers it to sync. So I'm surprised this hasn't been a problem with previous leads and contacts, or has it? Knowing if this is a one off problem or not would also give good insight to isolate the problem...

Hope that helped 😕

[Anonymous]

Did you get to the bottom of this?

[Anonymous]

Hi Julia,

Thanks for your email, this issue has not been resolved yet. I'd really

appreciate some help with it.

Thanks,

Tash

Tashmeem Mirza | Market Response Representative

Dbvisit - the smart alternative for data replication

USA: 1-800-933-8007 | TEL: +64 9 950 3301 | MOB: +64 22 427 1548

tashmeem.mirza@dbvisit.com

www.dbvisit.com

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=http%3A%2F%2Fwww.google.com%2Furl%3Fq%3Dhttp%253A%252F%252Fwww.dbvisit.com%252F%26sa%3DD%26sntz%3D1%26usg%3DAFrqEzcy5cYWoIm5OyJSM54ln2YIRXmOVA>

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=http%3A%2F%2Fwww.dbvisit.com>

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=https%3A%2F%2Ftwitter.com%2Fdbvisitmike>

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=http%3A%2F%2Fnz.linkedin.com%2Fpub%2Fmike-donovan%2F22%2Fa58%2Fb09>

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=https%3A%2F%2Fwww.facebook.com%2FDbvisit>

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=http%3A%2F%2Fwww.youtube.com%2Fdbvisit>

<http://r.clb.pt/r/bddcae1ed164209f321714db6ebcc51d?d=http%3A%2F%2Fblog.dbvisit.com%2F>

This email is confidential and may be legally privileged. If you are not

the intended recipient you must not use any of the information in it and

must delete the email immediately.

On Fri, Jun 26, 2015 at 1:16 PM, Julia Rosenthal <

[Anonymous]

Do you have access to the connector setup. No one will be able to help if you can't provide more detail around the field mapping and be able to answer a few questions, like;

Does it happen all the time, or only with certain records?

Does is happen when pushing data from MKTO to Sugar, or the other way, from Sugar to MKTO?

What happens if you try and fix the data in one system, does it revert back to the incorrect data when it syncs again?

etc etc. I'm happy to try and help, but can't without a lot more info.

Have you gone back to the people who built the connector and asked for help?

[Anonymous]

Hi Julia,

Thanks for your email. We have spoken to the connector people and it

doesn't seem like a NEPO issue.

I am going to forward you to my colleague Deepika, who is also copied here.

She is helping out with the issue and can give you the info you require.

Kind regards,

Tash

Tashmeem Mirza | Market Response Representative

Dbvisit - the smart alternative for data replication

USA: 1-800-933-8007 | TEL: +64 9 950 3301 | MOB: +64 22 427 1548

tashmeem.mirza@dbvisit.com

www.dbvisit.com

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=http%3A%2F%2Fwww.google.com%2Furl%3Fq%3Dhttp%253A%252F%252Fwww.dbvisit.com%252F%26sa%3DD%26sntz%3D1%26usg%3DAFrqEzcy5cYWoIm5OyJSM54ln2YIRXmOVA>

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=http%3A%2F%2Fwww.dbvisit.com>

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=https%3A%2F%2Ftwitter.com%2Fdbvisitmike>

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=http%3A%2F%2Fnz.linkedin.com%2Fpub%2Fmike-donovan%2F22%2Fa58%2Fb09>

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=https%3A%2F%2Fwww.facebook.com%2FDbvisit>

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=http%3A%2F%2Fwww.youtube.com%2Fdbvisit>

<http://r.clb.pt/r/4502250b0d219a5f72d2a216d599db3a?d=http%3A%2F%2Fblog.dbvisit.com%2F>

This email is confidential and may be legally privileged. If you are not

the intended recipient you must not use any of the information in it and

must delete the email immediately.

On Fri, Jun 26, 2015 at 2:11 PM, Julia Rosenthal <

[Anonymous]

ok, you do realise I don't work for Marketo don't you..? I'm just another marketo customer who uses the nepo connector...

Happy to take a look and try and sort it out for you though

[Anonymous]

Oh wow! No I did not actually! Are you having the same issue?

Tashmeem Mirza | Market Response Representative

Dbvisit - the smart alternative for data replication

USA: 1-800-933-8007 | TEL: +64 9 950 3301 | MOB: +64 22 427 1548

tashmeem.mirza@dbvisit.com

www.dbvisit.com

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=http%3A%2F%2Fwww.google.com%2Furl%3Fq%3Dhttp%253A%252F%252Fwww.dbvisit.com%252F%26sa%3DD%26sntz%3D1%26usg%3DAFrqEzcy5cYWoIm5OyJSM54ln2YIRXmOVA>

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=http%3A%2F%2Fwww.dbvisit.com>

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=https%3A%2F%2Ftwitter.com%2Fdbvisitmike>

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=http%3A%2F%2Fnz.linkedin.com%2Fpub%2Fmike-donovan%2F22%2Fa58%2Fb09>

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=https%3A%2F%2Fwww.facebook.com%2FDbvisit>

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=http%3A%2F%2Fwww.youtube.com%2Fdbvisit>

<http://r.clb.pt/r/7782ce39d0130d39e5b8cb46f46d467b?d=http%3A%2F%2Fblog.dbvisit.com%2F>

This email is confidential and may be legally privileged. If you are not

the intended recipient you must not use any of the information in it and

must delete the email immediately.

On Fri, Jun 26, 2015 at 3:33 PM, Julia Rosenthal <

[Anonymous]

I've spent the last 12-18 months working with Sugar, Marketo and Nepo to rebuild the connector after we initially integrated and the connector started deleting our data from the CRM. Was a nightmare! So I know the in's and out's of it pretty well now. Has been a loooong road, but we're all set up now and full steam ahead