6 reasons why Collage.com chose FlyData over Fivetran
Quick setup. No credit card required. Unlimited sync during trial.
"The cleanliness that FlyData replicates from MySQL to Redshift is really important to me"
Nick Smith Senior Software Architect at Collage
After an extensive search, Collage.com chose FlyData for 6 key reasons:
Excellent Technical support
Replication cleanliness
Clean Table structure
Configurability and Frequency of Replication
Low Migration costs
Worry free replication during crunch time
1
Excellent 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.
2
Replication cleanliness The Collage.com 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.
3
Clean 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."
4
Configurability and Frequency of Replication Collage.com'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.
5
Low Migration costs With FlyData's schema structure and cleanliness of replication, migration was a breeze for Collage.com. "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."
6
Worry free replication during crunch time The holidays are crunch time for Collage.com. They need flawless execution across the organization, and particularly from their data infrastructure.

When failure's not an option, FlyData provides Collage.com with dedicated bandwidth to ensure they can sustain peak volume times. It's just one more reason why Smith and his team love FlyData.
JOIN DATA DRIVEN COMPANIES
Curology Logo
Drop Logo
VividSeats Logo
Slice Logo
Collage Logo
Get Started. Try FlyData Risk-Free.
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.