OWOX / owox-data-marts

OWOX Data Marts 🏷 Self-Service Analytics Platform OWOX Data Marts is your way to create a data mart library and empower business users with spreadsheet reports and dashboards — in minutes. 📘 Quick Start Guide | 📚 Documentation | 🌐 Website | 💬 Slack Community | 🆘 Create an Issue ✨ Why We Built This Data analysts’ work means nothing unless business users can play with the data freely. However, most **self-service analytics** initiatives fail because they compromise either the data analysts’ control or the business users’ freedom. At OWOX, we value both: • Data analysts **orchestrate data marts** defined either by SQL or by connectors to sources like Facebook Ads, TikTok Ads, and LinkedIn Ads. • Business users **enjoy trusted reports** right where they want them — in spreadsheets or dashboards. At OWOX, we believe data analysts shouldn’t have to waste time on CSV files and one-off dashboards. Business users shouldn’t have to be forced to use complex BI tools either. --- --- 🚀 What You Can Do with OWOX Data Marts 📘 Create a Data Mart Library Bring together data from your warehouse (BigQuery, Snowflake, etc.), APIs, or spreadsheets – and turn it into fast, reusable artifacts that you can manage & share: • Connectors to any marketing, financial, or CRM data that you can collect into **AWS Athena** or **Google BigQuery** (more supported DWHs are being developed as you read this) • Custom SQL • Tables & views • Table patterns (eg, events_2025\*) 📤 Deliver Trusted Data Anywhere Connect your Data Marts to Google Sheets, Looker Studio, or Excel – empowering business teams with reports they need to make decisions. 🧾 Define a Semantic Layer Document KPIs and metrics once, and keep every dashboard, pivot table, and report in sync with the same numbers & logic behind calculations – no matter the tool. 📅 Automate Everything Use the advanced scheduler to refresh both Data Marts and exports at any time, fully automated and managed from a single place 🛠 Installation Guide **OWOX Data Marts** can be run just about anywhere in minutes. Here’s how to get started locally on your machine: • **Install Node.js** (version 22.16.0 or higher) If it’s not installed yet, download it here • **Open your terminal** and run: (You may see warnings - they’re safe to ignore) • **Start OWOX Data Marts** locally (You should see something like: 🚀 Starting OWOX Data Marts... 📦 Starting server on port 3000...) • **Open your browser** and go to ** ** to explore! 🎉 For more details on the types of deployment in your infrastructure, check out our Quick Start Guide 🔌 Available Connectors **OWOX Data Marts** includes growing library of **data connectors** that: • Pull data from **any APIs** like Facebook Marketing, TikTok Ads, LinkedIn Ads, etc. • Require **zero external tools** or sharing credentials • Don't require **ANY data engineering resources** • Free, open-source, and **customizable** • Give full control over the logic • Works with BigQuery and AWS Athena Data Sources | Name | Status | Links | | ------------------------------- | ---------------- | ----------------------------------------------------------------------------------- | | Bank of Canada | 🟢 Public | Get started | | Criteo Ads | 🟢 Public | Get started | | Facebook Ads | 🟢 Public | Get started | | GitHub | 🟢 Public | Get started | | Google Ads | 🟢 Public | Get started | | LinkedIn Ads | 🟢 Public | Get started | | LinkedIn Pages | 🟢 Public | Get started | | Microsoft Ads (former Bing Ads) | 🟢 Public | Get started | | Open Exchange Rates | 🟢 Public | Get started | | Open Holidays | 🟢 Public | Get started | | Reddit Ads | 🟢 Public | Get started | | Shopify | 🟢 Public | Get started | | TikTok Ads | 🟢 Public | Get started | | X Ads (former Twitter Ads) | 🟢 Public | Get started | | Shopify Ads | ⚪️ In Development| | | Hotline | ⚪️ In Discussion | Discussion | | Google Business Profile | ⚪️ In Discussion | Discussion | Data Storages | Name | Status | Links | | --------------- | --------- | ------------------------------------------------------------------- | | Google BigQuery | 🟢 Public | Readme | | AWS Redshift | 🟢 Public | Readme | | AWS Athena | 🟢 Public | Readme | | Snowflake | 🟢 Public | Readme | | Databricks | 🟢 Public | Readme | If you find an integration missing, you can share your use case and request it in the discussions 🧑‍💻 Contribute Want to build a connector? We'd love your help. **To contribute to existing integrations or create a new one:** • Read the Contributor Guide • Check Issues • Join Discussions • Join Slack Community Whether you're adding a new platform, tweaking an existing connector, or improving docs, we'll support and **spotlight you**. We're building this **with the community**, not just for it. 📌 License Except for Enterprise-grade features, OWOX Data Marts is free for internal or client use, not for resale in a competing product. The project uses a dual-license model: • **Connectors** ( ) are distributed under the MIT License • **Platform** (all other files and directories) is distributed under the ELv2 License **Enterprise features** are licensed under the Enterprise License and are located in the directory or source code files that contain in their file name. Pricing for Enterprise features is available on our pricing page. --- ⭐ **Like this project?** Star our awesome repo »