Connecting Cloud Databases to Zoho Analytics

Importing Data from Cloud Databases into Zoho Analytics

Zoho Analytics can connect directly to a wide range of cloud-hosted databases, letting you import data for reporting and analysis without needing to export files manually. Setup is handled through a guided wizard that simplifies the connection process for each supported platform.

Supported Cloud Database Platforms

  • Amazon RDS
  • Amazon Redshift
  • Amazon Athena
  • Amazon Lightsail
  • Microsoft SQL Azure
  • Google BigQuery
  • Google Cloud SQL
  • Snowflake
  • Oracle Cloud
  • IBM Cloud
  • Heroku PostgreSQL
  • MongoDB Atlas
  • Panoply and SingleStore
  • Digital Ocean
  • Atlas Data Federation

How to Connect a Cloud Database

From your Zoho Analytics workspace, navigate to Import Your Data and select the relevant cloud database platform from the list of connectors. The import wizard guides you through the connection settings specific to that platform, including credentials, host details, and the tables or queries you wish to import.

Scheduling and Automation

Once a cloud database connection is established, you can configure a scheduled synchronisation to automatically refresh your Zoho Analytics tables at regular intervals. This keeps your dashboards and reports up to date without manual intervention.

Note: Connection requirements vary by platform. Refer to the individual connector documentation for specific host, port, authentication, and firewall settings required for each cloud database provider.
Need help? 1 Cloud Consultants can configure cloud database connections to Zoho Analytics and set up automated syncs to ensure your reporting data is always current. Book a discovery call with 1 Cloud Consultants.