← All integrations

Viewpoint Spectrum

Read-only ODBC connection syncs people, projects, WIP, and certifications from Spectrum.

ODBC

Request a Demo

Overview

RIVET connects to Viewpoint Spectrum (part of Trimble Construction One) with a read-only ODBC connection. Spectrum remains your system of record, and RIVET syncs people, projects, WIP, and certifications from it automatically. Our team knows Spectrum's schema and handles the field mapping and validation.

What syncs

RIVET pulls the data it needs to plan labor from Spectrum:

  • People / workers
  • Projects
  • WIP (work-in-progress) for scheduling visibility
  • Certifications (when stored in Spectrum)

This enables scope-based labor planning with validated field mappings.

How it connects

RIVET connects to Spectrum with a read-only ODBC connection to your database. Other paths are available depending on your setup:

  • ODBC — direct read-only database access (login credentials required)
  • SFTP / manual file drop — Spectrum report-builder exports (may require Power Automate or a contracted Spectrum automation service)
  • HTTP — for customer-managed integrations

RIVET's team is well-versed in Spectrum's schema and assists with mapping and validation. WIP data may require help from a certified Spectrum consultant.

Need the technical details?

Setup steps, field mappings, and troubleshooting live in our system guides.

View the system guide →

Ready to ditch the chaos?

Join specialty contractors who stopped accepting "that's just construction" as an excuse for losing money.

Talk to Someone Who Gets ItSee All Integrations