The table below states, connector by connector, which can be registered and used today and which the product refuses to configure.
Sheets per connector:
conectores/fichas.md— one page per connector, with fields, credentials, limits and common errors.Read first:
README.md(vocabulary of states + template of the 9 fields). This page is the public state map of connectors — the detailed operational step-by-step lives in the internal operational runbook and is not duplicated here.
Two vocabularies, and why both exist#
Confusing the two produced the contradiction between the homepage and this page: the former showed Available and the latter said Preview for the same connector. They are different axes, and both remain valid.
| Axis | Values | What it answers |
|---|---|---|
| Public state (the site badge and the connections screen) | Available · Limited access · Planned | Can I use this today? |
| Maturity (internal engineering vocabulary) | GA-candidate · Preview · Roadmap | How much evidence is behind it? |
Rules that apply on both surfaces, without exception:
- "Available" = usable today, in the product's normal flow, with the credential from your source. The platform's availability commitment is the plan SLA (99.5% per month from Growth — see /legal/sla); the connector state says whether it accepts registration today.
- "Limited access" always comes with the concrete condition written on the connector's page — "limited access" without condition would be an empty promise.
- "Planned" is what does not exist yet. No surface offers a "use today" button for these.
Catalog state (the product truth)#
The public state of each connector is derived from the catalog, not retyped.
disponivel → Available; estrutura → Limited access; roadmap →
Planned. The "Configuration" column says whether the product refuses to register the
source today — and that refusal is the only case where use depends on contacting
support.
| Connector | id | Category | Public state | Maturity | Configuration | Auth |
|---|---|---|---|---|---|---|
| Google Sheets | google_sheets | Spreadsheets and collaboration | Available | GA-candidate | accepted | service account |
| CSV | csv | Files | Available | GA-candidate | accepted | upload to the landing area |
| JSON | json | Files | Available | GA-candidate | accepted | upload to the landing area |
| Parquet | parquet | Files | Available | GA-candidate | accepted | upload to the landing area |
| PostgreSQL | postgresql | Databases | Available | GA-candidate | accepted | user/password (network: IP, SSH, Cloud SQL, VPN) |
| SQL Server | sqlserver | Databases | Available | GA-candidate | accepted | user/password |
| Oracle | oracle | Databases | Available | GA-candidate | accepted | user/password |
| MySQL | mysql | Databases | Available | GA-candidate | accepted | user/password |
| MariaDB | mariadb | Databases | Limited access | Preview | accepted | user/password |
| Amazon Redshift | amazon_redshift | Databases | Limited access | Preview | accepted | user/password |
| CockroachDB | cockroachdb | Databases | Limited access | Preview | accepted | user/password |
| Supabase | supabase | Databases | Limited access | Preview | accepted | user/password |
| Neon | neon | Databases | Limited access | Preview | accepted | user/password |
| TimescaleDB | timescaledb | Databases | Limited access | Preview | accepted | user/password |
| AlloyDB | alloydb | Databases | Limited access | Preview | accepted | user/password |
| Azure SQL | azure_sql | Databases | Limited access | Preview | accepted | user/password |
| bigquery | bigquery | Databases | Available | GA-candidate | accepted | service account |
| ClickHouse | clickhouse | Data warehouses | Limited access | Preview | accepted | username and password (Basic) |
| Databricks SQL | databricks_sql | Data warehouses | Limited access | Preview | accepted | access token |
| Elasticsearch | elasticsearch | Data warehouses | Limited access | Preview | accepted | username and password (Basic) |
| Cloud Firestore | firestore | Data warehouses | Limited access | Preview | accepted | service account |
| Snowflake | snowflake | Data warehouses | Limited access | Preview | accepted | key pair (private key) |
| Trino | trino | Data warehouses | Limited access | Preview | accepted | username and password (Basic) |
| Omie ERP | omie | ERP and management | Limited access | Preview | accepted | App Key / App Secret |
| Bling ERP | bling | ERP and management | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Conta Azul | conta_azul | ERP and management | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Tiny ERP | tiny | ERP and management | Limited access | Preview | accepted | access token |
| NF-e (SEFAZ) | nfe | ERP and management | Limited access | Preview | accepted | A1 certificate (.pfx) |
| Dynamics 365 | dynamics_365 | ERP and management | Limited access | Preview | accepted | client id/secret (OAuth 2.0) |
| NetSuite | netsuite | ERP and management | Limited access | Preview | accepted | OAuth 1.0a |
| Nibo | nibo | ERP and management | Limited access | Preview | accepted | API key |
| Odoo | odoo | ERP and management | Limited access | Preview | accepted | session login |
| QuickBooks Online | quickbooks | ERP and management | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Sankhya | sankhya | ERP and management | Limited access | Preview | accepted | session login |
| SAP Business One | sap_business_one | ERP and management | Limited access | Preview | accepted | session login |
| SAP S/4HANA | sap_s4hana | ERP and management | Limited access | Preview | accepted | username and password (Basic) |
| Senior | senior | ERP and management | Planned | Roadmap | refused | client id/secret (OAuth 2.0) |
| TOTVS Protheus | totvs_protheus | ERP and management | Planned | Roadmap | refused | API key |
| iFood | ifood | E-commerce and marketplaces | Limited access | Preview | accepted | client id/secret (OAuth 2.0) |
| Loja Integrada | loja_integrada | E-commerce and marketplaces | Limited access | Preview | accepted | API key |
| Magento 2 (Adobe Commerce) | magento2 | E-commerce and marketplaces | Limited access | Preview | accepted | access token |
| Mercado Livre | mercado_livre | E-commerce and marketplaces | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Nuvemshop | nuvemshop | E-commerce and marketplaces | Limited access | Preview | accepted | access token |
| Shopify | shopify | E-commerce and marketplaces | Limited access | Preview | accepted | access token |
| Tray Commerce | tray | E-commerce and marketplaces | Limited access | Preview | accepted | access token |
| VTEX | vtex | E-commerce and marketplaces | Limited access | Preview | accepted | API key |
| WooCommerce | woocommerce | E-commerce and marketplaces | Limited access | Preview | accepted | username and password (Basic) |
| Asaas | asaas | Payments and finance | Limited access | Preview | accepted | API key |
| Granatum | granatum | Payments and finance | Limited access | Preview | accepted | API key |
| Mercado Pago | mercado_pago | Payments and finance | Limited access | Preview | accepted | access token |
| Pagar.me | pagarme | Payments and finance | Limited access | Preview | accepted | username and password (Basic) |
| PagBank | pagbank | Payments and finance | Planned | Roadmap | refused | access token |
| Stripe | stripe | Payments and finance | Limited access | Preview | accepted | access token |
| Vindi | vindi | Payments and finance | Limited access | Preview | accepted | username and password (Basic) |
| Salesforce | salesforce | CRM and support | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| HubSpot | hubspot | CRM and support | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Agendor | agendor | CRM and support | Limited access | Preview | accepted | API key |
| Freshdesk | freshdesk | CRM and support | Limited access | Preview | accepted | username and password (Basic) |
| Intercom | intercom | CRM and support | Limited access | Preview | accepted | access token |
| Moskit CRM | moskit | CRM and support | Limited access | Preview | accepted | API key |
| Movidesk | movidesk | CRM and support | Limited access | Preview | accepted | API key |
| Pipedrive | pipedrive | CRM and support | Limited access | Preview | accepted | API key |
| Ploomes | ploomes | CRM and support | Limited access | Preview | accepted | API key |
| RD Station CRM | rd_station_crm | CRM and support | Limited access | Preview | accepted | API key |
| RD Station Marketing | rd_station_marketing | CRM and support | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Zendesk | zendesk | CRM and support | Limited access | Preview | accepted | username and password (Basic) |
| Zoho CRM | zoho_crm | CRM and support | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Meta Ads (Facebook and Instagram) | meta_ads | Marketing and analytics | Available | GA-candidate | accepted | access token |
| Google Ads | google_ads | Marketing and analytics | Available | GA-candidate | accepted | OAuth 2.0 (refresh token) |
| ActiveCampaign | activecampaign | Marketing and analytics | Limited access | Preview | accepted | API key |
| Brevo | brevo | Marketing and analytics | Limited access | Preview | accepted | API key |
| Eduzz | eduzz | Marketing and analytics | Limited access | Preview | accepted | access token |
| Google Analytics 4 | google_analytics_4 | Marketing and analytics | Limited access | Preview | accepted | service account |
| Google Search Console | google_search_console | Marketing and analytics | Limited access | Preview | accepted | service account |
| Hotmart | hotmart | Marketing and analytics | Limited access | Preview | accepted | client id/secret (OAuth 2.0) |
| Kiwify | kiwify | Marketing and analytics | Limited access | Preview | accepted | client id/secret (OAuth 2.0) |
| Klaviyo | klaviyo | Marketing and analytics | Limited access | Preview | accepted | API key |
| LinkedIn Ads | linkedin_ads | Marketing and analytics | Limited access | Preview | accepted | access token |
| Mailchimp | mailchimp | Marketing and analytics | Limited access | Preview | accepted | username and password (Basic) |
| Pinterest Ads | pinterest_ads | Marketing and analytics | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| TikTok Ads | tiktok_ads | Marketing and analytics | Limited access | Preview | accepted | API key |
| Typeform | typeform | Marketing and analytics | Limited access | Preview | accepted | access token |
| Airtable | airtable | Productivity and HR | Limited access | Preview | accepted | access token |
| Asana | asana | Productivity and HR | Limited access | Preview | accepted | access token |
| ClickUp | clickup | Productivity and HR | Limited access | Preview | accepted | API key |
| Gupy | gupy | Productivity and HR | Limited access | Preview | accepted | access token |
| Jira | jira | Productivity and HR | Limited access | Preview | accepted | username and password (Basic) |
| monday.com | monday | Productivity and HR | Limited access | Preview | accepted | API key |
| Notion | notion | Productivity and HR | Limited access | Preview | accepted | access token |
| Slack | slack | Productivity and HR | Limited access | Preview | accepted | access token |
| Trello | trello | Productivity and HR | Limited access | Preview | accepted | API key |
| Twilio | twilio | Productivity and HR | Limited access | Preview | accepted | username and password (Basic) |
| Banco Central (SGS) | bcb_sgs | Public data | Limited access | Preview | accepted | no credential (public data) |
| BrasilAPI | brasilapi | Public data | Limited access | Preview | accepted | no credential (public data) |
| IBGE (SIDRA) | ibge | Public data | Limited access | Preview | accepted | no credential (public data) |
| Backblaze B2 | backblaze_b2 | Object storage | Limited access | Preview | accepted | API key |
| Cloudflare R2 | cloudflare_r2 | Object storage | Limited access | Preview | accepted | API key |
| DigitalOcean Spaces | digitalocean_spaces | Object storage | Limited access | Preview | accepted | API key |
| MinIO | minio | Object storage | Limited access | Preview | accepted | API key |
| Wasabi | wasabi | Object storage | Limited access | Preview | accepted | API key |
| Amazon S3 | s3 | Object storage | Limited access | Preview | accepted | access key / service account |
| gcs | gcs | Object storage | Limited access | Preview | accepted | access key / service account |
| Azure Blob Storage | azure_blob | Object storage | Limited access | Preview | accepted | SAS token or OAuth (Microsoft Entra ID) |
| Dropbox | dropbox | Remote files | Limited access | Preview | accepted | OAuth 2.0 (refresh token) |
| Google Drive | google_drive | Remote files | Limited access | Preview | accepted | service account |
| HTTP File | http_file | Remote files | Limited access | Preview | accepted | access token |
| OneDrive / SharePoint | onedrive_sharepoint | Remote files | Limited access | Preview | accepted | client id/secret (OAuth 2.0) |
| SFTP | sftp | Remote files | Limited access | Preview | accepted | username and password (Basic) |
| Generic OData | odata_generica | Generic APIs | Limited access | Preview | accepted | username and password (Basic) |
| Generic REST API | rest_api_generica | Generic APIs | Limited access | Preview | accepted | access token |
Conditions of use — connectors whose configuration the product refuses today (the text is the same as the public connector page):
- Senior (
senior) — It is not yet possible to connect Senior by yourself: API access depends on a credential from an approved partner. Today the data enters via scheduled exports to the landing area of your environment. - TOTVS Protheus (
totvs_protheus) — It is not yet possible to connect TOTVS Protheus by yourself: the REST API varies by version and environment customization. Today the data enters via scheduled exports (CSV/JSON) to the landing area of your environment. - PagBank (
pagbank) — It is not yet possible to connect PagBank by yourself: the API queries one charge at a time, by its number, and does not return the account's list of charges. Today the path is to export the statement and upload it to the landing area of your environment.
Today the catalog has 110 connectors: 11 Available, 96 Limited access and 3 Planned.
<!-- gen:conectores-tabela:fim -->Connectors that do not appear in "Conditions of use" do not depend on any case-by-case approval: they depend on the credential from your source and on the cloud environment of your workspace being configured (without it the run fails, with a message, rather than pretending success).
The R/Python script runner remains unavailable due to unverified isolation. It is not a connector: it is isolated script execution.
Sheet per family (template of the 9 fields)#
BR ERP/Fiscal connectors — Omie, Bling, Conta Azul, Tiny, NF-e
- State — Limited access for all five. All five accept registration today: since Onda 15 the automatic renewal of access (rotation of Bling and Conta Azul refresh tokens) is persisted by the platform, and the refusal to configure no longer exists. None of them is announced as generally available.
- What it does — extracts business tables (orders, products, finance, NF-e) from the ERP API and loads into the Bronze layer of the workspace.
- How it works — each connector is just an adapter over the common connectors SDK: normalized auth, pagination with hard cap, resume checkpoint, retry with
Retry-After, redaction and metrics come for free. The same contract suite runs against all five. - Plan · Permission — product core · access verification (active workspace) · execução de ingestão by capacity. Real extraction requires the source's encrypted credential.
- Cost — extraction itself is an ERP API call (R$0 on the platform); the Bronze load consumes datalake load processing (billable) — see
custo-limites-seguranca.md. - Limits — pagination with hard cap (default 10,000 pages / 5,000,000 rows); SaaS load default
batchSize 5,000,maxRows 200,000. - Security — secret (App Secret, refresh token, certificate password) enters secret redaction; no error leaks a token. Scope by workspace at load.
- How to validate — in the console, under ETL/ELT → Connections, use "Testar conexão" with the source credential and confirm that discovery lists the expected tables; after a load, check the Bronze layer of your workspace for the ingested rows. The catalog shows the state ("Preview until certification with real credential").
- In short — "<Connector> in Limited access — the condition of use is written on the connector's page."
Ads connectors — Meta Ads and Google Ads
- State — Limited access; both accept registration. Meta Ads depends on Meta App Review (
ads_read) for broad use; Google Ads depends on the developer token basic→standard. - What it does — Meta Ads reads the Insights endpoint (one row per day,
time_increment=1) into 3 Bronze tables (meta_ads_campanhas/_conjuntos/_anuncios). Google Ads reads performance reports (campaign/group/keyword). - How it works — adapters on the common SDK, with transport retry (429/5xx +
Retry-After) and checkpoint. Google Ads refuses ingestion in production while the developer token is not approved (it never pretends success). - Plan · Permission — core · access verification · execução de ingestão.
- Cost — calls to Ads APIs (R$0 platform) + Bronze load billable.
- Limits — configurable date windows (7/14/30/90 days, current/previous month); same SDK pagination caps.
- Security — access token / client secret / developer token / refresh token redacted in every error.
- How to validate — in the console, connect the ad account and run "Testar conexão"; confirm that the Insights/report tables appear in discovery and, after a load, in your workspace Bronze. While the app is not approved, production ingestion is refused with a clear warning.
- In short — Limited access, the same label used by the landing and the product: there is no "coming soon" badge anywhere. Moving up a state depends on App Review (Meta) and an approved developer token (Google).
Google Sheets
- State — Available: can be registered and used today, without case-by-case approval.
- What it does — reads sheets of a spreadsheet (actual columns, configurable header) and loads into Bronze.
- How it works — adapter with pagination by window of rows and checkpoint (
{row, columns}); "Test connection" indicates the service account email to authorize. - Plan · Permission — core · access verification · execução de ingestão.
- Cost — spreadsheet read R$0; Bronze load billable.
- Limits — SDK caps; a renamed sheet does not bring down the others (error is in the table, the loop continues).
- Security — service account JSON (and its
private_key) redacted; scope by workspace. - How to validate — in the console, authorize the service account email on the spreadsheet, run "Testar conexão" and confirm that sheets/columns appear; after the load, see the rows in Bronze.
- In short — "Google Sheets Available — registration and extraction in the normal flow."
Salesforce · HubSpot · Azure Blob
- State — Limited access. All three accept registration since Onda 15: HubSpot automatic access renewal is persisted by the platform and reading the Azure Blob container began being called by the same flow as other source connectors.
- What it does — Salesforce/HubSpot read CRM objects/entities; Azure Blob reads files from a container.
- How it works — adapters on the common SDK (Azure Blob has resume by blob name: blob ≤ last processed is skipped, not reprocessed).
- Plan · Permission — core · access verification · execução de ingestão.
- Cost — API/read R$0; Bronze load billable.
- Limits — SDK caps.
- Security — credentials redacted; scope by workspace.
- How to validate — in the console, connect the source, run "Testar conexão" and confirm discovery of entities/files; after the load, see the rows in your workspace Bronze.
- In short — "<Connector> in Limited access — the condition of use is written on the connector's page."
Declarative connectors from Onda 15 — ERPs, e-commerce, payments, CRM, marketing, productivity, public data, warehouses, remote files, generic APIs and compatible databases
- State — Limited access for all new connectors; Planned for TOTVS Protheus, Senior and PagBank (configuration refused with the reason). The list with each one's state is the generated table above — no counts are retyped here.
- What it does — each connector reads the resources listed in its sheet (orders, customers, charges, deals, campaigns, tasks, public series, warehouse tables, files from a folder or bucket…) and loads into the Bronze layer, one table per resource.
- How it works — the connector is a declarative specification (auth, pagination, resources and columns) executed by ONE engine per family: REST, HTTP SQL (ClickHouse, Trino, Databricks, Snowflake) and remote files (S3 and compatibles, gcs, SFTP, Drive, Dropbox, OneDrive/SharePoint, HTTP). Compatible databases (MariaDB, Redshift, CockroachDB, Supabase, Neon, TimescaleDB, AlloyDB, Azure SQL) run via the base engine driver. The same contract suite used for hand-written connectors runs against each one, with a simulator derived from the specification itself.
- Plan · Permission — core · access verification · execução de ingestão.
- Cost — calls to API/read of the source R$0 on the platform; Bronze load billable.
- Limits — SDK caps (pages/rows); complete extraction on each run (no incremental windowing by the scheduler); execution time limited to the function. The provider's thread format came from public documentation, without real credential — the condition is in the
ownerBlockerof each connector. - Security — every sensitive field is encrypted (AES-256-GCM) and enters secret redaction; renewed tokens enter the live list; no error leaks credential.
- How to validate — in the console, choose the connector, fill your account credential, run "Testar conexão" (a small call to the cheapest resource) and confirm discovery of resources; after the load, check the rows in Bronze. Format divergence is expected on first contact with the real API: it becomes a spec correction before the 30-day gate.
- In short — "<Connector> in Limited access — the condition of use is written on the connector's page." For Planned: "Not yet possible to use today — the condition is on the page."
The common SDK (why "new connector = adapter + contract suite")#
The common connectors SDK is pure (no I/O of its own; network transport is injected). A new connector only writes test/discover/extract; the rest comes from the adapter factory:
| Piece | Guarantee |
|---|---|
| Auth | normalized credential; the SDK knows how to extract sensitive material for redaction |
| Pagination | generator with hard cap and anti-loop guard (cursor that does not advance terminates) |
| Checkpoint | injectable contract; reads before extracting, writes each batch, cleans on completion (next run starts from zero) |
| Retry | exponential backoff + deterministic jitter, respects Retry-After; retries only 429/5xx and network errors |
| Redaction | every error/log passes through secret redaction (raw, URL-encoded, JSON) |
| Metrics | one telemetry line per operation (rows/bytes/ms/ok) — telemetry never breaks the extraction |
Contract suite: the same battery proves, for each adapter, that thrown errors are always redacted, metrics are always emitted and checkpoint resumes without duplicating or losing rows.
Schema drift and observability#
- Schema drift: compares saved baseline × discovered schema. New column/table →
info; removed column / type changed / removed table →attention(breaks the mart). It's pure logic; where the baseline is persisted is the caller's decision. - Observability: aggregates events into runs, error rate, p50/p95, freshness. Thresholds: error ≥ 20% → degraded; p95 > 30 s → degraded; not run > 26 h → degraded, > 72 h → stopped.
Connector certification (never automatic)#
Certification runs live probes (transport injected, without network) against the real adapter: honest status in the catalog · conformant adapter · discover with ≥1 table · active redaction (plants a sentinel-secret and requires it not to leak) · checkpoint supported. The human items (30 days with real credential, reconciliation against provider reports, token rotation, quotas with real traffic) are done by our team, connector by connector — so the automatic probe never promotes a connector on its own.