Zoho Reports : Connectors for Oracle, SQL Server, MySQL and MS Access Databases

Posted by Posted on by

So much of your business data from many of your applications lie in a database like Oracle, SQL Server, MySQL or MS Access, behind a firewall. Getting meaningful reports out of such databases and taking corrective actions based on those reports is what business intelligence is all about. The databases themselves are typically costly and creating reports out of them isn’t that easy. Buying additional reporting tools, which you need to install and maintain, adds up to your costs. But by making your data available in Zoho Reports, you get these major benefits:

  1. Create meaningful reports easily using just drag-and-drop
  2. The reports you create are accessible from anywhere
  3. Enable collaborative analysis and reporting
  4. Share the reports over the web to whoever you want
  5. Very affordable, pay-as-you-go monthly pricing plans (Zoho Reports is actually free, as of now)

Zoho Reports makes it easy to push data from behind-the-firewall databases (and CSV files too) by providing you with an Upload Tool (a database
connector). Using the tool, you can easily connect and push data from your databases like Oracle, SQL Server, MySQL and MS Access to Zoho Reports. You can schedule data uploads in regular intervals so that you continue to get near-real-time reports based on your dynamic data.

As the diagram above shows, the tool works in a simple way. It is a database connector that pulls data from your databases and uploads it to Zoho Reports. Data gets transfered securely over the Internet to Zoho Reports using a secured connection (HTTPS).  You can then create powerful reports and analysis based on the data uploaded. Read more about how to move data from your in-house databases to Zoho Reports.

If you are interested in using Zoho Reports for your business intelligence and reporting needs, do contact us for a personalized demo.

More Powerful Reporting with Query over Query feature

Posted by Posted on by

The latest Zoho Reports
update brings in the ‘Query over Query’ functionality, which has been
one of the top request from our users. You can now have SELECT queries
that combine already existing Query Tables. Let’s see an example of how
this comes in handy. Say you have a Sales table with sales figures for
various customers, products, regions etc across years.

Say you would like to know who your Top 10 customers with respect to sales value were in 2006. Your query table would look like,

The above Query Table in ‘View Mode’ with the top 10 customers arranged in alphabetical order.

And now you want to
know how much you sold to those top customers of 2006 in 2008. This is
where the new functionality will come in handy. You will arrive with
the required data by joining the base Sales table with the above top 10
customers of 2006 Query Table. The new Query Table will look like,

The above Query Table in ‘View Mode’ with the customer names in alphabetical order.

You can save the resultant query table and create the necessary reports over it.

this new “Query over Query” feature, you can create very powerful
reporting queries on your data and use it for your report generation
and analytics. It also helps in organizing your queries into reusable
functional units. To know more about how to create a Query Table,
checkout this video.

Other Enhancements
Previously, direct import was restricted to CSV files. And you had to do a copy-paste from Microft Excel (XLS) files. From now on, you can directly import XLS files too.

Also, for xls, html files larger than 3 MB, you can now zip them and import into Zoho Reports.

Try these new features in Zoho Reports and let us know your feedback comments.

Related Posts