PivotData Microservice is unclaimed —

PivotData Microservice

Web pivot tables connected to SQL database·nrecosite.com

PivotData Microservice is a self-hosted reporting engine (analytical API) for generating pivot tables, flat tables and charts from live data connections. It runs as an on-premise .NET8 application on Windows or Linux and exposes a web API plus a JS front-end reports builder that can be embedded into any web app. It uses a ROLAP approach with no data import, connecting directly to SQL databases, MongoDB, ElasticSearch, SSAS and CSV files, and exports reports to HTML, CSV, JSON, Excel, PDF or images.

What it's for

Embed interactive pivot tables and charts into a web applicationReplace Excel PivotTable files with centralized live web-based reportsGenerate parametrized reports automatically on a scheduleProvide a unified querying/cube model across SQL, MongoDB, ElasticSearch and XMLA OLAP sourcesAccelerate development of custom BI functionality (connectors, calculations, caching, exports)

Features 19

Advanced pivot tables: labels grouping, sub-totals, expand/collapse
Aggregate functions: count, count unique, sum, average, min/max, variance/standard deviation, median/quantile, mode, list/list unique, custom DB-specific aggregations
Calculated members: expression-based dimensions and formula measures
Calculations: percentage, difference, running total
Custom connector support via your own web API
Custom formatting for numbers/dates and heatmap table styling
Drill-down data exploration
Exports to PDF, Excel, Excel PivotTable, CSV, Image, HTML and JSON
Includes an embeddable web pivot tables builder (JS front-end example)
Live connections to SQL, MongoDB, ElasticSearch, SSAS and CSV data sources
Multiple values in one table and sorting by values, totals or labels
Near real-time server-side report generation (ROLAP, no data import)
Report parameters for database query filters, including multi-value and custom conditions
Search-driven analytics capability
Search-like filter for rows, columns and values
Server-side pagination and top-N limits for large pivot tables
Suitable for multi-tenant (SaaS) applications
Works efficiently with star-schema data marts
XMLA OLAP endpoint support (SSAS, Azure Analysis Services, icCube)

At a glance

free trialself-hostableAPI

TypeWeb app

DeploymentSelf-hosted

PlatformsWindows, Linux, Web

Fordevelopers integrating BI into web applications, SaaS/multi-tenant app builders

CompanyNReco

Integrations

MariaDBDuckDBOracleicCubeTrinoMotherDuckSQL ServerSSASPrestoElasticSearchAmazon RedshiftAzure SQLAmazon DocumentDBTeradataMySQLDatabricksSAP HANAClickHouseQuestDBAzure Cosmos DBPostgreSQLMongoDBGoogle BigQuerySnowflakeMemSQLSQLiteAzure Analysis ServicesPipelineDB

Resources

Pricing

Licenses are one-time purchases per deployment (1-Server: $999; Enterprise/unlimited deployments: $4990); a trial pack can be downloaded for free with dataset-size limitations. A checkout-time promotional discount is advertised but its percentage is not shown on the page.

Trial packFree

Last release: 2026 May 25

Trial mode: renders trial notices and applies limitations on dataset size; usable only for evaluation/testing purposes

1-Server LicenseQuote

Commercial license for 1-server deployment + key (removes trial limitations), Assistance with initial setup & configuration, 1-year period of email support, Free product upgrades

Licensed for 1-server deployment

Enterprise LicenseQuote

Commercial license for UNLIMITED deployments + key (removes trial limitations), Binaries to disable deployments online activation, Assistance with initial setup & configuration, 1-year period of email support, Free product upgrades

Unlimited deployments

A 'today's deal' discount with a coupon code is shown at checkout; specific percentage not stated.