Zoho DB & Reports Integration with Zoho Creator - Step 1
Clarence October 9, 2008 08: 58 am
Integrating the powerful reporting & analytics functionality of Zoho DB & Reports into Zoho Creator has been one of the most requested feature. We have heard it and enabled the first step towards this goal.
In Zoho DB & Reports we have introduced the feature of scheduled periodic import of CSV files from any accessible Web URL. With this feature you could setup Zoho DB & Reports to periodically fetch data in CSV format from any accessible Web URL. This would be really useful in scenarios where you have new data being published or updated periodically and you would like get those updates inside Zoho DB & Reports for reporting and analysis. Till now you had to re-import this data manually into Zoho DB & Reports, every time an update is available. Now you just have to setup up the periodic import feature and Zoho DB & Reports would do the rest for you.
With this feature you could also (enable Zoho DB & Reports to) periodically fetch data from your Zoho Creator Application into Zoho DB & Reports as changes happen to the same. As the latest data is made available inside Zoho DB & Reports, you could create any type of powerful reports with it. The reports created using Zoho DB & Reports could also be embedded back inside your Zoho Creator application using the new HTML Page view feature introduced in Zoho Creator 3.0
The following presentation demonstrates how you could periodically import data from Zoho Creator into Zoho DB & Reports:
Do give the above feature a try and let us know your feedbacks. This is just the first step in making available the powerful reporting functionality of Zoho DB & Reports to Zoho Creator users. We are continuing our work on this problem to further simplify the process. A much closer GUI level integration of making report creation features of Zoho DB & Reports available within Zoho Creator is in development. We will keep you posted once we are ready with it…
Happy Reporting and Keep tab on further development…
Clarence
Zoho DB & Reports - Online Reporting & BI Service
Popularity: 21% [?]
Help others find this article:
How would this work for Creator Apps that are published in the Market Place and installed by other users? Would they be responsible for creating their own CSV feeds and building their own DB & Reports? Would they have to modify the code in the applications HTML Views to point to their own DB & Reports analysis?
And do Creator, DB & Reports, and Sheets use the same charting engine?
Right now, user has to go through the CSV feed steps. We are working on automating the whole chain, and integrating it. That should be available in a future update.
Charting engine: they use the same engine, but not the same version. They will be syncing up in due course.
This is an important step forward to closer integration.
Just to be able to show this working to some interested parties in the short term is gonna drive interest for me.
Not trying to nail you down to a time of day but ballpark estimate for full integration? Q4 2008/Q1 2009???
Nice one Zoho.
Mark
Hi Mark,
Thanks for the comments. We would have a better visibility on the estimated delivery time lines early November. If you might be interested we could keep you posted during that time (early November) on the estimations.
Thanks,
Clarence
Zoho DB & Reports.
Great feature Zoho. I remember seeing this feature available with Zoho Sheet and Zoho DB some time ago, but it’s a great idea moving forward to make this avalable through Creator as well as from an accessible Web URL. Since I’m looking to develop Business Intelligence Financial Dashboards utilizing Zoho DB, this is very exciting news. Keep up the good work Zoho!
Thanks Earl for the feedback’s. Do let us know if you require any assistance in building your Financial Dashboards. We would be more than happy to help you out.
Thanks,
Clarence
Zoho DB & Reports
Hi Clarence,
Here’s what also on my wish list. To develop small business ERP functionality utlizing Zoho DB & Reports. Is this something that Zoho is contemplating?
Hi Earl,
That’s a very good idea. We do not have any immediate road map of releasing any ERP application, although that cannot be ruled out for the future.
Do let us know if you need any assistance in your development.
Thanks,
Clarence
Clarence,
I would appreciate any news or updates you can give me on the progress of the integration around that time. I will be doing a presentation to our company in early December and this will help make the case for us to adopt for larger corporate opportunities as well as the small/medium business that I know creator was designed for.
my registered username is TPN_DEV so feel free to drop me a mail at my registered address or my zoho mail tpn_dev (at) zoho dot com
Thanks
Mark
Hi Mark,
Sorry I missed your comment. Yes we will keep you posted on the progress early November. Mail us if you need any clarifications to support at zohodb dot com
Clarence
How about integrating DB & Reports with Zoho Sheet? I mean Sheet is like a DB so what I really want is the power of the Reports using a Sheet as my source.
It seems to me the DB part of DB & Reports is having the hardest time gaining traction - how do you get the data into the DB? Of course there’s the API but within Zoho itself it’s not used (common beef of mine: companies that don’t integrate their own products).
It would be cool if Sheet had way to use Reports from DB & Reports; and if Creator an option to “store data in DB” (not sure how this would affect Marketplace apps, but you guys are smart, you’ll figure it out).
Zoho Sheet already has integrated Zoho DB’s reporting capabilities. Zoho Sheet’s Pivot tables and Pivot charts functionality, launched in April, actually integrates Zoho DB’s reporting capabilities. You can easily create pivot tables and charts from your existing data in Zoho Sheet. Let us know what kind of integration you are looking at.