Introducing Zoho Database & Reports

Posted by Posted on by
8

Today, we are launching a new addition to the Zoho Suite – Zoho DB & Reports – An Online Database & Reporting Application.
zdb.png
Zoho DB comes with a simple spreadsheet like user interface. You can create online databases and analyze your data using different views and charting tools. You can start by creating a database from an existing XLS/CSV/TSV files or by creating blank database. Once you have the data in the database, you can create different views and do visual analysis on the data in your database.
newbutton.png
Zoho DB lets you create multiple types of views – Tabular View, Chart View, Pivot View, Summary View etc from the ‘New’ button.

One of the core functionalities of Zoho DB is Data Visualization. The ‘Chart View’ option enables you to visualize your data in simple charts. This complex functionality is simplified with a very simple Drag-n-Drop interface. You have to play with it to really know the power of this feature.

This Drag-n-drop interface is also extended to creating ‘Pivot Tables’ in Zoho DB.

One of the unique features of Zoho DB is the ability to run SQL Queries of ANY dialect on the data. It understands SQL Queries/dialects from any of the supported databases which include Oracle, SQL Server, DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL. So you can run the SQL queries you already know on Zoho DB data to create custom tables or reports.

Ofcourse, once you have all the tables, views, charts etc created, you can share them with appropriate permissions or make them public (checkout existing public databases). You can also embed these views and charts on your website or blogs. Here is a sample chart from one of our public databases that has info on the population.



You can start playing with the application with your existing Zoho ID @ http://db.zoho.com. But wait….before you hop on, we recommend viewing the video below (for better clarity, use this one) for a quick intro on the capabilities of the application.




Now that the application is out, this will open up new possibilities for integration across other Zoho Apps. Stay tunes on that front. Meanwhile, do play with this new app and let us know your feedback.

ComputerWorld: Zoho Creator among five free web apps we can’t live without

Posted by Posted on by
0

Sharon Machlis from ComputerWorld has a good article on “Five free Web apps we can’t live without‘. It includes Zoho Creator as one of the five apps. We are very glad to see the app picking up many users and fans along its journey. As Sharon notes…

Unlike word processors or wikis, I haven’t seen a flood of free Web sites for building database-driven applications. The few other database entries I’d tried were generally either limited, expensive or cumbersome. But not Zoho Creator.

Zoho Creator sports a surprisingly easy interface for creating your own apps — even those that include some table joins (that is, looking up information in one table for use in another, which helps put the “relational” in relational databases). With a few drag-and-drops, I quickly created data entry forms with text fields, drop-down lists, text boxes and so on.

My test applications ranged from simple (tracking charitable contributions) to complex (story tracking by writer, editor and status), and all ended up doing pretty much what I wanted.

Full writeup on Zoho Creator is here.

Zoho Creator is one of the early Zoho products (actually, its research stage pre-dates Zoho). It has come a long way these couple of years and it certainly has miles to go.

Zoho Projects : RSS Feeds, Language Options and more

Posted by Posted on by
2

Zoho Projects is used around the world and what better way to access it than in your mother tongue! In addition to English, we have added the following language options – French, German, Japanese, Spanish, Dutch, Danish, Czech, Italian, Portuguese (European & Brazilian), Swedish & Russian. More language options will get added in future.

Adminstrators & managers can be up-to-date now, thanks to RSS feeds support. A couple of options available here – RSS at the individual project level and at the account level (combined feed for all projects). The feeds are HTTP authenticated and so use a RSS feed reader which supports authenticated feeds.

In addition to the already available ‘Duration’ of Tasks, you now have the option to specify the ‘End Date’ for each of your Tasks.

Test drive the latest Zoho Projects for all your project management needs.

Share option in Zoho’s Facebook App

Posted by Posted on by
0

We just updated our Facebook application with Share option. Now, you’ll be able to share your documents directly within Facebook to your friends on Facebook who have Zoho application added.

fb1.png fb2.png

The sharing process is very simple. Click on ‘Share’ link beside the document, select your friends with whom you want to share and specify the access permissions and click on ‘Share’.

All the shared documents appear under ‘Shared Documents’ tab. Do give it a try and let us know other features you’d like to see in this app.

Wiki: Beauty & The Beast – Event

Posted by Posted on by
0

wikievent.png

Silicon Valley Web Builder is organizing an event today @ HE, Fremont. I’ll be joining the discussion about ‘Wiki of Beauty & The Beast: Usability & Functionality“. Other panel members include…

The event is moderated by Luke Wroblewski, Yahoo’s design guru. If you plan to attend, do register online for free admission.

Date & Time: 9/26/07 Wed 6:30PM PST

Location: Hurricane Electric, Building Two “The Matrix”

Address: 48233 Warm Springs Blvd, Fremont CA 94539

DigitalBucket.net Integrates Zoho

Posted by Posted on by
0

DigitalBucket, an online storage vendor recently integrated Zoho Apps into their application. If you have Documents or spreadsheets uploaded to their application, you can view, edit and save them within their application using Zoho. Presentations can also be viewed within their app.

They have a neat application with good functionality. We’d like to thank them for their integration

Other online storage vendors who integrated Zoho into their application includes, Box.net, OmniDrive, MyDataBus, Steekr, FileDen etc.

If you’d like to integrate Zoho into your App, we’d love to work with you and offer our support. Also, we plan to extend our API for other applications soon.