A Appendix: Add or Edit the Attributes in Salesforce Marketing Cloud (Optional)

To add or edit attributes in Salesforce Marketing Cloud (other than what is pre-configured in this recipe), you must update the data extension you created previously and update the schema in REST endpoint configuration of the Oracle FTP SFMC DataExtension Import integration flow.

Update the Data Extension in Salesforce Marketing Cloud

1. Log in to Salesforce Marketing Cloud.
2. In Audience Builder, select Contact Builder.
3. In the Contact Builder window, navigate to the Data Extensions tab.
4. Select the data extension you created previously from the list, then click Open.
5. To add a new attribute, click Create Attribute.
6. To edit an attribute, click the Edit icon next to the attribute.

   Note:

   You cannot select the data type while editing the attribute.
7. Click Save.

Update the Schema in REST Endpoint Configuration

1. In the Integrations section, click the Oracle FTP SFMC DataExtension Import integration flow.
2. On the integration canvas, expand FileScope, then expand PageScope.
3. In PageScope, select the UpsertInSFMCDataExtension element, and then click Actions and select Edit.
4. On the Request page, update the JSON schema with the new fields.
5. On the Summary page, click Done.
6. In the resulting window, click Update.

   The updated attribute appears as a separate field on the mapping canvas.

Update the REST Endpoint’s Mapper

Map the new attribute to the relevant source attribute on the mapping canvas.

1. On the integration canvas, in PageScope, select the Map to UpsertInSFMCDataExtension element, then click Actions and select Edit to open the mapper.
2. Map the new attribute to the relevant source attribute on the mapping canvas.