A Database Connector in Zoho Analytics is a pre-built integration that establishes a direct connection to a relational database such as MySQL, PostgreSQL, Microsoft SQL Server, or Oracle, enabling data import or live query from the database into workspace tables.
Use Database Connector when your reporting requirements go beyond what built-in defaults provide. This feature is most valuable for organisations that have moved past basic data viewing and need precise control over how their data is organised, queried, or presented. Teams working with multiple data sources, varied user groups, or complex business logic will find this capability central to their Zoho Analytics setup.
Before configuring Database Connector, ensure that the underlying data tables are clean and consistently structured. Irregular naming conventions, mixed data types in a single column, or missing values can produce unexpected results. For shared environments, coordinate with your Workspace Administrator before making changes that affect reports used by other team members. Testing on a duplicate report before applying changes to production dashboards is a sound practice.
A Database Connector connects Zoho Analytics directly to a relational database by specifying the host, port, database name, and credentials. Zoho Analytics can then import selected tables or run custom SQL queries to populate workspace tables, either as a one-time import or on a schedule.
Zoho Analytics supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Amazon Aurora, Amazon Redshift, Azure SQL, Google BigQuery, Snowflake, and several others. For on-premise databases, you may need the Zoho Analytics On-Premise Gateway to enable connectivity.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.