nreco/pivotdataservice repository overview

⁠What is PivotData Microservice

PivotData microservice⁠ is an embedded BI solution. Technically this is a ROLAP engine with a built-in capability to generate tabular reports (including pivot tables) in various formats: HTML, PDF, Excel, Image, JSON.

PivotData microservice provides a simple way to add self-service analytics & BI reporting into your web application. It is enough to configure your data sources with JSON config and use a simple web API to generate pivot tables and charts. Engine supports various data sources: CSV files, SQL databases (SQL Server, PostgreSql, MySql, Sqlite, Oracle, ClickHouse, Snowflake), Analysis Services (XMLA) and even some NoSql DBs (MongoDb, ElasticSearch).

Distribution also includes front-end example of web-based report builder that can be easily embedded into your app: Online Demo⁠.

More details about PivotData microservice: https://www.nrecosite.com/pivotdata_service.aspx⁠