The Automotive Common Data Model (CDM) extends the Microsoft Common Data Model for deals, sales contracts, specifications, fleet, warranties, inspection, test drives, branding, business, customer-vehicle relationship, vehicle and equipment, lead, service and after-sales management, and more. The Automotive CDM came from working with some of our top tier partners such as Annata and Oxlo, sitting with, observing, and learning from many of our automotive customers about their desire to quickly drive digital transformation, starting with consumer experience, and the challenges of managing data across many systems of record.

Our approach includes:

  • Create enabling technology that lowers the barrier to entry for vehicle OEMs, mobility providers, dealer groups, and importers, and to introduce standards that make for a richer customer experience.
  • Microsoft partnering with leading thought leaders in the automotive industry as well as a Steering Team comprised of global customers and partners to create an automotive common data model (CDM) that reflects the common automotive scenarios.
  • Learning from data model challenges of the past and design a streamlined, open foundation for customers and partners to rapidly build applications and connectors.
  • Incorporating data standards into the model against widely adopted data standards like STAR.
  • Harnessing the power of our partner solutions, along with the Microsoft technology stack - Azure, Office 365, Power Platform, Dynamics 365, Power BI, Microsoft Connected Vehicle Platform (MCVP), Virtual Assistant, – focused on delivering omnichannel customer experience and streamlining back office operations.

The Microsoft Common Data Model for Automotive is the first of its kind to provide a model that reflects industry best-practices, insight and integration across existing vehicle retail networks, and also incorporating emerging mobility businesses.

 

Challenges

Some of the key challenges that were considered while creating the Microsoft Common Data Model for Automotive include:

  • Customer Insights: Transform transactional and behavioral omni-channel data into a data estate that enables customer experience management
  • Digital Marketing and Customer Engagement: End-to end customer experience management integrating digital marketing, contact centers, loyalty, mobility, shopping and purchase, service, and lifetime engagement
  • OEM-to-dealer integration: Enable data insights and managed consumer experiences across franchised dealer networks
  • Standards and openness: Establish publicly available standard data schema and integration standards that address the concerns of our vehicle OEM, mobility provider, dealer group, and importer customers, whose legacy systems slow down innovation with limited data transparency and interoperability.

 

Microsoft Common Data Model and Automotive CDM Integration

Microsoft Common Data Model & Automotive CDM

 

Entities within the solution

  • 91 Entities (79 new & 12 extensions to existing CDS Core and First Party Application Entities)

Business

 

Sales & Marketing

 

Customers

 

Service & After-Sales

 

Vehicle & Equipment

     

Aggregate KPI

Deal

Customer Attachment

Service Appointment

Attribute Type

Aggregate KPI Context

Deal Customer

Customer Identifier

Service Appointment Type

Configuration Code

Aggregate KPI Measurement

Deal Device

Customer Identifier Type

Service Contract

Configuration Option

Business

Deal Device Add On

Lead

Service Contract Detail

Dealer Plate

Business Facility

Deal File

 

Service Contract Terms

Dealer Plate Device Assignment

Business Operation

Deal Terms

 

Service Contract Type

Device

Business Operation Customer Preference

Deal Type

 

Service Order

Device Brand

Business Type

Financing Opportunity

 

Service Order Group

Device Class

Dealer Plate

Financing Opportunity Detail

 

Service Order Job

Device Component

Dealer Plate Device Assignment

Lead

 

Service Order Job Detail

Device Generation

Operation Code

Lead Device

 

Service Order Job Type

Device Inspection

Operation Type

Lead Device Specification

 

Service Order Type

Device Inspection Checklist

Lead

Lead Disposition

 

Warranty

Device Inspection Checklist Type

 

Lead Disposition Activity

 

Warranty Limit

Device License Plate

 

Lead Price Type

 

 

Device Measure

 

Lead Prospect

 

 

Device Measurement

 

Lead Specification Type

 

 

Device Meter

 

Opportunity

 

 

Device Model

 

Sales Contract

 

 

Device Model Code

 

Sales Contract Device

 

 

Device Observation

 

Sales Contract Payment

 

 

Device Observation Type

 

Sales Contract Terms

 

 

Device Registration

 

Sales Contract Type

 

 

Device Sensor

 

Test Drive

 

 

Device State

 

Trade In

 

 

Device Style

 

 

 

 

Device Type

 

 

 

 

Device Variant

 

 

 

 

Device Warranty

 

 

 

 

Device Warranty Limit

 

 

 

 

Fleet

 

 

 

 

Fleet Device

 

 

 

 

Lead Device

 

 

 

 

Specification

 

 

 

 

Specification Accessory

 

 

 

 

Specification Attribute

  

Capabilities 

The following represent some sample entity relationship diagrams about how to model key segments of the Automotive Common Data Model.

 

How to Model Vehicle and Equipment

Vehicles are referred to in the Accelerator as devices, since the accelerator is designed to be more general purpose that simply automotive retail. The device concept is a generic way to capture all the detail of a complex piece of equipment such as cars, RV’s, boats, industrial equipment, and so on. 

 

The BMW X3 xDrive 30i is an SUV style vehicle manufactured by BMW. The vehicle is one of several available X3 models and this particular model is again available in a number of trim levels, such as the xLine Design. Its design and specifications evolve over time and we are looking at a 2019 model which the manufacturer refers to as the G01 generation.

Example: Technical Specifications of a 2019 BMW xDrive 30i

The BMW X3 xDrive 30i is an SUV style vehicle manufactured by BMW. The specifications for this particular vehicle include engine, transmission, performance and more.

How to model vehicle and equipment

  

Example: Fleet Management

Contoso has an overview of cars allocated as demos across different locations and groups those cars into fleets with specific purposes. Some of these cars are specifically for test drives and are specified as part of test drive fleets for each location.

How to model fleet

How to Model Business

Example: National Sales Company

A national sales company owns two local dealerships, one in New York and the other in Boston.

How to model Business

Example: Dealer group

The Contoso dealer group consists of a two legal entities, Contoso Seattle and Contoso Denver. Contoso Seattle runs business from two locations: Contoso Seattle Downtown which handles all new car sales and Contoso Seattle University handles used car sales as well as service.

How to model Business - Example 2

How to model Sales and Marketing

Example: Lily Conner is interested in a 2018 BMW X3 xDrive 30i

Lily Conner contacted the Certified Pre-Owned Sales department at Contoso Seattle University because she is interested in a 2018 BMW X3 xDrive 30i. Lily has already booked a test drive for such a vehicle but also indicated that while she is most interested in this particular type of car, she might also consider other options as long as they have automatic transmission and ideally leather interior as well.

How to model Lead

Partnerships

We are building a strong eco-system of industry partners to help promote open data and build world class solutions to help our customers with their digital transformation. Below is a snapshot of partner commitments to build on top of the Microsoft Common Data Model for Automotive and share their deep industry expertise to help drive fundamental changes in the industry.

Build with partners

Annata Logo

Annata's comprehensive solution for the automotive industry is built to cover a wide range of businesses involved in manufacturing, distribution, marketing, retail and maintenance of vehicles and components in automotive.

Inspire press release

OXLO Logo

Oxlo offers two main solutions that are built off the automotive accelerator: IntegrateOnce® and GroupManager®. Both solutions leverage the common data model to store common data from multiple areas that enable enterprise business management and business analytics for automotive companies.

IntegrateOnce empowers OEMs and dealers to eliminate the time-consuming and difficult tasks of internally building, maintaining, and monitoring expensive system infrastructure.

Inspire press release

XAPT Logo

XAPT works with equipment dealers all day every day. This is at the core of our company, employing hundreds of professionals around the globe with one focus: providing the leading dealership solution for industrial equipment dealers and manufacturers.

Inspire press release

Launch partners

Automotive Accelerator Launch Partners for V1

In Closing

Our goal is to build a community around customers and partners that want to collaborate and continue to improve upon industry best practices. A goal of the Automotive Accelerator program is to build a "Community CDM", and not simply a "Microsoft CDM".  

We plan to iterate the Automotive Accelerator and Automotive CDM, and look forward to continued engagement with our customers and partners about their unique business processes and about how Dynamics 365 and all of Microsoft’s technologies can support your digital transformation journey.

 

Resources

  • Learn more about the overall Microsoft Dynamics 365 Industry Accelerator Program - link
  • Learn more about all the Dynamics 365 Industry Accelerators - link
  • Microsoft Inspire blog about the new ISV Connect program and Accelerators - link
  • Supported SKUs for the Automotive Accelerator - link
  • GitHub Repo for the Automotive Accelerator - link
  • AppSource offer for the Automotive Accelerator - link
  • Microsoft Dynamics 365 Automotive Accelerator First Look – Industry Trends and Value Propositions Whitepaper - link
  • Engagement with the Automotive Accelerator Engineering and Industry teams - link
  • Learn about the Microsoft Automotive narrative - link