Introducing Zoho Database & Reports

Zoho Analytics | October 3, 2007 | 2 min read

Today, we are launching a new addition to the Zoho Suite – Zoho Database & Reports – An Online Database & Reporting Application.

Zoho Reports 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.

Zoho Reports 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 Reports 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 Reports.

One of the unique features of Zoho Reports 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 Reports data to create custom tables or reports.

Of course, 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 @ https://reports.zoho.com. But wait….before you hop on, we recommend viewing the video below 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 tuned on that front. Meanwhile, do play with this new app and let us know your feedback.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  1. vijay

    It would be nice if you can introduce more formats of data in the tables.. like URL format..

  2. vijay

    It would be nice if you can introduce more formats of data in the tables.. like URL format..

  3. Clarence

    Hi SmartGenes,Sorry for the inconvenience caused. We are not very clear on the problem you had encountered using Zoho DB & Reports. From what we understand, it looks that you had added some data into a Table in Zoho DB & Reports. But instead of allowing you to save, it prompted you to refresh thereby making you loose the data added.We have not encountered such an issue in our environment. Whenever you add data it should enable you to save it and not force you to refresh the data. Can you please mail us the steps that you had followed which caused this problem to support at zohodb dot com. This would enable us to identify the issue and get this resolved.Wrt. to copy/pasting data directly into the Sheet view of a Table, currently Zoho DB & Reports do not support copy pasting data directly into the Sheet view (as in Excel). You can alternatively, use the “Import” Option, Select “Pasted Data” and copy/paste the data in the text area provided. This would enable you to add the data that you had copied from Word into Zoho DB & Reports. In this case, please do ensure that the values pasted are comma or tab or space or semi-colon separated.Please do let us know if we have misunderstood your problem or if you need any clarifications to the above said. You could also mail your feedbacks to support at zohodb dot com.Thank you and Looking forward to your reply,With regards,
    Clarence
    http://db.zoho.com

  4. Clarence

    Hi SmartGenes,Sorry for the inconvenience caused. We are not very clear on the problem you had encountered using Zoho DB & Reports. From what we understand, it looks that you had added some data into a Table in Zoho DB & Reports. But instead of allowing you to save, it prompted you to refresh thereby making you loose the data added.We have not encountered such an issue in our environment. Whenever you add data it should enable you to save it and not force you to refresh the data. Can you please mail us the steps that you had followed which caused this problem to support at zohodb dot com. This would enable us to identify the issue and get this resolved.Wrt. to copy/pasting data directly into the Sheet view of a Table, currently Zoho DB & Reports do not support copy pasting data directly into the Sheet view (as in Excel). You can alternatively, use the “Import” Option, Select “Pasted Data” and copy/paste the data in the text area provided. This would enable you to add the data that you had copied from Word into Zoho DB & Reports. In this case, please do ensure that the values pasted are comma or tab or space or semi-colon separated.Please do let us know if we have misunderstood your problem or if you need any clarifications to the above said. You could also mail your feedbacks to support at zohodb dot com.Thank you and Looking forward to your reply,With regards,
    Clarence
    http://db.zoho.com

  5. Clarence

    Hi Herve Gonay,We are into QA for the API feature. We are shooting to get this out in the next 2 to 3 weeks time. Will keep the community posted on this.Wrt to Creator integration, we are onto development. We have not finalized the exact timeline for the release of this feature. By all possiblity it would be available in 3Q this year.Thanks,
    Clarence
    http://db.zoho.com

  6. Clarence

    Hi Herve Gonay,We are into QA for the API feature. We are shooting to get this out in the next 2 to 3 weeks time. Will keep the community posted on this.Wrt to Creator integration, we are onto development. We have not finalized the exact timeline for the release of this feature. By all possiblity it would be available in 3Q this year.Thanks,
    Clarence
    http://db.zoho.com

  7. smartgenes

    The DB is bugged, asked me to refresh my data rather than save it, I’ve never heard of anything so stupid in all my life. If you really expect this to take off then it has to be able to save your data. So now I have the data pasted into Word, as I just knew this was going to make my data disappear.. So how can I paste it back in, it seems impossible to copy and paste several lines or rows in at a time.

  8. smartgenes

    The DB is bugged, asked me to refresh my data rather than save it, I’ve never heard of anything so stupid in all my life. If you really expect this to take off then it has to be able to save your data. So now I have the data pasted into Word, as I just knew this was going to make my data disappear.. So how can I paste it back in, it seems impossible to copy and paste several lines or rows in at a time.