Data Analytics stack comparison
Verify the below table for Data Analytics stack comparison
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 |