Does Zoho Analytics support SQL (Structured Query Language) Querying?

Does Zoho Analytics support SQL (Structured Query Language) Querying?

Yes, Zoho Analytics supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL.

You can use SQLs from any of the below methods: 

  • From the Zoho Analytics User Interface, create Query Tables to execute SQL SELECT queries in Zoho Analytics. You can then generate reports over the Query Table created. Check out this Video on Creating Query Tables
  • Use Zoho CloudSQL API to execute SQL SELECT queries on Zoho Analytics. You could use Zoho CloudSQL API when you want to integrate Zoho Analytics within your own applications.

    • Related Articles

    • What is Zoho Analytics?

      Zoho Analytics is an on-demand reporting and business intelligence solution that helps you get new insights on your business information through its powerful and flexible online business intelligence engine. You get powerful reports in minutes, with ...

    • What are the SQL Dialects supported by Zoho Analytics?

      Zoho Analytics supports SQL written in a wide variety of popular database dialects. It currently supports Oracle, SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL database dialects.

    • Does Zoho Analytics support Relational modeling?

      Yes, Zoho Analytics supports relational modeling of your database. There are some limitations currently, which would be addressed incrementally to provide a powerful relational modeling capability in Zoho Analytics. The following are the important ...

    • What is the difference between Zoho Analytics and Zoho Creator?

      The key difference between Zoho Analytics and Zoho Creator is in-depth reporting and analytics vs online custom database application creation. Zoho Analytics enables you to easily create powerful and sophisticated reports with your data by creating ...

    • Can Zoho Analytics be used as an Online Database?

      Zoho Analytics is an Online Reporting and Business Intelligence service. The features offered by Zoho Analytics specializes on providing in-depth, powerful and flexible reporting and analytical capabilities. It contains an in-built database grid ...