SaasGuru Logo

Kickstart your career with the World's First Salesforce & AI Programs by an IIT - Explore Courses 🎉

Kickstart your career with the World's First Salesforce & AI Programs by an IIT - Explore Courses 🎉
Mapping of Engagement Data From AWS S3 DLO to DMO

Mapping of Engagement Data From AWS S3 DLO to DMO

Effectively mapping customer data from AWS S3 to Salesforce Data Cloud is essential for seamless data integration and accurate data representation. 

This guide will walk you through mapping product, order header, and order line information from AWS S3 Data Lake Objects (DLOs) to corresponding Goods Product, Sales Order, and Sales Order Product Data Model Objects (DMOs) in Salesforce Data Cloud.

Step 1: Mapping AWS S3 Products

Begin by mapping the AWS S3 products, which are currently unmapped, to the Goods Product DMO.

1. Select the Goods Product Object:

  • Search for “Goods Product” and select the object.
  • Click “Done.”
AD 4nXcAStN4P5op7652Kz8kB gDifDZ V7KzxIcA7QfKu3pSvmQvRtvUomXY7JSF9MzJHh3EjW5vX278nhmMIPLUDopZhv21MDaV 9KhF9lhxnQEF279x2Bezufwwo8iNVGH eKFUh5ituryjMx1tGmneg7 780?key=okULrS3qLI 4Na4ZV1lwiQ

2. Map Fields:

  • Product Name: Automatically mapped to the Product Name.
  • Product ID: Mapped to Goods Product ID.
  • Product Category: Mapped to Primary Product Category.
  • Product Price: Mapped to MSRP Amount.
AD 4nXep1mcTT9HToQGGKQiKUOrwSgWtVY1opmoBIVKTEOXltVbC3ZxWpNB dDj zg925mzVz1eXlzBmXl yRn8sqI9hXfC7sL8EOiU51ywYoMQE AOrotnesfrSGsHS8J4MEqbqsnsMBMJjuq8TJXMm jeBIQs?key=okULrS3qLI 4Na4ZV1lwiQ
  • Product Subcategory: Mapped to a custom field named Product Subcategory (text type, with value suggestion enabled).
AD 4nXczmg5LRL9Wlbx5UmIZGJlOVtvZnN2XmIoBy4aTdtac1mtkYknssne1qH1lRQ4UNDhtqI4nC3ZnsQ2UeC

3. Save Changes: Validate that all fields from the DLO are correctly mapped to the data model. Click “Save and Close.”

AD 4nXfiM4m1eY8QMaE

Also Read: Mapping Imported Salesforce CRM Data in the Data Cloud

Step 2: Mapping AWS S3 Order Header

Next, map the AWS S3 order header to the Sales Order DMO.

1. Select the Sales Order Object:

  • Search for “Sales Order” and select the object.
  • Click “Done.”

2. Map Fields:

  • Customer ID: Mapped to Sold to Customer.
  • Date Ordered: Mapped to Confirmation Date.
  • Order ID: Mapped to Sales Order ID.
  • Status: Mapped to Sales Order Status.
AD 4nXeEAYGy3IgdrF82kLady PUq518ro0uei8V3Y9CCMZ
  • Total Amount: Mapped to Total Amount.
  • Loyalty Points Accrued: Mapped to a custom field named Loyalty Points Accrued.

3. Save and Close: Save the changes and close the mapping.

4. Adjust Sales Order DMO: Add a relationship between the Sales Order and Individual objects for the Sold to Customer field.

  • Create a new relationship.
  • Select “Sold to Customer” from the field dropdown.
  • Set Cardinality to N:1, Related Object to Individual, and Related Field to Individual ID.
  • Save and close.
AD 4nXcWDO6EjXx kcj7NM6C5sy1b0eLOC6dj0oSa 9ZCUejllzbQCXpAfjrLAxYYbALO5a5Q6U

Also Read: Effective Data Object Mapping From Salesforce CRM to Data Cloud

Step 3: Mapping AWS S3 Order Line

Finally, map the AWS S3 order line to the Sales Order Product DMO.

1. Create a New Field:

  • In the Sales Order Product DMO, add a new field named Date Ordered (data type: date).
AD 4nXf1X u2OVBMH5jvt99hQmOCesup0DyJqFDlBlS5hMz5aBQJLz3fs HsOJCs qzDNbrzx7sjJWDXeuSVve6MWVA1 9nL6NEK9aAIYYPh 458JQPZE3zLFipqdMYZh57akNjkmL9MRASIDXWUh2Gcke4DjjI?key=okULrS3qLI 4Na4ZV1lwiQ

2. Select the Sales Order Product Object:

  • Go to the AWS S3 Order Line data stream and select “Sales Order Product.”
  • Click “Done.”

3. Map Fields:

  • Order Product ID: Mapped to Sales Order Product ID.
  • Order Date Time: Mapped to the new Date Ordered field.
  • Order ID: Mapped to Sales Order.
  • Order Quantity: Mapped to Ordered Quantity.
  • Product ID: Mapped to Product.
  • Subtotal: Mapped to Total Line Amount.

4. Save and Close: Save the changes and close the mapping.

AD 4nXcvkE9sMkfg00PalUJiJGpvYBb w8QIMyaRRRWXJKfja 4sC8e8LQdK3AIKt6lksLRVfLi d6 2nxCciKACqF3sSCFkvlwLJvc XKJBSsZPSlyQodUKhbHK5Tfyk987jUyrZyF sVyR9yKVWCoSTAMLK4ns?key=okULrS3qLI 4Na4ZV1lwiQ

Explore our Salesforce Data Cloud series on YouTube for expert guidance and tips on leveraging Salesforce Data Cloud effectively.

Conclusion

By following these steps, you can efficiently map product, order header, and order line information from AWS S3 to Salesforce Data Cloud. This ensures that your customer data is accurately represented and seamlessly integrated, enhancing your data management capabilities within Salesforce.

If you’re looking to enhance your Salesforce skills, check out our Salesforce Data Cloud Consultant course. Start a free trial to access over 24 Salesforce certification courses, more than 50 mock exams, and 50+ hands-on Salesforce labs. 

Boost your career and simplify your learning experience with saasguru today!

Table of Contents

Subscribe & Get Closer to Your Salesforce Dream Career!

Get tips from accomplished Salesforce professionals delivered directly to your inbox.

Looking for Career Upgrade?

Book a free counselling session with our Course Advisor.

By providing your contact details, you agree to our Terms of use & Privacy Policy

Unlock Your AI -Powered Assistant

Gain Exclusive Access to Your Salesforce Copilot

Related Articles

Salesforce Job Market in 2025: Key Trends and Factors You Should Know

Explore the 2025 Salesforce job market trends, key factors, and strategies to thrive in an evolving digital landscape. Read now!

Humans of Salesforce – Sara Hernandez

Discover how Sara Hernandez transformed from an ‘Accidental Admin’ into a passionate Salesforce trailblazer. Read now!

New courses launched by IITs in 2024

Explore IITs’ new 2024 courses in Salesforce, AI, Data Science, Robotics & more. Advance your career with industry-aligned programs!