Zoho CloudSQL
Zoho CloudSQL is an API service extension 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 databases and data marts, it provides a much familiar and expressive development model for developers, thus making it easy to adopt and develop upon.
Key Highlights of Zoho CloudSQL:
- Use SQL to interact with your business data stored across Zoho services
- Use any major SQL dialect (ANSI, Oracle, SQL Server, IBM DB2, MySQL, PostgreSQL and more)
- Supports INSERT, UPDATE, DELETE and SELECT SQL statements
- Snap-in JDBC/ODBC Drivers for easy connectivity
- Implement easily in both traditional in‐house software and hosted/SaaS applications
Adoption in Zoho:
Currently Zoho Reports supports Zoho CloudSQL in its API. The current capabilities of CloudSQL supported in Zoho Reports are listed below:
- Supports only SQL SELECT Statement (other SQL Statements like INSERT, UPDATE and DELETE will be supported very soon)
- Supports only JDBC (Java Database Connectivity) drivers. You could execute SQL SELECT statements currently through the JDBC driver. ODBC Drivers will be supported very soon.
Refer to this Zoho Reports - CloudSQL documentation for more details.
Zoho CloudSQL will soon be adopted across all Zoho Services that offer structured data for manipulation and querying
To know more about Zoho CloudSQL checkout: http://cloudsql.zoho.com/
