PivotData Microservice

PivotData Microservice is an on-premise NET6 app that provides a web API for tabular reports generation (pivot tables, data grids). It may be hosted either on Windows or Linux.

Some key features include:

• direct connection to all popular SQL databases / some NoSQL (MongoDb, ElasticSearch)
  
• data sources and cube models are configured via JSON config
  
• advanced web-based pivot tables
  
• formula measures and report parameters
• transparent security with JSON Web Tokens
  
• web API for rendering pivot tables to HTML and other formats (JSON, CSV, Excel / Excel PivotTable, PDF)
  

Product distribution includes sample front-end components (HTML/JS) that can be easily integrated with any web application.