Database

Connecting an existing database (PostgreSQL, SQL Server, Azure Data Explorer, MySQL, MongoDB) isn't a one-click connector yet. Here's how to get database data into your workshop today, and what's coming.

Today: pull it through an API Source

If your database is reachable behind an HTTP endpoint - an internal API, a reporting endpoint, or a small serverless function that runs your query and returns JSON - point an API Source at it. OpenX polls it on a schedule and the rows flow onto your surface like any other feed.

Don't have an endpoint? Stand up a tiny read-only one: a serverless function (Azure Functions, etc.) that runs SELECT ... and returns JSON, then poll it with an API Source. Use a read-only account and keep credentials in your secret store.

Building / testing

Before the integration is ready, shape representative rows with the Simulator so you can build the surface and warm query now.

Coming

Native database connectors and a push-ingest endpoint - send rows straight to a connection without standing up your own endpoint or sharing database credentials - are on the roadmap.

Then

Route it to a Surface and crystallize a Warm Query.