Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Pinot is built to efficiently handle OLAP queries on static data with minimal latency. It incorporates various pluggable indexing methods, including Sorted Index, Bitmap Index, and Inverted Index. While it currently lacks support for joins, this limitation can be mitigated by utilizing Trino or PrestoDB for querying purposes. The system offers an SQL-like language that enables selection, aggregation, filtering, grouping, ordering, and distinct queries on datasets. It comprises both offline and real-time tables, with real-time tables being utilized to address segments lacking offline data. Additionally, users can tailor the anomaly detection process and notification mechanisms to accurately identify anomalies. This flexibility ensures that users can maintain data integrity and respond proactively to potential issues.
Description
instantOLAP is a versatile and efficient Reporting and OLAP system that integrates a contemporary Web 2.0 interface known as the instantOLAP Portal with a robust built-in OLAP engine. Starting from version 2.5, the system features this modern front end, enabling users to not only access pre-established reports but also to generate their own Pivot-Tables and reports through a user-friendly drag-and-drop interface within their browsers. Additionally, users can share their created Pivot-Tables, reports, and other documents, as well as personalize the interface by creating bookmarks or automating emails according to their preferences. In the instantOLAP environment, reports transcend the limitations of basic tables; the reporting engine presents a wide array of components that can be merged to create engaging and dynamic reports. These reports can incorporate various interactive and customizable selectors, stylish Pivot-Tables with drill-down capabilities, numerous chart types, geo-charts, and more, allowing for a high degree of flexibility in presentation. Users can arrange these elements side by side, in vertical stacks, as part of a tabular layout, or even as animated displays, providing a rich and interactive data experience. This level of customization empowers users to tailor their reporting experience to meet their specific needs and preferences.
API Access
Has API
No
API Access
Has API
No
Integrations
Amazon S3
Yes
Apache Kafka
Yes
Astro by Astronomer
Yes
Azure Data Lake
Yes
Hadoop
Yes
Hue
Yes
Kestra
Yes
Onehouse
Yes
OpenMetadata
Yes
StarTree
Yes
Integrations
Amazon S3
No
Apache Kafka
No
Astro by Astronomer
No
Azure Data Lake
No
Hadoop
No
Hue
No
Kestra
No
Onehouse
No
OpenMetadata
No
StarTree
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
No
Webinars
No
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
Apache Corporation
Founded
1954
Country
United Statess
Website
pinot.apache.org
Vendor Details
Company Name
instantOLAP
Country
Germany
Website
www.instantolap.com
Product Features
Product Features
Business Intelligence
Ad Hoc Reports
Yes
Benchmarking
No
Budgeting & Forecasting
Yes
Dashboard
Yes
Data Analysis
No
Key Performance Indicators
No
Natural Language Generation (NLG)
No
Performance Metrics
No
Predictive Analytics
No
Profitability Analysis
No
Strategic Planning
No
Trend / Problem Indicators
Yes
Visual Analytics
Yes
Reporting
Customizable Dashboard
Yes
Data Source Connectors
No
Drag & Drop
No
Drill Down
Yes
Email Reports
No
Financial Reports
No
Forecasting
Yes
Marketing Reports
No
OLAP
Yes
Report Export
Yes
Sales Reports
No
Scheduled / Automated Reports
Yes