post

Zoho DB for Data Manipulation & Reporting

Impeccable timing: just days after Computerworld named Zoho Creator one of five web apps they can’t live without, Zoho DB is released today. While Creator is an application generator, DB is primarily for data manipulation, analysis and reporting. You can create a new database or import your dataset from an existing spreadsheet, be it Zoho’s own Sheet or MS Excel. The UI is instantly familiar, as it reminds us of a spreadsheet, but one with drag-and-drop goodness, allowing the user to easily analyse data, create charts, reports, which, as typical with Zoho apps you can embed in your web page or blog, and of course other Zoho Apps.

Fur deeper analysis you can create Pivot Tables with simple drag & drop. Zoho DB Supports Query Tables – tables created based on a select query from a different table. It understands queries in many SQL dialects: Oracle, SQL Server, DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL. This sets Zoho DB apart from the rest of the industry, and it’s made possible by leveraging another Adventnet (Zoho’s parent) product: SwisSQL. In the near future it will also allow users to import and export database schemas.

The best way to get a feel for the capabilities is to watch the video introduction, then get your hands “dirty” by diving into Zoho DB yourself.

Some of Zoho DB’s features will soon be available in Zoho’s spreadsheet application giving users a choice where they analyze their data – and of course you will be able to access the same data via applications built with Zoho Creator.

Attendees at the recent Wiki: Beauty & Beast event heard Zoho’s Raju Vegesna talk about how eventually Word processors like Zoho Writer and Wikis should morph into each other. This may sound off-topic, but it’s another hint to Zoho’s philosophy of allowing users access their data via their application of choice, no matter which other application they used to create it. It’s all about the (work) flow, not data formats.:-)

See also: TechCrunch, Read/WriteWeb, CenterNetworks, Zoho Blogs , Mashable!, Between the Lines,

Update: Ouch, Rod reveals Zoho’s most secret plans: Today – Zoho DB – Tomorrow – Zoho Beer

Update (9/6): Ask Zoho: What’s the difference between Zoho DB, Creator & Sheet?

Comments

  1. That sounds good, but Zoho is not doing well with integration. For example, using Zoho Projects you are not allowed to import documents from Zoho Sheets or Zoho Writer.

    I have also complaints about the way Zoho “organize” files, so I have my doubts about Zoho new products… I have posted my opinion about Zoho Docs and Google Docs in my blog: http://www.designvsart.com/blog/

  2. Alexis,

    Writer has for long supported tagging. As for folders, check out http://start.zoho.com/. Folder / tagging access will become more standardized accross all Zoho apps in the future.

%d bloggers like this: