A Real-Time Cloud Data Warehouse at Inspyrus

Invoice Automation Reports Powered by a Modern Data Stack

Inspyrus – an innovative Silicon Valley Fintech company – provides their customers with rich reports using a modern data stack powered by Snowflake, Striim, dbt, and Looker.

The Challenge

Providing customers with rich reports with real-time operational data from an OLTP database.

Inspyrus’s CTO Prashant Soral wanted to provide their customers with a live view into their invoicing reports. However with their old data stack, data refresh would take an hour and improvements would take weeks to deliver. To overcome these inefficiencies, they had to solve a few key problems:
  • Replicate invoicing data from their private cloud operational databases in a non-intrusive, cloud-ready format
  • Store and analyze the data in a scalable cloud platform
  • Visualize data in a rich business intelligence tool These problems were further complicated by the requirement to efficiently capture data from a relational OLTP database and deliver it into Snowflake in real-time.

Industry:
Technology, Financial Services

Data Source:
OLTP Database

ETL / Replication:
Striim

Business Intelligence:
Looker

Cloud Platform:
Snowflake

These problems were further complicated by the requirement to efficiently capture data from a relational OLTP database and deliver it into Snowflake in real-time.

Inspyrus also needed a solution that was able to support their multi-tenant database environment with multiple database instances.

The Solution

Inspyrus real time analytics case study

A Modern Data Stack with Striim, Snowflake, dbt, and Looker where Striim feeds Snowflake with operational data in real-time

Inspyrus evaluated multiple data integration vendors by testing their ability to capture data from a relational Database and reliably deliver to Snowflake with fast performance. After doing so, Inspyrus chose Striim for their superior database change data capture capabilities and integration with Snowflake.

By feeding real-time operational data with Striim, Inspyrus now leverages Snowflake as a scalable cloud platform driving their business intelligence reports in Looker.

“Thanks to Striim we are accelerating our customer insights in Snowflake. Our legacy analytics platform used to take an hour per customer data load and weeks for each new deployment. With Striim we are able to transfer operational data to Snowflake in near real time for all customers.”
Prashant Soral
CTO at Inspyrus

The Result

Customer-facing reports visualizing their real-time invoicing data. Faster time to market.

“Thanks to Striim we are accelerating our customer insights in Snowflake. Our legacy analytics platform used to take an hour per customer data load and weeks for each new deployment. With Striim we are able to transfer operational data to Snowflake in near real-time for all customers.”

Striim also sped up Inspyrus’s time to market when launching new features and improvements in their data stack.

“Consolidating our data in Snowflake with Striim allows us to deploy improvements in less than an hour.”

Inspyrus’s modern data stack with Striim, Snowflake, dbt, and Looker provides rich reports and significant value-add to their customers’ invoicing operations.

“Striim further enables us to provide our customers with detailed, live reports by providing real-time data integration from operational systems to Snowflake.” – Prashant Soral, CTO at Inspyrus.