Foundation

Automated sync with the specialized construction accounting platform contractors trust.

ERP

Cloud and on-premise

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 Foundation — the specialized construction accounting platform contractors trust — with an automated, read-only connection. Foundation remains your system of record, and RIVET syncs people, projects, and WIP from it on a schedule. No extra permissions setup is required in Foundation.

What syncs

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

People / workers
Projects
WIP (work-in-progress)

Cost-code mapping enables scope-based planning and scheduling.

How it connects

RIVET connects to Foundation with a read-only ODBC connection; SFTP is also available:

ODBC — read-only database access with login credentials (the ODBC user sees the standard set of tables RIVET uses)
SFTP / manual file drop — Foundation report-builder exports, automated from Foundation cloud or email to RIVET's SFTP

For firewalled or cloud-hosted Foundation environments, RIVET's IPs must be allowlisted. Credentials should be stored securely and rotated periodically.

Frequently asked questions

How does RIVET connect to Foundation?

With a read-only ODBC connection; SFTP report-builder exports are also available. No extra permissions setup is required in Foundation.

Does RIVET write anything back to Foundation?

No. Foundation stays your system of record — the connection is read-only and RIVET only syncs data out.

What data syncs from Foundation?

People, projects, and WIP. Cost-code mapping enables scope-based planning and scheduling.

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