zoho cloud sql
TRANSCRIPT
CloudSQL
Let users store and interact with business data stored in the cloud via SQL
CloudSQL
CloudSQLLet users store and interact with business data stored in the cloud via SQL
Access Business Data in the Cloud Through SQL
CloudSQL
Access Business Data in the Cloud Through SQL
CloudSQL
IntroductionCloudSQL
Zoho CloudSQL is a middleware technology that allows
customers to interact with their business data stored in Zoho
through the familiar SQL language. Customers are able to access
Zoho cloud data using SQL on both other cloud applications as
well as through traditional on-premises software.
At a high-level, Zoho CloudSQL serves as the bridge between
the external application and the data stored inside Zoho. It
receives the query in SQL, interprets it, delegates queries and
aggregates results across the Zoho services.
Rodrigo VacaVP Marketing at Zoho
““
Architecture OverviewCloudSQL
Architecture OverviewCloudSQL
SQL Interpreter
Zoho CloudSQL supports multiple database dialects: ANSI, Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL and Informix dialects.
The main purpose of the SQL Interpreter component is to translate the SQL statements that are executed by the third party application into a neutral dialect that can be understood by the individual Zoho Services.
The SQL Interpreter also generates an internal SQL model that is passed into the Federation layer.
Architecture OverviewCloudSQL
Federation Layer
The federation layer understands the SQL Model and handles the following two functions:
Service specific Query delegationFrom the SQL model it will identify the Zoho services to which the query has to be delegated, and delegate the queries to the corresponding Zoho Service for execution.
Result AggregationOnce the query is executed across the Zoho Services, it will aggregate the results and send it back to the application as a unified result.
The federation layer actually enables a query to span across multiple Zoho services thus virtualizing the different Zoho Services so that they look like a single service.
Architecture OverviewCloudSQL
Entity Mapper
To construct an SQL Statement a developer needs to identify the entities like database, table and columns available in a service for query execution.
As each Zoho Service collects and mines information about various business entities, the exact correlation of what is a database or table or columns in the context of a Zoho Service (also known as the service metadata) is defined by the service.
Developers have to use this metadata for constructing their SQL queries.
Language OverviewCloudSQL
SQL Query Syntax:
Zoho CloudSQL will support SELECT, INSERT, UPDATE and DELETE SQL statements written in any of ANSI, Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL and Informix database dialects.
The SQL statements supported by each Zoho Service will be published by the respective Zoho Service CloudSQL documentation.
SQL Query Entity Mapping:
The entities (such as Database, Tables and Columns ) on which the SQL query is constructed depends on the specific Zoho Service on which the SQL query is to be executed.
Writing a Query
Language OverviewCloudSQL
Once you construct the relevant SQL Query, then you need to execute it against the respective Zoho Service.
You need to submit the SQL Query as a HTTP Post request to the corresponding Web API, in the respective Zoho Service and execute the SQL Query.
The result set on executing a query like SELECT will be returned as a CSV file stream for processing.
The SQL statements supported by each Zoho Service will be published by the respective Zoho Service CloudSQL documentation.
Executing a Query
Language OverviewCloudSQL
Zoho CloudSQL supports open database connectivity standards JDBC and ODBC, making it easy to use from within widely adopted development languages that support JDBC and ODBC.
Developers just have know how to use the Zoho CloudSQL drivers for that service to start interacting with it, the same way as they would interact with a database using JDBC or ODBC standard drivers.
Each Zoho service that supports CloudSQL would provide the respective JDBC and ODBC Drivers for connectivity.
Connectivity with JDBC/ODBC
CloudSQL
DEMO
4 Things that stand out!CloudSQL
1. It's the first technology that allows customers to interact with their data on the cloud, from another cloud application or from an on-premises one through real SQL.
2. It supports multiple SQL dialects. It supports all the major (and even some not so major) ones: ANSI, Oracle, SQL
Server, IBM DB2, MySQL, PostgreSQL and Informix.
3. With our JDBC/ODBC drivers, developers can access data in the cloud just as easily as if it were stored in a local database. Capitalizes on developers’ years of knowledge and experience with SQL.
4. Zoho CloudSQL can be extended to non-Zoho services
CloudSQL
Get Started with Zoho CloudSQL in 4 easy steps
http://cloudsql.wiki.zoho.com/gettingstarted.html
????