Customer Case Study

Why Chose FlyData Over Fivetran for their Redshift data replication

Michigan, US
Crowdsourcing, Internet
When needed a new ETL-as-a-Service provider, Nick Smith and his team launched an in-depth review of top options, including FlyData and Fivetran. After an extensive search, they chose FlyData for its reliability, ease-of-use, and excellent technical support. And they haven't looked back. is a high-transactional ecommerce site that allows anyone in the world to create meaningful and memorable gifts out of photos. They ingest and analyze hundreds of millions of rows of data every month, which enables the business intelligence (BI) team to generate key insights and make better decisions. They use MySQL as their production database and replicate it to Amazon Redshift.

Nick Smith, senior software architect at, knows how important data replication and accessibility is for his company, but it's not something he wants to spend time worrying about.

"I have a lot of other stuff going on. Reviewing technical requirements, operations work, and a ton of hands-on coding," said Smith.

So when's previous ETL-as-a-Service provider stopped supporting Redshift, Smith's team prioritized factors like ease-of-use, reliability, and technical support when searching for an alternative.

# FlyData vs. Fivetran: Comparing ETL-as-a-Service Vendors

Smith and his colleagues reviewed every major ETL-as-a-Service vendor, including Stitch, Blendo, and Xplenty. After an extensive search, they narrowed their options to FlyData and Fivetran.

In the end, chose FlyData over Fivetran for several reasons:

  • Technical support
  • Table structure
  • Replication cleanliness
  • Configurability and frequency of replication
  • Migration costs
  • Straightforward pricing

Technical support

Smith has been surprised and delighted by the response time and technical competence of FlyData's support team. "FlyData's level of support is far above most other 3rd party vendors we work with. It's been phenomenal," said Smith.

Table structure

Smith's team wanted table structures in Redshift to match as perfectly as possible to those in mySQL. That way, they could write queries for both without thinking about it. "A query we write for mySQL should work in Redshift, and vice versa," said Smith.

FlyData replicates the table structure perfectly from mySQL to Redshift. Fivetran did not. "Fivetran made you create a view for each table in Redshift, which was a no-go," said Smith. "We can't manage that many views."

Replication cleanliness

The team needs their replicated data to be identical with their production data. FlyData has out-of-box functionality to ensure this, including automatic schema change replication.

"The cleanliness that FlyData replicates from mySQL to Redshift is really important to me," said Smith.

Unfortunately, Smith found serious problems with Fivetran's replication cleanliness. "Using Fivetran, the data that gets deleted in MySQL does NOT get deleted in Redshift — it just gets 'marked' as deleted. That was a huge issue for us," said Smith.

Configurability and Frequency of Replication's BI team needs the most up-to-date data at a moment's notice. Smith's team found that Fivetran synced in roughly 5-minute intervals. FlyData, however, syncs in near-real time.

"FlyData won this category," said Smith.

Migration costs

With FlyData's schema structure and cleanliness of replication, migration was a breeze for "It's very transparent. The cost of migration to FlyData was basically zero," said Smith. "With Fivetran, we were going to have to do a bunch of work."

Straightforward pricing

Smith was hesitant to lock themselves into Fivetran's one-year contract requirement. On the other hand, FlyData offered month-to-month subscriptions that were competitive with Fivetran's annual pricing.

"FlyData won this one, too," said Smith.

# FlyData: Worry-free replication to Redshift

The holidays are crunch time for They need flawless execution across the organization, and particularly from their data infrastructure.

When failure's not an option, FlyData provides with dedicated bandwidth to ensure they can sustain peak volume times. It's just one more reason why Smith and his team love FlyData.

More case studies
E-Commerce, Crowdsourcing
"We needed to move data from MySQL to Redshift and we needed to move it around as fast as possible. FlyData does that, and it does that well." – Gareth Tilley, Head of Data Analytics at 99Designs
“The fact that the data can be shown almost in real time in the analysis infrastructure was a very important reason why we chose FlyData” – Koichiro Ohba, CTO of Crowdworks
Contact Management
Reduced time to collect data and issue KPI reports from 10.5 hours down to a minute. Contributed to quicker turnarounds in the service improvement cycle.
View all case studies
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.