Summary – Master Data Management – Salesforce Certified Data Architect Study Guide

Summary

In this chapter, we covered a lot of the theory behind MDM, having a single source of truth for data records, and some methods for its implementation, along with considerations for doing so. While Salesforce is often implemented to act as the de facto source of truth, it is important to understand why that often drives these decisions and the benefits it gives, hence spending time on the theory of MDM. With that theory understood, it should become clear how Salesforce fits into an organization’s MDM strategy.

We’ve looked at why data quality is important in the context of MDM, and why it is important to preserve data attributes across the systems in the enterprise that constitutes the single source of truth, or golden record.

We turned our attention to MDM implementation in Salesforce, touching on the use of middleware, and highlighting the data migration exercise that will invariably accompany a Salesforce go-live.

We have covered what a golden record is and looked at the various things to consider when determining where a golden record’s data fields reside, and what data fields from source systems constitute the golden record. The architecture related to associating different systems in the IT enterprise with the golden record can have an impact on how data operations work and business rules run, so we covered the theory behind that also. We also then looked at how to preserve data quality and ensure traceability and business rule context for operations and procedures, highlighting that the system in which a process runs may change due to the introduction of a new data master in the IT estate.

In Chapter 4, Salesforce Data Management, we’ll dive into how Salesforce license types affect the data model and the sharing options available to work with. We’ll also look at how to govern the data on the platform, as it is crucial to designing scalable, performant solutions that combine data from one or more Salesforce instances.

Practice questions

  1. A single source of truth is otherwise known as what?
  • What is the source of record MDM implementation method?
  • What’s the difference between a consolidated golden record and the coexistence of the golden record when implementing MDM?
  • In a simple point-to-point integration between Salesforce and one other system, where should the ID of the record in the other system (as linked to the Salesforce record) live?
  • If no external registry is available and external system IDs are not to be stored in Salesforce, yet Salesforce is connected through a middleware to other systems, where is the ideal place to store record ID associations?

Answers

  1. A golden record.
  • A single system being used by everyone for access to the same single set of information.
  • A consolidated golden record is the initiator of change in connected systems. The coexistence of the golden record means any connected system may initiate a data update (bi-directional data sync).
  • In Salesforce.
  • In the middleware.

Further reading

  • Beginners Guide to MDM: https://www.dataqualitypro.com/blog/beginners-guide-to-mdm-master-data-management
  • What is Master Data Management (MDM)?: https://www.mulesoft.com/resources/ esb/what-is-master-data-management-mdm
  • Salesforce Connect: https://developer.salesforce.com/docs/atlas. en-us.234.0.apexcode.meta/apexcode/platform_connect_about.htm