← sources

Small Company Data Solutions?

source: reddit (reddit:dataengineering)published 2026-10-26 15:00ingested 2026-10-27 02:36

retained text

We're a construction company using Viewpoint Spectrum as our primary data source. Currently, most reporting is done through Power BI, SQL, and Claude, with approximately 20-40 report consumers and a small number of report developers (2-5).

One challenge is that Spectrum database access is restricted through IP whitelisting, making direct access difficult for field users. Additionally, with Claude being use a lot I believe it's important to have real data modeling and etc. We're evaluating different architectures for reporting, governance, and future AI use cases.

I looked at data warehouses and other solutions be they seem to be very expensive and hard to justify. I have also seen people recommend having your own server where something like MongoDB or Apache Superset is hosted. There are too many solutions so I would like some recommendations.

document fetched 2026-10-27 00:24 · canonical https://reddit.com/r/dataengineering/comments/1xfz80y/small_company_data_solutions