PivotData Microservice
Web pivot tables connected to SQL database·nrecosite.com
One-time · No free plan (free trial) · Self-hostable See pricing ↓
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
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
Integrations
Pricing
How we check thisLicenses 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.
Last release: 2026 May 25
Trial mode: renders trial notices and applies limitations on dataset size; usable only for evaluation/testing purposes
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
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.
Similar apps
SeekTableSelf-hostableOnline pivot tablesPriceNot statedTry freeFree planRuns onWebFeatures21
Telerik ReportingSelf-hostableEmbed Flexible .NET Reporting Tools into Your AppsPrice$41.58–$83.25/moTry free30-day trialRuns onWeb · Windows +2Features19
Seal ReportOpen sourcePriceNot statedTry freeFree planRuns onWeb · Windows +1Features18
Open ReportOpen sourceOpen source Power BI & Looker Studio alternativePriceFrom €20/moTry freeFree planRuns onWeb · Windows +2Features15
InAppBISelf-hostableThe fastest way to add Analytics to your applicationPrice$50–$1299/moTry freeFree planRuns onWebFeatures18
ReportServerOpen sourceThe Business Intelligence Suite — Your Data, Your Rules, Your ReportingPriceNot statedTry freeFree planRuns onWeb · LinuxFeatures20