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 |
