Zoho CloudSQL

Zoho CloudSQL is a middleware technology that allows customers to interact with their business data stored in Zoho Analytics through familiar SQL language. Users can access the data in Zoho Analytics using SQL SELECT queries.

WHAT IS ZOHO CLOUDSQL?

Zoho with its wide range of hosted productivity and business applications collects, mines and exposes a lot of structured and unstructured data to users. For developers working over the Zoho Platform, to extend and customize the various web services, it offers a comprehensive Web API over HTTPS for most of the Zoho Services. Currently Zoho Web API is the means to access and manipulate the data collected by the various Zoho services. But one drawback with the current Web API over HTTPS is the non-standard interface for querying and data manipulation, which could add up to the learning curve, adoption and maintenance.

Zoho CloudSQL is a platform API service that enables developers to use Standard SQL (Structured Query Language) querying over the Web, to access and manipulate data that is available in various Zoho Services in the Cloud (hence the name CloudSQL). SQL being a standard query language of Workspaces and data marts, it provides a much familiar and expressive development model for developers, thus making it easy to adopt and develop upon. With CloudSQL, Zoho Platform becomes first of its kind to offer full fledged standard SQL Querying over the Web.

Developers could execute SELECT, INSERT, UPDATE and DELETE SQL statements over the Web to handle the data in Zoho Services with CloudSQL. Another powerful facet of CloudSQL is the support for multiple SQL dialects which could be used by developers to construct their SQL queries. CloudSQL supports SQL queries written in any of ANSI, Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL and Informix dialects. This enables developers to easily adopt CloudSQL, if they are familiar in any one of the Workspace dialects mentioned.

ZOHO ANALYTICS AND ZOHO CLOUDSQL

Zoho Analytics, the online reporting and business intelligence service, is the first Zoho service to adopt Zoho CloudSQL. Developers could execute SQL SELECT statements over the web to handle the data in Zoho Analytics.

KEY HIGHLIGHTS OF ZOHO ANALYTICS CLOUDSQL IMPLEMENTATION

The key highlights of Zoho Analytics CloudSQL implementation are:

• SQL querying over HTTPS
  • Currently it supports SELECT querying over HTTPS
  • INSERT, UPDATE and DELETE statements will be supported soon
• Supports SQL Querying in multiple dialects including ANSI, Oracle, Microsoft SQL Server, IBM DB2, MySQL, Sybase, PostgreSQL and Informix dialects. Users can execute queries written in any of this dialects.
• Enables application connectivity using Zoho Analytics JDBC driver to interact with the Zoho Analytics Service.
  • ODBC driver will be supported soon