Data Connectors

Every Source You Report On, Wherever You Need the Answer

OWOX’s connectors collect each source into the warehouse you own, then deliver it where the question is actually asked: Google Sheets and Excel, Data Studio and your BI tool, ChatGPT and Claude or email. Only the fields you picked, on the schedule you set, defined once and reused by every one of them. Every connector is MIT-licensed and lightweight, free to self-host; in OWOX Cloud all of them are in every plan, with no per-connector bill.

From
To

Features

Data Connectors Features

Connector Data Marts

F01

Connector Data Marts

Ad, e-commerce and reference data scattered across APIs cannot be joined or trusted until it lands in one place. OWOX's open-source connectors bring 15 first-party sources into your own warehouse with no per-connector fee — as Connector Data Marts holding the fields you choose, ready for spreadsheets, BI and AI Insights.

Custom Connectors

F02

Custom Connectors

When a report needs a source OWOX has no connector for, the usual answers are a vendor roadmap, a script only its author can fix, or a CSV exported by hand every month. With Custom Connectors, your AI assistant writes that connector from the API's docs.

  • Give the assistant OWOX's manifest guide and the API's documentation, then import the JSON it returns.
  • Test it against the live API before anything depends on it; every publish is a version you can roll back.
  • The data loads into your own warehouse as a scheduled Data Mart, and keys stay in OWOX, never with the assistant.
Learn more
Field Selection & Aliases

F03

Field Selection & Aliases

A connector that stores everything an API returns makes you pay for and wade through columns nobody uses. Schema Adjustment lets you pick the fields to land — the connector keeps the keys it needs to merge rows — and give columns business-friendly aliases, so campaign_id_str reads as "Campaign ID" in BI and spreadsheets.

Scheduling

F04

Scheduling

A report opened before its data refreshes shows yesterday's numbers. Schedules fire connector runs and report deliveries, so Sheets, dashboards and AI briefings open with current data — no manual runs, no stale reports.

Learn more