Data sources, connectors & refresh
How this is scored
Which data the product can reach and how it stays current: native connectors to databases and warehouses (PostgreSQL, MySQL, SQL Server, BigQuery, Snowflake), to business applications (accounting, ERP, CRM, shop, help desk, ad platforms) and to files and spreadsheets (Excel, CSV, Google Sheets), live queries versus imported extracts, scheduled and incremental refresh with its minimum interval, joining data from several sources, light data preparation, access to databases behind a firewall (gateway, SSH tunnel, IP allow-list), and a generic REST or custom connector for what is not listed.
0 — Not a reporting product, or data can only be typed or pasted in by hand.
3 — Spreadsheet and file uploads plus a handful of named connectors; refresh schedules, live queries and blending sources are basic or not described.
5 — A published connector list covering the common databases, warehouses, spreadsheets and several named business applications, scheduled refresh with its interval stated, live queries or extracts at the customer's choice, data from two sources combined in one report, and a documented way to reach a database behind a firewall.
8 — Hundreds of maintained connectors or a full SQL layer over every major warehouse, incremental refresh and caching explained, a built-in data preparation or modelling step, a gateway or agent for on-premise sources, a generic REST or custom connector SDK, and connector limits (rows, API calls, history) stated per plan.
10 — Connectivity an organisation can standardise on: every source reachable live or by extract with the trade-offs documented, refresh down to minutes with lineage from report back to source, source changes detected and reported, and connector behaviour, quotas and failure handling published.
The IT Administrator
Imports and blending from 500+ databases, SaaS apps and cloud platforms are documented (the captured pages give different figures for source count, 250+ and 500+), with more than 50 ready-made business-app connectors and file support from Excel and CSV through Parquet and spatial formats. Live Connect queries the database directly and stores no data on Zoho's servers, while the Zoho Databridge is a lightweight, secure utility for on-premise databases with scheduled automatic syncs; refresh runs up-to-the-minute for select integrations or hourly, daily and weekly otherwise, with workflows on success, partial success or failure. A no-code custom connector builder, SDKs in six languages, data preparation with over 250 transformations and per-plan row limits from 0.5 million to 50 million are stated; I found no public information on lineage from report back to source or documented connector quotas beyond rows. 2 3 6 8