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