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.
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.:-)
Update: Ouch, Rod reveals Zoho’s most secret plans: Today – Zoho DB – Tomorrow – Zoho Beer