Data Analytics stack comparison

tenthplanet blog pentaho Data Analytics stack comparison

Verify the below table for Data Analytics stack comparison

FeaturesPentaho+  AWSAzure  Open Source Stack  
Data Platform
Data WarehouseFlexibleRedshift, RDS, AuroraSQL Data WarehouseFlexible
Big Data – Prebuilt Connectors
Data Lake (HDP, NoSQL)
Pentaho+ Data Integration
Pentaho+ Business Analytics
Amazon EMRHD InsightNot Available
Infrastructure supportNot ApplicableYesYesNot Applicable
Clustering & Load BalancingYes – PDI/PBAScale on DemandScale on DemandNot Applicable
Multi TenancyYesYesYesYes
Security – SSOYes, LDAP, SAML, Custom SSOIAMActive DirectoryLDAP based
Data Lake
EDW – ETL, Data Cleansing, Standardization, PipelinePentaho+ Data IntegrationGluu, KinesisData FactoryApache NiFi, Camel
DL – ELT and further data orchestrationPentaho+ Data IntegrationGluu, KinesisData FactoryApache NiFi, Camel
Stream ProcessingPentaho+ Data IntegrationKinesisStream AnalyticsSpark, Kafka
Real Time ProcessingPentaho+ Data IntegrationStream ProcessingStream AnalyticsSpark
API Support for EmbeddingPentaho+ Data IntegrationAWS APIAzure Micro ServicesCustomized
RDBMS – Prebuilt ConnectorsPentaho+ Data Integration
Pentaho+ Business Analytics
Specific to AWS databasesSpecific to AzureHelical, Saiku
File processing Connectors
Excel, CSV, XML, Avro
Connectors to AWS S3)
Pentaho+ Data IntegrationUsing S3 – CLIBlob StorageExcel, CSV
Meta Data StoragePentaho+ Solution RepositoryData StoreData StoreCustom Storage
Data Visualization
OLAP AnalysisAnalyzerAWS Market PlaceAzure Analysis ServicesMetaBase, Helical, Saiku
Pixel Perfect ReportingPentaho+ Report DesignerAWS Market PlacePowerBIHelical
Adhoc – ReportingPentaho+ Meta DataAWS Market PlacePowerBINot Available
Dashboard/VisualizationPentaho+ Dashboard DesignerQuickSightPowerBIHelical
Data Science
Statistical AnalysisYes – R/Python Integration via PDISage Maker, Deep LensML studio, ML WorkbenchR/Python
Machine Learning (Predictive, Prescriptive)Yes – R/Python Integration via PDISage Maker, Deep LensML studio, ML WorkbenchR/Python
General
Administration & MonitoringPentaho+ User ConsoleAWS user ConsoleAzure User ConsoleNot Available
Native Mobile SupportBrowser BasedBrowser BasedBrowser BasedBrowser Based
Designer ToolsPRD, Spoon, Workbench, Dashboard Designer, Aggregate Designer, CtoolsQuickSightPowerBICoding