Reporting Overview
How to setup reporting with Kinetic
The Kinetic Platform system designed for gathering user input and efficiently routing submissions via workflow to accomplish tasks. As designed, Kinetic Request is optimized for end-user performance. The database and data structures are setup so as to provide blazingly fast end-user performance. The database is not designed for general purpose reporting. This document will discuss an approach to facilitate traditional reporting needs.
TL;DR
Use webhooks to replicate transactional data to an SQL database optimized for reporting.
Updated almost 2 years ago