gettingstarted

Login into Zoho Reports (you need a Zoho User id) and create a database on which you would like to execute the SQL queries. Checkout the help videos on Zoho Reports

Alternatively, you can create a copy of the sample Store Sales database to try out Zoho CloudSQL

Download the appropriate Client Library or JDBC Driver based on the programming language you are going to use.

• Download JDBC Driver if you are going to try out CloudSQL using Java
• Download Python Client Library, if you are going to use Python
• If you are not using any of the above language specific libraries, you must use the direct Zoho Reports HTTP API for executing the SQL Select Query from within your programming language.

Executing SQL Select statements

• If you are using JDBC Driver for connectivity, follow the instructions in this page to query using JDBC Driver
• If you are using Python Client library, go through sample file Sample.py in the Python Client library to know about how to execute a SQL Query
• If you are using any other programming language, you need to use the Zoho Reports HTTP Export API to execute a SQL Query. You need to use the appropriate libraries in that language to make HTTP requests.