Connect CData Connect AI to Well

From Well, open Connections, find CData Connect AI, and click Connect. Well discovers the OAuth metadata at mcp.cloud.cdata.com/mcp/.well-known/oauth-authorization-server, registers a client on the fly via Dynamic Client Registration, and walks you through the authorize prompt on CData Connect AI's side. No client_id or client_secret to paste; the handshake takes roughly a minute.

Well brings in table row, source, and query from CData Connect AI and reshapes each entity into your workspace: table row becomes indexed record; source becomes workspace context. Every record arrives with the source identifier preserved, so CData Connect AI stays the source of truth while Well lets you query the data alongside the rest of your stack.

Well tracks the last sync watermark per table and only requests rows that changed since then, using whatever incremental marker CData Connect AI exposes (last_updated, sequence_id, or partition key). Backfills run in the background on first connect; subsequent reads stay cheap and the load on CData Connect AI's side stays bounded.

Well watches for updates to table rows and applies them on the next sync, preserving the original workspace identifier so anything downstream (records tables, conversation history, agent runs) keeps pointing at the right indexed record. Edits flow in incrementally; nothing is duplicated, and the CData Connect AI source identifier is retained on every revision.

Well combines live CData Connect AI events with periodic reconciliation reads of table row, source, and query. New rows appear within seconds when CData Connect AI pushes them; periodic reads catch anything a push missed. The first connect backfills history from CData Connect AI in the background.

Open Connections > CData Connect AI in Well and click Disconnect. Well calls CData Connect AI's token revocation endpoint and stops calling CData Connect AI immediately on its side; provider-side propagation to CData Connect AI's admin panel varies by provider. The table row, source, and query Well already synced stay in your workspace by default; ask Support to purge them if your compliance flow requires it.

CData Connect AI records are stored in the region Well operates for your workspace. Specific region details and the steps to change region are available from Support. See /privacy for the current data-handling policy.