Geekzone: technology news, blogs, forums
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
Zoho makes cloud data accessible with Zoho CloudSQL
Posted on 5-Dec-2008 09:19. | Tags Filed under: News.

Zoho makes cloud data accessible with Zoho CloudSQL
Zoho has announced Zoho CloudSQL, a middleware service that uses the familiar SQL (Structured Query Language) to connect business data stored in Zoho with traditional, on-premises applications as well as other SaaS offerings.

Zoho Reports, the company's online reporting and business intelligence service previously known as Zoho DB & Reports, is the first to support Zoho CloudSQL. In addition, Zoho Reports also added an HTTP-based API that lets users interact with their data programmatically.

“Zoho CloudSQL demonstrates Zoho's commitment to enable our customers to easily access and extend our services to suit their business needs,” said Rodrigo Vaca, director of marketing at Zoho. “Customers can use this new technology to seamlessly blend the data and applications they have on-site with the data and applications they have in the cloud.”

The Zoho CloudSQL middleware technology makes Zoho the first company to let users store and interact with business data stored in the cloud via SQL. While Zoho Reports is the first service to adopt Zoho CloudSQL, other Zoho services, including Zoho CRM, are planning to adopt the technology in the near future.

Programmatically accessing data in the cloud is not new, but most services require developers to learn yet another language or access method to be able to interact with it. “SQL is a very useful, powerful and widely used language — there's no need to reinvent the wheel,” said Vaca.

In addition, Zoho CloudSQL supports all major SQL dialects, including ANSI, Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Informix database dialects.

Zoho also provides a JDBC (Java Database Connectivity) driver for Zoho CloudSQL. An ODBC (Open Database Connectivity) driver will also be available shortly. Support for these database connectivity standards means that developers do not need to master web APIs in order to extend their services with Zoho. They can just continue using SQL drivers and statements as they already regularly interact with their premises-based databases using JDBC or ODBC drivers.

The company has also updated its Zoho Reports by adding a HTTP-based API that can be accessed through any application that supports HTTP requests. To help developers use the new service, Zoho is providing wrappers for Java, Python, and Google AppEngine. Wrappers for other popular languages will follow soon.

The new API is ideal for developers to be able to easily complement their applications with reporting and analytics functionality without having to do the heavy-lifting themselves.

More information:

comments powered by Disqus

Trending now »

Hot discussions in our forums right now:

Is it me, or have Trade Me prices increased?!
Created by Geektastic, last reply by Geektastic on 26-Oct-2016 21:11 (25 replies)
Pages... 2

RNZAF Boeing 757 breaks down when carrying PM. RNZAF must have an atrocious dispatch reliability figure.
Created by amiga500, last reply by BlakJak on 26-Oct-2016 22:27 (71 replies)
Pages... 3 4 5

WiFi and 3G/4G controlled Wall Switches
Created by maxeon, last reply by wbx0838 on 26-Oct-2016 17:46 (21 replies)
Pages... 2

New PC build
Created by Lyderies, last reply by joker97 on 26-Oct-2016 16:11 (18 replies)
Pages... 2

Gigabit cable now available
Created by sub, last reply by SteveC on 26-Oct-2016 21:54 (114 replies)
Pages... 6 7 8

Difference in prices between the US and New Zealand
Created by kingdragonfly, last reply by sbiddle on 26-Oct-2016 21:20 (14 replies)

Working for Spark - Customer support / Contact Centre
Created by goodfox, last reply by Talkiet on 26-Oct-2016 22:25 (13 replies)

Galaxy Note 7 Announcement and Owners' Thread
Created by eracode, last reply by JeremyNzl on 26-Oct-2016 19:35 (1201 replies)
Pages... 79 80 81