Blog
Keep the original data. Define your own answers.
Writing on how a data platform is built: ETL, ELT, data integration, data lakes, dbt and BI — drawn from Undercroft's own source code.
Integrations
Connect your sources into one raw data lake and Postgres.
Articles
MCP server for business data: AI with clear boundaries
An MCP server for business data helps AI agents work with Xero, Gmail and Drive. Understand permissions, reliable answers and when Undercroft fits.
Data integration: connect sources, keep the evidence
Understand data integration, how REST API connectors bring sources together, and when Undercroft's raw-data-first approach fits your reporting needs.
ETL vs ELT: which approach fits your reporting needs?
ETL vs ELT explained for business and engineering teams: compare the trade-offs, understand raw data retention, and see where Undercroft fits.
Gmail integration: turn email into usable business evidence
Explore Gmail integration for business reporting: preserve email and attachments, make their text searchable, and understand the benefits and trade-offs.
Google Drive integration: make stored documents searchable
Explore Google Drive integration for searchable documents: how OCR, preserved originals and optional classification help, and where the approach falls short.
HubSpot integration: connect sales to revenue reporting
A HubSpot integration can connect CRM and accounting for clearer reporting. Learn how Undercroft preserves source data and where your team's judgment matters.
Raw data lake: keep the evidence behind your reports
A raw data lake preserves captured inputs so reports can be rebuilt. Learn how Undercroft approaches it, what you gain, and when it fits your team.
Choosing an open-source data platform: is Undercroft a fit?
Is an open-source data platform right for your team? Explore how Undercroft connects raw data, models and reports, and what self-hosting asks of you.
Xero integration: from accounting data to trusted reports
Explore a Xero integration that keeps raw data and lets your team define reports. Understand sync, data coverage and the trade-offs before choosing.
Xero reporting: build reports your team can explain
Make Xero reporting reflect your business with shared definitions, reusable dbt models and visible data gaps. Learn where Undercroft fits and what it requires.