PivotData REST REVIEW

IT Development Software

No user reviews
USER SATISFACTION 100%
OUR SCORE 8.0

What is PivotData REST?

PivotData REST is a platform that enables users to effortlessly embed analytics and pivot table reports into any web application. With PivotData Rest Service, it is quick and easy to connect directly to various type of data sources including SQL databases (SQL Server, PostgreSql, Mysql) and MongoDB. Configuration of data sources is fast and simple via JSON config and you can embed web pivot tables on your web page and applications in moments.

PivotData microservice is an ideal solution when you want to incorporate advanced pivot tables and charts builder into an existing web application. The system is also useful in retrieving embedded analytics and ad-hoc BI reporting for SQL/MongoDB data sources as well as calculating data for custom web-based BI dashboards and creating pivot reports on the server-side (scheduled reports, exports).

Overview of PivotData REST Benefits

PivotData REST Service is a .NET Core microservice (web application) that provides a web API for calculating pivot tables in the real time (in-memory OLAP engine + built-in ROLAP). This application may be hosted either on Windows or Linux.

Among the many advantages PivotData REST Service includs direct connection to SQL or MongoDb databases (no ETL), custom connectors may be added on-demand (.net plugins). Users will also love creating and configuring simple data sources/cubes with JSON file (no programming needed).

The software also offers a number of advanced pivot table options (percentages, differences, custom formatting & labels, TOP-N limits, server-side pagination) as well as formula measures, report parameters for database-level filtering. With PivotData REST Service, users benefit from transparent microservice security with JSON Web Tokens.

The application comes with a web API for rendering pivot tables to HTML and other formats (JSON, CSV, Excel, PDF). Microservice is shipped with front-end components (javascript) for pivot table and chart builder UI; these widgets could be easily integrated with any web application for embedding self-service ad-hoc reports, pre-configured reports or BI dashboards.

Overview of PivotData REST Features

  • Fast in-memory data cubes (no ETL, real-time reporting)
  • Built-in ROLAP engine for SQL/MongoDB data sources
  • Aggregate functions: count/count unique, sum, average, min/max, variance/standard deviation, list/list
  • Unique, custom formula
  • Self-service web pivot tables and pivot charts
  • Calculated members: dimensions and formula measures
  • Report parameters (data source level filtering)
  • Export pivot tables & charts to HTML, JSON, CSV, Excel, PDFlabels grouping with sub-totals, multiple
  • Values in one table
  • Sort table by values, totals or labels
  • Percentage, difference values, custom formatting options
  • Server-side pagination and top N limits for large pivot tables
  • Keyword-based filter for rows & columns
  • Embeddable web pivot table & chart builder for user-defined reports

What Problems Will PivotData REST Solve?

A. Add custom BI dashboards and predefined reports inside existing business applications: a lot of existing web-based business apps (intranet/extranet systems, BPM, SaaS services) don’t provide enough facilities for on-the-fly data analysis and reporting for making everyday data-driven decisions by the employees. PivotData is a perfect solution for this purpose: it is originally designed for embedded usage and BI functionality may be added to the web application in several days.

B. Provide self-service ad-hoc reporting functionality to the web application users: in many cases predefined reports cannot cover all needs and users should have the ability to configure their own reports like they can do that in Excel; with PivotData microservice users will able to configure reports by large corporate databases without need to export raw data to CSV or Excel files.

C. Generate periodic (scheduled) reports: PivotData is a server-side solution, so it is possible to use it for automated reports generation; for example, produce personalized workload reports or financial breakdown by the end of period.

Awards & Quality Certificates

PivotData REST Position In Our Categories

Position of PivotData REST in our main categories:

200

PivotData REST is one of the top 200 IT Management Software products

200

PivotData REST is one of the top 200
IT Management Software products


PivotData REST is also listed in the following subcategories:

Category:Position:
IT Development Software#53

Every business has its own characteristics, and may require a particular type of IT Development Software solution that will be fit for their company size, type of customers and staff and even specific industry they deal with. It's not wise to count on finding an ideal solution that is going to work for each company regardless of their background is. It may be a good idea to read a few PivotData REST reviews first and even then you should remember what the solution is supposed to do for your company and your workers. Do you need an easy and intuitive app with just elementary functions? Will you actually make use of the complex tools needed by pros and large enterprises? Are there any particular tools that are especially practical for the industry you operate in? If you ask yourself these questions it will be much easier to locate a trustworthy service that will match your budget.

How Much Does PivotData REST Cost?

PivotData REST Pricing Plans For Enterprises & Small Business:

PivotData REST offers a Service Trial pack that is free of charge; a single service license for SMBs, and a quote-based enteprise pricing license for larger users. Give the details a look, and select the best option for your business:

PivotData REST Service 1-Server License – $499

  • License for 1 Server deployment + License Key
  • Initial Setup and Configuration
  • 1 Year Email Support
  • Free Product Updates

PivotData REST Service Enterprise License – By quote

  • Unlimited Number of Deployments
  • Full Source Code Package
  • Training and Integration Services
  • High Priority / Voice Support

User Satisfaction

We realize that when you make a decision to buy IT Development Software it’s important not only to see how experts evaluate it in their reviews, but also to find out if the real people and companies that buy it are actually satisfied with the product. That’s why we’ve created our behavior-based Customer Satisfaction Algorithm™ that gathers customer reviews, comments and PivotData REST reviews across a wide range of social media sites. The data is then presented in an easy to digest form showing how many people had positive and negative experience with PivotData REST. With that information at hand you should be equipped to make an informed buying decision that you won’t regret.

POSITIVE SOCIAL MENTIONS

87

NEGATIVE SOCIAL MENTIONS

0

Technical details

Devices Supported
  • Windows
  • Linux
  • Mac
  • Web-based
Language Support
  • USA
  • UK
  • Canada
  • International
Pricing Model
  • Annual Subscription
  • Quote-based
Customer Types
  • Small Business
  • Medium Business
Deployment
  • On Premise

What Support Does This Vendor Offer?

  • EMAIL
  • PHONE NO.
  • LIVE SUPPORT
  • TRAINING

What are PivotData REST pricing details?

PivotData REST Pricing Plans:

PivotData REST offers a Service Trial pack that is free of charge; a single service license for SMBs, and a quote-based enteprise pricing license for larger users. Give the details a look, and select the best option for your business:

PivotData REST Service 1-Server License – $499

  • License for 1 Server deployment + License Key
  • Initial Setup and Configuration
  • 1 Year Email Support
  • Free Product Updates

PivotData REST Service Enterprise License – By quote

  • Unlimited Number of Deployments
  • Full Source Code Package
  • Training and Integration Services
  • High Priority / Voice Support

What integrations are available for PivotData REST?

PivotData REST integrates with the following business systems and applications:

  • ASP.NET
  • PHP
  • Ruby
  • NodeJS
  • Python
  • Java
  • MS SQL Server, Azure SQL
  • MySQL / MariaDB
  • PostgreSQL / Amazon Redshift
  • SQLite files
  • MongoDb
  • CSV/TSV/JSON files or URLs (coming soon)
  • Salesforce
  • Google
  • BigQuery

User reviews


No review

0
0
0
0
0

Average Rating

Write your own review of this product

Add a review

Thank you for submitting your review!

In order to ensure high-quality of our reviews we'll have to verify your email address. Please insert your email address below.

Thank you!

A verification email has been sent to the address you provided. Please click on the link in that email to finalize your review submission.

Page last modified