SAP C4C Employee to Marketo Sales Person Data Sync

This section describes the recipe for the data sync between SAP Cloud for Customer Employee business object and Marketo Sales Person business object.

SAP Cloud for Customer (C4C) is a cloud solution to manage customer sales, customer service, and marketing activities efficiently and is one of the key SAP solutions to manage customer relationships.

Marketo provides software platforms and technologies designed for marketing departments such as account-based marketing, which includes email, mobile, social, digital ads, web management, and analytics.

The business purpose of this integration is to extract the SAP Cloud for Customer Employee records and upsert them in Marketo as the records for Salesperson.

When the Employee object gets synced in Marketo, it needs to be created or updated with the custom fields mentioned below.

On SAP C4C	Comments
MKTOEmployeeID	The custom field needs to be created for Employee records in SAP C4C to hold the Marketo Sales Person records id.

The recipe is tested for SAP Cloud for Customer product version 1908.04.0006. Hence the recipe is compatible to run for the tested and older versions of the product.

This integration "SAPC4CToMarketoSalesPersonDataSync" is designed to run for initial as well as ongoing sync. As part of initial sync, all the employee records present in SAP C4C will be synced to Marketo. On the other hand, as part of ongoing sync, the newly created or updated Employee records will be synced to Marketo for the provided date range. Once the record is successfully created in Marketo, it syncs back the Marketo Salesperson ID in the corresponding SAP C4C Employee record (Custom Field: MKTOEmployeeID).

The following diagram represents creating a Salesperson in Marketo from an Employee in SAP C4C:

This recipe has a sub flow to handle the obsolete contact record in SAP C4C, that is, updateDeletedSAPC4CContactsToMkto.

Operation Name	Application	Description
querySAPC4CEmployees	SAP C4C	Queries SAP C4C Employee.
upsertMarketoSalesPerson	Marketo	Upserts Employee in Marketo as SalesPerson records.
patchSAPC4CMultipleContact	SAP C4C	Once records are successfully created in Marketo, it updates Marketo SalesPerson ID in the corresponding SAP C4C employee record in the MKTOEmployeeID custom field.

Condition	Filter to query records from SAP
IsInitialSync = True	No filter required.
IsInitialSync = False	ChangedOn ge datetimeoffset'%fromDateString%'

SAP - EMPLOYEE		MKTO - SALES PERSON
EmployeeID	Standard	externalSalesPersonID	Standard
Email	Standard	email	Standard
FaxNumber	Standard	fax	Standard
FirstName	Standard	firstName	Standard
LastName	Standard	lastName	Standard
MobilePhoneNumber	Standard	mobilePhone	Standard
OfficePhoneNumber	Standard	phone	Standard
JobName	Standard	title	Standard

Once Employee records are successfully created in Marketo as SalesPerson records, then update Marketo SalesPerson ID to the corresponding SAP C4C employee record in the MKTOEmployeeID custom field.

MKTO - SALES PERSON		SAP - EMPLOYEE
ID	Standard	MKTOEmployeeID	CustomField
CountryCode	Standard	CountryCode	Standard
FirstName	Standard	FirstName	Standard
LastName	Standard	LastName	Standard
ObjectID	Standard	ObjectID	Standard

In order to add new standard or custom fields to the integration, copy the required field and add it to empList_NullMKTOID list and empList_WithMKTOID list while making the upsert API call to Marketo.

In order to change or remove standard or custom fields from the integration, remove the required field mapping and change or remove the field from empList_NullMKTOID list and empList_WithMKTOID list while making the upsert API call to Marketo.