Skip to main content

Zoho Creator Vs Force.com: Round one

Zoho creator is an online database system which allows users to create application by dragging and dropping things into place. It also supports importing databases like Ms. Access, Excel etc. It also supports variety of export types as XLS, CSV, TSV, HTML, PDF, JSON, RSS. All this is Googled, yes it is, but I am really looking for here is can Zoho be used to replace Force.com application? Why?

A person is always lookout for a cheaper alternative for a custom solution, a penny saved is a penny earned. The two systems were tested for the Model- View- Controller pattern and score accordingly.

Model
The things tested in the two system with respect to data model where,

  1. Does it support real-world relationships?
  2. Can we set up validation rules

Like Force.com Zoho Creator can create fields and forms using drag and drop functionality. One of the good thing about this is we can add validation rules using drag and drop. Lookup functionality also exists for relationship between two objects. We can quickly add a many-to-many bidirectional relationship. Creation of Database is really sophisticated and powerful in Zoho creator.

Zoho Scores full 10/10 in Model
Force.com is still 8/10

Controller
The things tested where

  1. 1. How easy it is to write a code
  2. 2. How is If- Else block implemented.
Zoho supports more like scripting code and not object oriented. It took a while to figure out the code that was to be implemented. Zoho creators offers template like IF ELSE block, but for a native user it is very difficult to use the scripting language.

In Force.com we have multiple options like the very basic formulas of validation rules and the powerful object oriented Apex triggers. While Zoho does provide database level triggers, the script statement makes it very hard to understand.

Zoho Scores 6/10
Force.com: 8/10

View
View is the most important part of any enterprise level system. Right from corporate branding to creating colorful visual and attractive pages this is one place where Zoho has a lot of room for improvement.

Zoho Creator does not allow the user to change the interface vastly, in fact Zoho Creator is probably the worst application for changing the interface so it meets a certain persons/company’s needs. It offers very less option to customize its interface, like with Visualforce and Sites we can completely change the interface but with Zoho Creator this seriously lacks.

Zoho Scores: 3/10
Force.com: 8/10

Conclusion:
Zoho creator has its own strength as far as creating small, excel based application. I created and deployed a survey tool for a group of friends. Zoho Creator is not comparable to the level of customization Force.com provides in terms of visual changes and controller. It is good to create small Excel and Access based applications that can be used internally. Not good to create an enterprise level software yet. 

But team Zoho has not disappointed me, so far, and I hope they will come up with a challenging tool soon.

Disclaimer: This post is done by an individual developer and is for your information only, before taking an executive decision please review the system thoroughly before jumping to conclusion.
Labels:

Comments

  1. UnknownAugust 30, 2013 at 8:20 AM

    Great post.
    Force.com, Zoho creator and Caspio are just 3 of the few online database providers that provides Performance Transparency. Check this article to know more:

    http://online-database.biz/which-online-database-is-most-transparent-with-their-service-status/

    ReplyDelete

Post a Comment

Popular Post

The unofficial guide to become a Certified Salesforce Administrator (ADM 201)

In my attempt at maximum certifications in 60 days, I completed Salesforce Certified Administrator exam on February 11th 2013 So you have decided to ramp up your career and take certifications in your hand. Good choice. It is also likely that this is the first time you have heard of Salesforce, certification and since your company has a vision of you completing the certification you have decided to do it. At this stage it is likely that, You have done extensive googling. You have received countless brain-dumps. And you have received plenty of advise from different types of users which ranges from Admin certification is easier than making coffee to Admin certification is tougher than building a rocket-ship to fly off to the moon. The purpose of this guide is to give you a clear understanding of what to expect when you are expected to become Certified Salesforce Administrator. To bring sense to all the things you have seen so far and to clearly explain what to do and what
72 comments
Read more

Some PDF tricks on Visualforce: Landscape, A4, page number and more

The beauty of Visualforce is simplicity. Remember the shock you received when you were told the entire page renders as PDF if you just add renderAs=PDF to the Page tag. For those who thought I spoke alien language right now, here is the trick, to render a page as PDF, we add a simple attribute to the <apex: page> tag <apex: page renderAs='pdf'> This will render the entire page as PDF. Now, say we need to add some extra features to the PDF. Like a page number in the footer or we need to render the page in landscape mode. Faced with this problem, I put on my Indiana Jones hat and went hunting for it in the vast hay-sack of the internet (read: googled extensively). Imagine my happiness when i found a big big page with many big big examples to solve the problem. The document I am referring to is from W3C, paged Box media . Long story short, I now possess the ultimate secret of rendering the page in any format I want. So here are few tricks I learned from the p
17 comments
Read more

The Basics of writing a Apex Trigger

One of the most important and common asked question on Forums and everywhere is how do I write a trigger. Coding in Apex Trigger is like going to a dentist for a root canal, you keep dreading the moment until you realize it is actually not going to hurt you. If you plan to write an Apex Trigger this quick guide will help you doing so. The first and foremost rule in writing a trigger is to remember the oldest suggestion given to the most comprehensive Hitchhikers Guide to Galaxy, ' Don't Panic. ' Writing a trigger is not a rocket science, in-fact we should thank the team at Salesforce and ForceDotCom for making everything so simple, that anyone can do it. Enough of talk, lets code. So you want to write a trigger. Let us have a glimpse of what we are going to build. The problem statement is as follows Problem:  When the User is entering the Opportunity, check for the Opportunity Amount. If the Opportunity Amount is greater than 50,000. Mark the Parent Account as
21 comments
Read more