We have made massive improvements to our business thanks to FlyData enabling us to have our data available on demand in Redshift.
For life’s most important purchases, ConsumerAffairs creates expert Buyers Guides and uses its over 1 million verified reviews on over 3,000 companies to help everyday consumers make the best decisions for themselves and their families.
The first time Ron, Director of Architecture of ConsumerAffairs, the world’s fastest-growing reviews aggregator, and an Inc. 5000 company, logged into FlyData, it kinda surprised him, he says.
“I was like, ‘Is this it?’. It was so simple and easy.”
Discovering they needed FlyData, unfortunately, was not.
You see, ConsumerAffairs had a problem you’re probably familiar with: They had a lot of data and nowhere they could put it all to analyze it.
The simple solution: Amazon’s Redshift data warehouse.
But this created its own problem: How should they get their data into Redshift?
With a wistful tone, Ron admits that they originally tried doing it themselves.
“But that took forever,” He recounts, “So we pivoted to trying some open source tools, such as Tungsten, but those took too much maintenance and configuration. We were a small company trying to scale and this was becoming a huge distraction.”
They needed to sync over 98 tables across 3 different MariaDB databases into Redshift in near real-time, but they couldn’t afford to spend the time maintaining a pipeline.
“We considered a few other options, but ultimately decided on FlyData for its ease of use and support.”
In minutes, Ron connected their Redshift database and their MySQL instance. The full sync took less than a day and has been replicating changes in near real-time almost flawlessly since.
“The user experience and the support are great,” Ron says, “It works so well, that we forget it’s there.”
Because of FlyData’s real-time replication, 90% of the ConsumerAffairs team has been able to make full use of their Business Intelligence tools, Looker and Mode Analytics.
“FlyData has enabled us to run reports and queries on our data quickly and easily. We have made massive improvements to our business thanks to FlyData enabling us to have our data available on demand in Redshift.”
With an easy one-time setup, you can focus on uncovering data to make business decisions.