Hevo could be improved as we hit limits, particularly when it couldn't keep up with the high number of databases we wanted to sync frequently—ideally updating everything hourly for near real-time analytics rather than a day behind. We found that with many pipelines, performance degraded. After discussing with Hevo engineers, I learned that Hevo is designed for fast individual pipelines, but struggles with many concurrent pipelines. They suggested that consolidating data from fewer pipelines with more fields would perform better, but even that failed when I tested it with a Business Central database that had numerous fields. Hevo does have limits on the number of pipelines it can manage concurrently and on the number of fields in a single pipeline.Additionally, the API was slower to release compared to the user interface and was not feature-complete, which was frustrating. That said, Hevo actively worked on bridging many gaps. Overall, these were significant pain points I encountered.
