Zoho Creator is easy to use and helps you build online databases from scratch. You can simply drag and drop fields to build forms or applications based on your need. It connects to a wide range of databases (SQL and NoSQL). Supported databases include Oracle, SQL Server, MySQL, PostgreSQL, MS Access, Teradata, MongoDB, etc.
With the launch of Zoho DB & Reports on Wednesday, we now have 3 services that handle structured data. So the natural question a lot of people have been asking is "What's the difference, why have 3 services when one would be enough"? Zoho Analytics allows you to import data from local or hosted databases such as MySQL, MS SQL Server, Oracle, PostgreSQL, etc. You can connect and import data from relational and NoSQL databases into Zoho Analytics. Load data from NoSQL databases You can extract data from NoSQL databases and import the same into Zoho Analytics.
If you need a powerful online reporting and analysis service with a built-in analytical database, opt for Zoho Analytics. It contains a built-in analytical database grid, which is optimised for reporting and querying rather than serving as a real-time online transactional database. You can get data into Zoho Analytics through manual data entry or bulk loading of data from files or load data stored in your local databases (such as MS Access, Oracle, SQL Server, MySQL, DB2, PostgreSQL and MS Access) or schedule for periodic loading of data or push data to your application via Web API (HTTP based) for reporting and analytics. The main goal of zoho creator is to be an online application creation environment, which happens to come with a database to complete the application creation experience.
Analyse and uncover hidden insights from the data present in your internal databases (both SQL and NoSQL) using Zoho Analytics. The key difference between Zoho Analytics and Zoho Creator is in-depth reporting and analysis versus creating custom database applications online. Zoho Creator allows you to quickly create a powerful online database application to collect data and trigger workflows through forms and scripts. Load data from relational databases You can extract data from a relational database and import it into Zoho Analytics.
Zoho Analytics is an online Business Intelligence and Reporting service, so it can be used as an online database. This platform neutral API allows you to integrate real-time data changes from your applications or databases into Zoho Analytics. Zoho Analytics allows you to create multiple types of views - Tabular View, Chart View, Pivot View, Summary View, etc. from the "New" button.