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

Marketing wants a new ad channel in next week's cross-channel report, and its endpoint can offer a hundred fields under API names like date_start. Store them all, and business users wade through unused columns and ask you what each one means. In a Connector Data Mart, you pick the fields that land and name each one for business.

  • The unique-key fields the connector merges rows on stay selected, however few fields you tick.
  • Only the fields you tick are stored in your warehouse; the alias lives in the Output Schema, so the stored column keeps its name.
  • Google Sheets headers and Data Studio's field list show the alias, not the API field name.
  • Ask Claude or ChatGPT about spend through OWOX MCP, and it receives each field's alias and description, not just an API name like date_start to guess at.
Scheduling

F04

Scheduling

A report people open every morning is only as fresh as its last run, and a stale one looks exactly like a current one. Triggers import the source and deliver the report on a schedule you set on the Data Mart.

  • Run it every working day, on a set date each month, at set times on chosen days of the week, or on an interval, each trigger in its own timezone.
  • A failed run emails Project Admins and Data Owners, or calls your webhook, on by default; Run History shows the error and every run's status.
  • You set the order: the connector imports into your warehouse first, then each report delivers.
Learn more

Recent updates