Viewpoint Spectrum

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

ERP

Cloud only

ODBC

✓Read-only access

RIVET never writes back — your ERP stays the system of record.

✓Encrypted & secure

Credentials encrypted in Azure Key Vault; access over HTTPS.

✓Set up during onboarding

Your Implementation Manager handles it — minimal IT lift.

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.

Frequently asked questions

How does RIVET connect to Viewpoint Spectrum?

With a read-only ODBC connection to your database. SFTP report-builder exports and HTTP are also available depending on your setup.

Does RIVET write anything back to Spectrum?

No. The ODBC connection is read-only — Spectrum stays your system of record and RIVET only syncs data out.

What data syncs from Spectrum?

People, projects, WIP for scheduling visibility, and certifications when stored in Spectrum. Our team handles the field mapping and validation.

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 It See All Integrations