{"id":1253,"date":"2019-04-19T15:41:02","date_gmt":"2019-04-19T10:11:02","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=1253"},"modified":"2026-03-03T10:14:39","modified_gmt":"2026-03-03T10:14:39","slug":"data-analytics-stack-comparison","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/data-analytics-stack-comparison\/","title":{"rendered":"Data Analytics stack comparison"},"content":{"rendered":"

Verify the below table for Data Analytics stack comparison<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Features<\/b><\/td>\nPentaho+\u2002\u2002<\/b><\/td>\nAWS<\/b><\/td>\nAzure\u2002\u2002<\/b><\/td>\nOpen Source Stack\u2002\u2002<\/b><\/td>\n<\/tr>\n
Data Platform<\/strong><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Data Warehouse<\/td>\nFlexible<\/td>\nRedshift, RDS, Aurora<\/td>\nSQL Data Warehouse<\/td>\nFlexible<\/td>\n<\/tr>\n
Big Data – Prebuilt Connectors
\nData Lake (HDP, NoSQL)<\/td>\n		Pentaho+ Data Integration
\nPentaho+ Business Analytics<\/td>\n		Amazon EMR<\/td>\nHD Insight<\/td>\nNot Available<\/td>\n<\/tr>\n
Infrastructure support<\/td>\nNot Applicable<\/strong><\/td>\nYes<\/strong><\/td>\nYes<\/strong><\/td>\nNot Applicable<\/strong><\/td>\n<\/tr>\n
Clustering & Load Balancing<\/td>\nYes – PDI\/PBA<\/td>\nScale on Demand<\/td>\nScale on Demand<\/td>\nNot Applicable<\/td>\n<\/tr>\n
Multi Tenancy<\/td>\nYes<\/td>\nYes<\/td>\nYes<\/td>\nYes<\/td>\n<\/tr>\n
Security – SSO<\/td>\nYes, LDAP, SAML, Custom SSO<\/td>\nIAM<\/td>\nActive Directory<\/td>\nLDAP based<\/td>\n<\/tr>\n
Data Lake<\/strong><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
EDW – ETL, Data Cleansing, Standardization, Pipeline<\/td>\nPentaho+ Data Integration<\/td>\nGluu, Kinesis<\/td>\nData Factory<\/td>\nApache NiFi, Camel<\/td>\n<\/tr>\n
DL – ELT and further data orchestration<\/td>\nPentaho+ Data Integration<\/td>\nGluu, Kinesis<\/td>\nData Factory<\/td>\nApache NiFi, Camel<\/td>\n<\/tr>\n
Stream Processing<\/td>\nPentaho+ Data Integration<\/td>\nKinesis<\/td>\nStream Analytics<\/td>\nSpark, Kafka<\/td>\n<\/tr>\n
Real Time Processing<\/td>\nPentaho+ Data Integration<\/td>\nStream Processing<\/td>\nStream Analytics<\/td>\nSpark<\/td>\n<\/tr>\n
API Support for Embedding<\/td>\nPentaho+ Data Integration<\/td>\nAWS API<\/td>\nAzure Micro Services<\/td>\nCustomized<\/td>\n<\/tr>\n
RDBMS – Prebuilt Connectors<\/td>\nPentaho+ Data Integration
\nPentaho+ Business Analytics<\/td>\n		Specific to AWS databases<\/td>\nSpecific to Azure<\/td>\nHelical, Saiku<\/td>\n<\/tr>\n
File processing Connectors
\nExcel, CSV, XML, Avro
\nConnectors to AWS S3)<\/td>\n		Pentaho+ Data Integration<\/td>\nUsing S3 – CLI<\/td>\nBlob Storage<\/td>\nExcel, CSV<\/td>\n<\/tr>\n
Meta Data Storage<\/td>\nPentaho+ Solution Repository<\/td>\nData Store<\/td>\nData Store<\/td>\nCustom Storage<\/td>\n<\/tr>\n
Data Visualization<\/strong><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
OLAP Analysis<\/td>\nAnalyzer<\/td>\nAWS Market Place<\/td>\nAzure Analysis Services<\/td>\nMetaBase, Helical, Saiku<\/td>\n<\/tr>\n
Pixel Perfect Reporting<\/td>\nPentaho+ Report Designer<\/td>\nAWS Market Place<\/td>\nPowerBI<\/td>\nHelical<\/td>\n<\/tr>\n
Adhoc – Reporting<\/td>\nPentaho+ Meta Data<\/td>\nAWS Market Place<\/td>\nPowerBI<\/td>\nNot Available<\/td>\n<\/tr>\n
Dashboard\/Visualization<\/td>\nPentaho+ Dashboard Designer<\/td>\nQuickSight<\/td>\nPowerBI<\/td>\nHelical<\/td>\n<\/tr>\n
Data Science<\/strong><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Statistical Analysis<\/td>\nYes – R\/Python Integration via PDI<\/td>\nSage Maker, Deep Lens<\/td>\nML studio, ML Workbench<\/td>\nR\/Python<\/td>\n<\/tr>\n
Machine Learning (Predictive, Prescriptive)<\/td>\nYes – R\/Python Integration via PDI<\/td>\nSage Maker, Deep Lens<\/td>\nML studio, ML Workbench<\/td>\nR\/Python<\/td>\n<\/tr>\n
General<\/strong><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Administration & Monitoring<\/td>\nPentaho+ User Console<\/td>\nAWS user Console<\/td>\nAzure User Console<\/td>\nNot Available<\/td>\n<\/tr>\n
Native Mobile Support<\/td>\nBrowser Based<\/td>\nBrowser Based<\/td>\nBrowser Based<\/td>\nBrowser Based<\/td>\n<\/tr>\n
Designer Tools<\/td>\nPRD, Spoon, Workbench, Dashboard Designer, Aggregate Designer, Ctools<\/td>\nQuickSight<\/td>\nPowerBI<\/td>\nCoding<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Comparison on Pentaho, AWS, Azure and Open Source Stack based on Data Platform, Data Lake, Data Visualization, Data Science and General<\/p>\n","protected":false},"author":23,"featured_media":1260,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[424],"tags":[480],"class_list":["post-1253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pentaho","tag-data-analytics"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/1253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=1253"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/1253\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/1260"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=1253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=1253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=1253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}