Replicating Data Into a Warehouse as Easy as "Set It and Forget It"

May 14, 2018
Fivetran immediately added value for Urban Airship by transferring its corporate data from a legacy third-party system to a SQL Server relational database.

Key Takeaways

  • Always-on customer support
  • Enables the “2,000-foot view”
  • Frees up engineering sources
  • Fivetran UI is "simple and streamlined”

Airship (previously Urban Airship) offers a platform for mobile growth services that includes mobile push, email and text — all with orchestration and AI-based optimization solutions. In short, Airship delivers hyper-personalized messages in real time on any channel in a customer’s martech stack.

Fivetran immediately added value to Airship by transferring its corporate data from a legacy third-party system into its SQL Server Amazon RDS relational database. Fivetran had the right connectors at hand and obliged immediately.

Olv Grolle, the director of business systems at Airship, says that the service level, knowledge and support from Fivetran “was very impressive.”

“Service, that was one of the factors that won our evaluation over Stitch," Grolle says. "It went down to the level of setting up a Slack channel with us as a means to directly connect to our Fivetran support engineers. That was very compatible with our modus operandi. We’re very happy customers. The level of support and nurturing we get is astonishing.”

This is yet another textbook example of the Fivetran always-on customer support credo. What’s more, it underscores that users of Fivetran gain ownership of their application data, even if they stop using that application.

All in all, Fivetran replicates business applications, databases, events and file storage into a high-performance data warehouse. The Fivetran cloud data pipelines are zero-configuration, zero-maintenance and fully managed by Fivetran.

"Set It and Forget It"

Before Airship settled on Fivetran, the company evaluated other platforms, but none of them met their needs. “We kept running into a myriad of problems,” says Ed Zanelli, Airship data architect.

One problem Fivetran solved was that Airship couldn’t get transaction lines from its NetSuite application, one of dozens of business applications that Fivetran supports. Fivetran not only supports those transaction lines, but also offers sync frequency down to 5 minutes for all of its connectors.

“If you can’t get the transaction lines, you’re not getting anything with NetSuite,” Zanelli says. “With Fivetran, we just set it and forget it."

Zanelli says the out-of-the-box connectors Fivetran has built for business applications function without a hitch. And, with a setup that took just minutes, Fivetran enabled Airship to begin the data flow immediately.

“We are now able to correlate data across core business systems that we were not able to do before,” Zanelli says. “We’re now able to cross reference data from different business systems in a coherent way, to take that 2,000-foot view.”

Focus on Data Instead of Replication

Airship has chosen several Fivetran pre-built app “connectors.” They include Netsuite, Salesforce, Stripe and Zuora.

“Fivetran has experts in house who have managed to understand the architecture of a lot of business tools,” says Zanelli. “So now we don’t need to deal with the engineering technical side. We can actually focus on the business data."

Zanelli added, "We were able to free up all resources working on dedicated data replication."

Grolle weighed in as well: “If we hadn’t switched to Fivetran, I think we would still be building connections from scratch instead of understanding our business operations data. The Fivetran UI is simple and streamlined.”

Grolle echoes what many satisfied Fivetran customers say: “Fivetran just works. You set up your replication point, and source, and target system, and that’s virtually it. It has proven very valuable. Fivetran has developed a great solution."

(The Fivetran sales team is available to present a demo, and provide a free trial. Sign up here.)

About Fivetran: Our mission is to democratize data, to make companies data driven, and to give analysts easy access to disparate data sources to perform advanced analytics.

With as little as a five-minute setup, Fivetran replicates all your applications, databases, events and file storage into a high-performance data warehouse. Our cloud data pipelines are zero-configuration, zero-maintenance and fully managed by Fivetran.

Using Fivetran, businesses big and small gain complete control and ownership of their data. It’s easy to join data sources, perform agile analytics, and ultimately discover valuable insights with the business intelligence tools of your choice.

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.