--- title: "OWOX Data Marts — One flow from source to answer" canonical: "https://www.owox.com/product" updated: "2026-09-25" --- # Self-Service Analytics with Control for Data Analysts and Freedom for Business Users Every report is only as good as the chain behind it. OWOX draws the chain — collect, store, define once, deliver everywhere — and keeps every link governed by your data team. Hover a card to see what it touches. 01 · Foundation [Connect data sources](/product/data-connectors) to an [ontology model](/product/data-modeling) tailored to your business. Ensure data trust with [automatic quality validation](/product/data-quality). No per-connector bill. No semantic layer tax. 02 · Enablement Get zero-hallucination answers in your [AI](/product/ai-assistants), [spreadsheets](/product/spreadsheets) and [dashboards](/product/dashboards). One governed source of truth for everyone in organization. Powered by patented technology 03 · Ecosystem Your data has more value when any product can unlock it. [Create plugins](https://docs.owox.com/docs/plugins/) for any customization you could imagine. Trusted data and governed credentials without the headache ### OWOX Data Marts consists of six core entities, seamlessly integrated to address the most challenging data questions you may have 1. [Sources](#sources) 2. [Storages](#storages) 3. [Data Marts](#marts) 4. [Destinations](#destinations) 5. [Reports](#reports) 6. [Plugins](#plugins) ## Sources Shopify3 data marts Facebook Ads18 data marts Google Ads23 data marts TikTok Ads4 data marts Open Exchange Rates1 data mart [See all sources](/product/data-sources) ## Collect from the tools you already run Ads, e-commerce, CRM and product data land in your warehouse as first-class inputs — scheduled, transparent and reproducible. Why OWOX * **Open-source connectors.** Every connector is Node.js you can read, fork and fix. No black-box ETL and no per-row pricing. * **Your warehouse, not ours.** Data never sits in a vendor's cloud on the way in. It goes straight to the storage you own. * **Custom source in a day.** The connector template is the whole contract — a new API is a folder, not a support ticket. ## Storages BigQuery4 data marts Snowflake14 data marts AWS Athena11 data marts Databricks17 data marts ## Keep it in the warehouse you already trust OWOX runs on top of your storage. Nothing is copied out to be modelled; every data mart is a query your warehouse executes. Why OWOX * **No second copy of your data.** BI tools and semantic layers ingest and cache. OWOX reads in place, so there is one truth and one bill. * **Any warehouse, same product.** BigQuery, Snowflake, Athena, Databricks, Redshift — one project can hold several, and a mart moves with its storage. * **Shared on your terms.** A storage is shared for use or for maintenance separately, so analysts build on it without holding its keys. ## Data Marts Unified AdSpendSQL24 fields2 triggers1 relationship OrdersTable18 fields1 trigger3 relationships CustomersView12 fields1 trigger1 relationship ProductsTable15 fields1 trigger1 relationship ## Define every metric once A data mart is the governed layer between raw tables and every report: one definition per metric, reused by every team, tool and agent. Why OWOX * **Governance without a six-month project.** Govern at the mart level — enough structure to trust the numbers, shipped in days, not a semantic-layer programme. * **Joinable, not siloed.** Marts relate to each other, so ad spend meets orders without anyone rebuilding the join in a spreadsheet. * **Quality and freshness on the card.** Every mart carries its last-updated time and its data-quality checks. A broken link is visible before anyone asks. ## Destinations ChatGPT468 conversations Claude412 conversations Google Sheets242 reports Excel346 reports Data Studio6 reports Slack3 reports API4 reports [See all destinations](/product/data-destinations) ## Deliver where the question is asked One mart powers many outputs without duplication — a spreadsheet, a workbook, a dashboard, an AI assistant that answers from governed definitions, or your own code through the API. Why OWOX * **AI without hallucinated metrics.** Claude and ChatGPT read the mart, not the raw tables. The answer uses your definition of revenue, every time. * **Spreadsheets stay live.** Google Sheets and Excel refresh on a schedule from the same mart. No exports, no stale tabs. * **Every route is visible.** Which report writes where, when it last ran and whether it succeeded — on the card, not in a log. ## Reports Ad Spend by Channel2 hours ago Daily Sales1 hour ago Customer Cohorts3 days ago Top Products3 days ago ## Reports that refresh themselves A report is a saved question against a data mart: which columns, which filters, where it lands and when. OWOX runs it on schedule and writes the answer into the sheet or workbook your team already opens. Why OWOX * **Built on the mart, not the raw tables.** Every report inherits the mart's definitions, so two teams asking the same question get the same number. * **Scheduled, not exported.** Triggers refresh a report on your cadence. Nobody copies a CSV on Monday morning. * **Run history on the card.** Last run, status and owner sit beside each report. A failed refresh is visible before the meeting it feeds. ## Plugins Data Flow AI Dashboard Run History Stats OKF Import ## Extend OWOX with plugins Plugins read your project through the OWOX API and add the views and workflows your team needs — without waiting on a roadmap. Why OWOX * **Built on the public API.** A plugin sees exactly what the API exposes, under the same permissions as the person using it. * **Install, don't integrate.** Plugins run inside OWOX. No extra login and no data copied to another vendor. * **Yours to build.** The plugin SDK is open. A custom view for your team is a small project, not a feature request. ## References Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Connect data sources](https://www.owox.com/product/data-connectors) — /product/data-connectors.md - [ontology model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md - [automatic quality validation](https://www.owox.com/product/data-quality) — /product/data-quality.md - [AI](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md - [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [Create plugins](https://docs.owox.com/docs/plugins) - [See all sources](https://www.owox.com/product/data-sources) - [See all destinations](https://www.owox.com/product/data-destinations)