Panoply Features
What are the features of Panoply?
Functionality
- Extraction
- Loading
Data Management
- Data Integration
- Data Compression
- Data Quality
- Built-In Data Analytics
- In-Database Machine Learning
- Data Lake Analytics
Integration
- AI/ ML Integration
- BI Tool Integration
- Data lake Integration
Deployment
- Cloud
Performance
- Scalability
Security
- Data Governance
- Data Security
Panoply Categories on G2
Filter for Features
Management
Reporting | View ETL process data via reports and visualizations like charts and graphs. This feature was mentioned in 13 Panoply reviews. | 83% (Based on 13 reviews) | |
Auditing | As reported in 11 Panoply reviews. Record ETL historical data for auditing and potential data correction needs. | 76% (Based on 11 reviews) |
Functionality
Extraction | Extract data from the designated source(s) like relational databases, JSON files, and XML files. This feature was mentioned in 16 Panoply reviews. | 92% (Based on 16 reviews) | |
Transformation | Based on 13 Panoply reviews. Cleanse and re-format extracted data to the needed target format. | 86% (Based on 13 reviews) | |
Loading | As reported in 16 Panoply reviews. Load reformatted data into target database, data warehouse, or other storage location. | 97% (Based on 16 reviews) | |
Automation | As reported in 15 Panoply reviews. Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly). | 88% (Based on 15 reviews) | |
Scalability | Based on 15 Panoply reviews. Capable of scaling processing power up or down based on ETL volume. | 88% (Based on 15 reviews) |
Data Management
Data Integration | Based on 22 Panoply reviews and verified by the G2 Product R&D team. Consolidates, Cleanses and Normalizes data from multiple disparate sources. | 91% (Based on 22 reviews) | |
Data Compression | Based on 21 Panoply reviews and verified by the G2 Product R&D team. Helps save storage capacity and improves query performance. | 87% (Based on 21 reviews) | |
Data Quality | Based on 22 Panoply reviews and verified by the G2 Product R&D team. Eliminates data inconsistency and duplications ensuring data integrity. | 89% (Based on 22 reviews) | |
Built-In Data Analytics | Based on 19 Panoply reviews and verified by the G2 Product R&D team. SQL based analytics functions like Time series, pattern matching, geospatial analytics etc. | 74% (Based on 19 reviews) | |
In-Database Machine Learning | Based on 15 Panoply reviews and verified by the G2 Product R&D team. Provides built in capabilities like machine learning algorithms, data preparation functions, model evaluation and management etc. | 63% (Based on 15 reviews) | |
Data Lake Analytics | Based on 15 Panoply reviews and verified by the G2 Product R&D team. Allows data querying across data formats like parquet, ORC, JSON etc and analyze complex data types on HDFS | 70% (Based on 15 reviews) |
Integration
AI/ ML Integration | Based on 15 Panoply reviews and verified by the G2 Product R&D team. Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities. | 56% (Based on 15 reviews) | |
BI Tool Integration | Based on 22 Panoply reviews and verified by the G2 Product R&D team. Integrates with BI Tools to transform data into Actionable Insights. | 89% (Based on 22 reviews) | |
Data lake Integration | Based on 16 Panoply reviews and verified by the G2 Product R&D team. Provides speed in data processing and capturing unstructured, semi-structured and streaming data. | 78% (Based on 16 reviews) |
Deployment
On-Premise | Based on 15 Panoply reviews and verified by the G2 Product R&D team. Provides On-Premise deployment options. | 71% (Based on 15 reviews) | |
Cloud | Based on 22 Panoply reviews and verified by the G2 Product R&D team. Provides Cloud deployment options (private or public cloud, hybrid cloud). | 83% (Based on 22 reviews) |
Performance
Scalability | Based on 23 Panoply reviews and verified by the G2 Product R&D team. Manages huge volumes of data, upscale or downscale as per demand. | 81% (Based on 23 reviews) |
Security
Data Governance | Based on 20 Panoply reviews and verified by the G2 Product R&D team. Policies, procedures and standards to manage and access data. | 78% (Based on 20 reviews) | |
Data Security | Based on 18 Panoply reviews and verified by the G2 Product R&D team. Restricts data access at a cell level, mask or hide parts of cells, and encrypt data at rest and in motion | 87% (Based on 18 reviews) |
