Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

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 

Screenshots View All

Screenshots View All

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

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 

Alternatives

Alternatives

FastCube VCL Reviews

FastCube VCL

Fast Reports
Ranet OLAP Reviews

Ranet OLAP

Galaktikasoft
Apache Doris Reviews

Apache Doris

The Apache Software Foundation
CelerData Cloud Reviews

CelerData Cloud

CelerData