Data brokers in the dealership stack: who is actually sending you the file
In short
A dealership data aggregator is a third party holding the dealer's written authorisation to extract data from the DMS, CRM or shop system and deliver it onward to software vendors. Two consequences decide most builds: the dealer signs that authorisation and can end it without telling you, and the schema you receive is the aggregator's normalisation rather than the source system's own tables.
Key takeaways
- The dealer signs the authorisation, not you — which makes your access something a third party can end.
- Normalisation is lossy by construction: a code vocabulary is collapsed before you ever see it.
- You have no contract with the system vendor, so every defect travels dealer to broker to vendor.
- Ask which fields are source values and which are the provider's derivations, and get it in writing.
- Design so a feed that stops degrades the product rather than breaking it.
A dealership data aggregator is a third party holding a dealer's written authorisation to extract data from that dealer's system of record and deliver it onward to software vendors. It is neither the source system nor you. Most of what surprises a build later comes from two facts: the dealer signs the authorisation, and the columns you receive are the provider's interpretation of the source tables.
The layer exists because building against each system vendor separately is expensive on both sides. The source may be a system such as CDK, Reynolds and Reynolds, Tekion, Dealertrack or PBS, and the provider's job is to make all of them look alike. One schema across many stores is worth paying for. The cost is that fidelity, latency and recourse become properties of the provider rather than of the dealership.
Who is in the chain, and what each party actually controls
| Party | What it controls | What it can withdraw | What it cannot do |
|---|---|---|---|
| The dealer | Its own data, and every authorisation over it | Consent, at any time, usually without notice to you | Force a vendor to open a path its own contract does not provide |
| The system vendor | Which objects leave the system, at what cadence, on what terms | Certification, credentials, or the path itself | See or control what happens downstream of delivery |
| The data provider | Extraction, normalisation, delivery and the support desk | Your access, on its own commercial terms | Give you a field the source never exposed |
| Your build | Everything after the drop lands | Nothing upstream at all | Repair fidelity lost before delivery |
What the middle layer adds
- One integration instead of many. A group running 3 different systems across 12 rooftops becomes one schema, which is often the difference between onboarding a store in 5 working days and not being able to sell to the group at all.
- Normalisation. Dates, codes and names arrive in a single vocabulary, so your model is not re-litigated per store.
- Delivery you do not operate. An SFTP drop, an S3 bucket or a REST endpoint, with retries and a support desk that answers during business hours.
- Per-dealer permissioning. The underrated one: it turns adding a store into a request rather than a project.
What it removes, and why you find out late
- Fidelity. Normalisation is lossy by construction. A source carrying 11 order states mapped onto a target model carrying 5 is a decision somebody made once, and you inherit it — the same class of problem as stored codes that do not match what the tool showed.
- Identity. The provider may re-key as well as re-shape, presenting one object where the source held a header and its lines. Identifiers that were never stable get another layer of translation on top, which is why four times a repair-order number changes matters more here, not less.
- Absence. These feeds are usually snapshots, so a record deleted at the store stops arriving and nothing announces it — worked through in the deal was voided and it is still open in your app.
- Recourse. You hold no contract with the system vendor. A defect travels dealer to provider to vendor and back, and you are not on that thread. Budget 5 to 10 working days for a round trip, not hours.
What the layer emphatically does not fix is the store's own data model. A merged customer object assembled from two source systems still holds whatever the store put there, so the DMS and the CRM each believe they own the customer survives normalisation intact.
The authorisation chain, and who can end it
- Get the authorisation in writing, naming your product as the recipient. A general authorisation held by the provider is not the same as one that covers you.
- List the objects and fields it covers, and whether each is read or write. Scope creep in the other direction is common: you asked for four objects and were entitled to two.
- Ask what notice you get on revocation — 30 days is worth asking for and rarely offered — and what happens to data already delivered. Both answers belong in the integration notes.
- Confirm the dealer can point the same authorisation at a different provider without your rebuild. If it cannot, the switching cost is yours and you should price the risk into scope.
- Record who signed and when. Dealer principals and general managers change, and the renewal conversation goes badly when nobody can name the original signer.
You do not have a data source. You have somebody else's contract, which you are allowed to read the output of.
Whether to take this path at all has its own criteria, argued in take the aggregator's feed or go to the vendor directly, and the vendor-run alternative is defined in certified DMS integration programmes explained. The question underneath both — does a dealership own the data in its system — is worth settling before anybody signs.
Standing up the pipeline, the reconciliation and the internal screens that sit on a third-party feed is work we scope under internal tools and ops. The rest of this silo sits under DMS, CRM and shop-system integration, inside our automotive work.
Frequently asked questions
Short answers to the follow-ups this page tends to raise.
What is a dealership data aggregator?
It is a third party holding a dealer's written authorisation to extract data from the dealership's system of record and deliver it to software vendors, usually as a normalised feed. It buys you one schema across many stores and one support path, in exchange for fidelity, latency and direct recourse.
Who signs the dealer data authorisation?
The dealer does. Access to dealership data is granted by the dealership, not by you and not by the software vendor, which means it can be withdrawn by the dealership too. Get the authorisation in writing, naming your product and the objects it covers, and record who signed it and when.
Does the aggregator's schema match the DMS?
No, and assuming it does is the common mistake. The provider maps source tables onto its own model, collapsing code vocabularies, renaming fields and sometimes re-keying records. Ask which values pass through unchanged and which are derived, and treat anything derived as the provider's assertion.
What happens to our integration if the dealer changes data provider?
It stops, unless the authorisation was written so it can be pointed elsewhere. Check that before you build: if the dealer cannot move the same permission to a replacement, the switching cost lands on your roadmap. Designing the product to degrade to last-known-good data buys the weeks that transition takes.
- dms integration
- data access
- vendor management
- dealership data
The work behind this page
Builds from our portfolio that this page draws on.
Axlebound
Real-time fleet tracking and dispatching platform with full visibility over every vehicle, driver, and route.
LogisticsAskVault
An AI internal knowledge-search platform that answers employee questions from your own docs — grounded in citations, with knowledge gaps surfaced and deflection tracked.
Productivity AIRead next
- The scheduled export: a snapshot of survivors, not a record of eventsA scheduled dealership export is a photograph of the rows that survived to the moment the job ran. That one property decides everything you can build on it, and everything you cannot.definition
- Four times a repair-order number changes, and what to key on insteadAn RO number identifies a document at one store on one day. Four ordinary events renumber, duplicate or supersede it, and a fifth problem makes it repeat outright.definition
- The CRM says sixty-two, the DMS says fifty-eight, and the manager trusts neitherA 4-unit gap between two systems almost never means 4 lost records. Reconcile one month at record level into four buckets and the shape of the result names the cause before anyone has to argue about it.diagnostic
- The deal was voided in the DMS and it is still open in your appA voided deal or a deleted repair order never announces itself. It simply stops appearing in tonight's file, which looks identical to a truncated transfer — so the inference needs a health check before anyone trusts it.diagnostic
- The DMS and the CRM each believe they own the customerSample twenty customers who both bought and serviced, and count how many link on an identifier both systems actually store. The failure rate tells you whether this is drift or a missing design.diagnostic
- The export gained a column overnight and the parser did not noticeThe vendor adding a column is normal. A loader that trusts field position is the defect, and the fix is three assertions that run before the first row is parsed.diagnostic
Working on something in this space?
Tell us where you are in a sentence or two. We'll tell you honestly whether we're the right team, and what a sensible first slice of the work looks like.
Start the conversation