Need advice about which tool to choose?Ask the StackShare community!

Apache Kylin

61
236
+ 1
24
Zato

12
23
+ 1
0
Add tool

Apache Kylin vs Zato: What are the differences?

Developers describe Apache Kylin as "OLAP Engine for Big Data". Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop/Spark supporting extremely large datasets, originally contributed from eBay Inc. On the other hand, Zato is detailed as "Open-source ESB, SOA, REST and Cloud Integrations in Python". Build and orchestrate integration services, expose new or existing APIs, either cloud or on-premise, and use a wide range of connectors, data formats and protocols.

Apache Kylin and Zato belong to "Big Data Tools" category of the tech stack.

Some of the features offered by Apache Kylin are:

  • Extremely Fast OLAP Engine at Scale
  • ANSI SQL Interface on Hadoop
  • Interactive Query Capability

On the other hand, Zato provides the following key features:

  • Highly scalable enterprise integration platform and backend application server in Python
  • Browser-based GUI, CLI and API - designed by pragmatists for pragmatists
  • Protocols, industry standards and data formats - Odoo, SAP, IBM MQ, REST, Publish/Subscribe Queues, Single Sign-On, AMQP, SOAP, SQL, NoSQL, Caching, Kafka, WebSockets, LDAP, ElasticSearch, SMS, ZeroMQ, RBAC, Cassandra, S3, JMS and more

Apache Kylin and Zato are both open source tools. Apache Kylin with 2.29K GitHub stars and 1.02K forks on GitHub appears to be more popular than Zato with 783 GitHub stars and 185 GitHub forks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Apache Kylin
Pros of Zato
  • 7
    Star schema and snowflake schema support
  • 5
    Seamless BI integration
  • 4
    OLAP on Hadoop
  • 3
    Easy install
  • 3
    Sub-second latency on extreme large dataset
  • 2
    ANSI-SQL
    Be the first to leave a pro

    Sign up to add or upvote prosMake informed product decisions

    What is Apache Kylin?

    Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop/Spark supporting extremely large datasets, originally contributed from eBay Inc.

    What is Zato?

    Connect, integrate and automate all of your systems, APIs and apps, including cloud and legacy ones, using an open-source integration platform in Python. ESB, SOA, REST, API and Cloud Integrations in Python.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use Apache Kylin?
    What companies use Zato?
    See which teams inside your own company are using Apache Kylin or Zato.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Apache Kylin?
    What tools integrate with Zato?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Apache Kylin and Zato?
    Apache Spark
    Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
    Presto
    Distributed SQL Query Engine for Big Data
    Druid
    Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
    Apache Impala
    Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.
    AtScale
    Its Virtual Data Warehouse delivers performance, security and agility to exceed the demands of modern-day operational analytics.
    See all alternatives