Case Study: Knotice achieves real-time customer insights and seconds-level responsiveness with Pivotal

Knotice Increased Responsiveness Provides Customers With Answers in Seconds, Not Hours

Knotice, a data-management provider that builds individual customer profiles from hundreds of millions of high‑velocity events, was hindered by complex, multi‑stage ETL on Microsoft SQL Server that turned analytics and reporting into hours‑long jobs—threatening its ability to deliver real‑time insights and fast campaign activation for retail, CPG and telecom clients.

By moving to Pivotal Greenplum Database on a Pivotal Data Computing Appliance, using Pivotal RabbitMQ for replication and MADlib/Redis for in‑database analytics and caching, Knotice cut report times from 45 minutes to 45 seconds, reduced Tableau dashboard builds from 15 minutes to 5 seconds, increased multi‑table update/inserts to 77,000/sec (from 1,400), and shrank ad‑hoc segmentation from ~30 minutes to 60–90 seconds—enabling real‑time data exploration and positioning Knotice as a strategic partner to customers.

Knotice