Overview

pRoute is a software company whose app empowers brands to be intentional about their post-purchase experience with visual order tracking, package protection, effortless claim-filing, and the world’s first universal order history. They empower brands to deliver a better customer experience and consumers to feel more confident in their online ordering./p

Supernova Award Category

Next Generation Customer Experience

The Problem

pRoute had multiple sources of data in applications such as Salesforce, Zendesk, Jira, and in a production database, and was not able to connect these sources of data to create a holistic customer view. Route leadership wanted to know how merchants were doing on their platform and how they could better serve them. Without the ability to connect vital data, it was nearly impossible to gather these insights to drive strategic business decisions. Traditional integration would require countless hours manually coding integrations, updating, and maintaining them./p

The Solution

pWith SnapLogic, Route had their first few ETL pipelines up and running the first day. They set up their integration environment in their own domain in the AWS cloud. They were able to start loading data from multiple sources on day one and were fully operational within a week with SnapLogic’s Salesforce Snap Pack and Snowflake Snap Pack. “These Snaps made it extremely easy to load all the data that we needed from Salesforce into our data warehouse,” said Rasmussen./p

The results

pUsing SnapLogic, Route was able to quickly synthesize customer data and glean key insights into how they could improve their customer experience. “SnapLogic is extremely flexible. You can perform ELT, or ETL, or plenty of other sorts of jobs. You can load data in, perform countless transformations on the data, join the data with other sources, filter it out, load it into many different tables based on your own criteria. You can basically do whatever you want with SnapLogic and it makes it very easy,” said Jacob Rasmussen, Data Engineer./p

Metrics

p“Our entire analytics platform and initiatives would not exist without our SnapLogic integration. Before SnapLogic, certain analytics were either simply impossible, or would take much longer due to manual exports and merging data,” said Rasmussen. “We also no longer query our production database directly, but are now able to easily extract all of the data we need out of that database so we can query it without affecting production load. SnapLogic has enabled insights at Route that we never would have been able to achieve without such a powerful integration platform.”/p

The Technology

pSnapLogic’s Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform./p

Disruptive Factor

pWith a small company growing at exceptional speed, Route needed to address large scale problems with small scale resources. Many of the challenges Route had to overcome were the same that multimillion dollar enteprises face, like:/p ul liDisconnected data that limited data analytics/li liLong backlog of integration projects that were time-consuming to build and maintain/li liInability to fully leverage customer data for better business insights/li /ul pConnecting apps like Salesforce, Zendesk, Jira, Snowflake, and estbalished databases is a significant challenege for most entperises, let alone a 200 person comapny./p

Shining Moment

pRoute has also been able to heavily leverage SnapLogic’s REST APIs for many use cases and have plans to use SnapLogic’s Machine Learning Snaps, as well as DynamoDB Snaps for the near future. “Snaplogic is extremely powerful and I am always amazed at how fast it can process millions of rows of data. It makes it extremely easy to connect to sources like Salesforce, Snowflake, Jira, Zendesk, etc. It saves a lot of time,” said Rasmussen./p