Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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:
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.
Some of the key challenges that were considered while creating the Microsoft Common Data Model for Automotive include:
Microsoft Common Data Model and Automotive CDM Integration
Sales & Marketing
Service & After-Sales
Vehicle & Equipment
Aggregate KPI Context
Service Appointment Type
Aggregate KPI Measurement
Customer Identifier Type
Deal Device Add On
Service Contract Detail
Service Contract Terms
Dealer Plate Device Assignment
Service Contract Type
Business Operation Customer Preference
Service Order Group
Financing Opportunity Detail
Service Order Job
Service Order Job Detail
Service Order Job Type
Lead Device Specification
Service Order Type
Device Inspection Checklist
Device Inspection Checklist Type
Lead Disposition Activity
Device License Plate
Lead Price Type
Lead Specification Type
Device Model Code
Sales Contract Device
Sales Contract Payment
Device Observation Type
Sales Contract Terms
Sales Contract Type
Device Warranty Limit
The following represent some sample entity relationship diagrams about how to model key segments of the Automotive Common Data Model.
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.
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.
Example: National Sales Company
A national sales company owns two local dealerships, one in New York and the other in Boston.
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.
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.
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.
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 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.
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.
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.
Business Applications communities