Data Analytics stack comparison

- Pentaho

Verify the below table

Features Pentaho   AWS Azure   Open Source Stack  
Data Platform
Data Warehouse Flexible Redshift, RDS, Aurora SQL Data Warehouse Flexible
Big Data – Prebuilt Connectors
Data Lake (HDP, NoSQL)
Pentaho Data Integration
Pentaho Business Analytics
Amazon EMR HD Insight Not Available
Infrastructure support Not Applicable Yes Yes Not Applicable
Clustering & Load Balancing Yes – PDI/PBA Scale on Demand Scale on Demand Not Applicable
Multi Tenancy Yes Yes Yes Yes
Security – SSO Yes, LDAP, SAML, Custom SSO IAM Active Directory LDAP based
Data Lake
EDW – ETL, Data Cleansing, Standardization, Pipeline Pentaho Data Integration Gluu, Kinesis Data Factory Apache NiFi, Camel
DL – ELT and further data orchestration Pentaho Data Integration Gluu, Kinesis Data Factory Apache NiFi, Camel
Stream Processing Pentaho Data Integration Kinesis Stream Analytics Spark, Kafka
Real Time Processing Pentaho Data Integration Stream Processing Stream Analytics Spark
API Support for Embedding Pentaho Data Integration AWS API Azure Micro Services Customized
RDBMS – Prebuilt Connectors Pentaho Data Integration
Pentaho Business Analytics
Specific to AWS databases Specific to Azure Helical, Saiku
File processing Connectors
Excel, CSV, XML, Avro
Connectors to AWS S3)
Pentaho Data Integration Using S3 – CLI Blob Storage Excel, CSV
Meta Data Storage Pentaho Solution Repository Data Store Data Store Custom Storage
Data Visualization
OLAP Analysis Analyzer AWS Market Place Azure Analysis Services MetaBase, Helical, Saiku
Pixel Perfect Reporting Pentaho Report Designer AWS Market Place PowerBI Helical
Adhoc – Reporting Pentaho Meta Data AWS Market Place PowerBI Not Available
Dashboard/Visualization Pentaho Dashboard Designer QuickSight PowerBI Helical
Data Science
Statistical Analysis Yes – R/Python Integration via PDI Sage Maker, Deep Lens ML studio, ML Workbench R/Python
Machine Learning (Predictive, Prescriptive) Yes – R/Python Integration via PDI Sage Maker, Deep Lens ML studio, ML Workbench R/Python
General
Administration & Monitoring Pentaho User Console AWS user Console Azure User Console Not Available
Native Mobile Support Browser Based Browser Based Browser Based Browser Based
Designer Tools PRD, Spoon, Workbench, Dashboard Designer, Aggregate Designer, Ctools QuickSight PowerBI Coding

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>