Fivetran Introduces New Enterprise-Ready Tool Featuring In-Warehouse Data Change
SAN FRANCISCO, June 3, 2019 – Fivetran, which builds automated technology to help analysts replicate data into cloud warehouses, today unveiled its new in-warehouse transformation product, Fivetran Transformations, at the Snowflake Summit data conference. Designed to bring simplified, fail-safe data transformations to Fivetran’s automated data pipeline solution, the agile end-to-end tool enables data teams to execute SQL when new data arrives or on a schedule. Users of Snowflake’s warehouse platform can now trial the feature for free; support for additional database and warehouse destinations including Google BigQuery, Amazon Redshift, and Microsoft Azure will roll out soon.
Fivetran Transformations is an extension of the software company's 100+ pre-engineering data connectors. The new tool features everything needed to orchestrate SQL-based transformations in the data warehouse as opposed to antiquated data pipeline technology, which applies transformations before the data enters the warehouse. By putting an automated transformation tool inside the warehouse, as Fivetran does, the original data is protected and available should a restore be required. This delivers enormous scalability, the ability to recover from failure, and time-saving benefits.
“Fivetran is all about keeping it simple: that’s why our data pipelines are zero-configuration,” said George Fraser, co-founder and CEO at Fivetran. “The new Fivetran transformation tool is the ideal companion to our data pipelines. It allows our users to solve complex problems without wrangling infrastructure so you can focus your efforts on creating insights for your business.”
Fivetran is built on the idea that configuration-heavy ETL (extract-transform-load) protocols are outdated and burdensome in today’s cloud-based data environments. Its zero-configuration E-L-T (extract-load-transform) model reduces risk, conserves analytical and technical resources for strategic projects, and allows for greater business agility to deploy new tools and scale across an organization.
"Fivetran’s new transformation tool is the embodiment of modern ELT design and offers clear advantages over traditional ETL, which isn’t built to harness cloud capabilities,” Snowflake Partner Ecosystems Product Manager, Harsha Kapre said. “Since the transformation tool is integrated with the data warehouse, users can make the most of an extremely performant and infinitely scalable cloud-built data warehouse architecture, like Snowflake.”
Fivetran Transformations integrates seamlessly with the company’s automated data platform solution and features simplified management of the entire pipeline in one, single tool. The robust logging and notification system makes reporting easy and enables teams to quickly diagnose and resolve errors.
“The new Fivetran Transformations tool makes a ton of sense. You don’t need to go to a lot of effort to get your transforms to work, and users can view, add, and manage transformations within the Fivetran dashboard,” said Mike Fuller, senior solutions architect at Red Pill Analytics. “Fivetran has done all of the hard work by figuring out various APIs and database connectivity, so this transformation product continues their tradition of simplifying analytics.”
For more information about Fivetran and to trial its new transformation tool for free, visit https://fivetran.com/.
For companies looking for a strategic partner to help them with the transformation tool, or to build out a modern data strategy using Fivetran, select partners from the company's global network of system integrators are ready to provide assistance including Interworks, Das42, Redpill Analytics, Analytics Academy, Sutter Mills, and Decisive Data.
About Fivetran:
Fivetran is the smartest, fastest way to load data into your cloud warehouse. Prebuilt, zero-maintenance Fivetran connectors deployed in five minutes and completely replicate your applications, databases, events and files -powering comprehensive business insights. Fivetran builds the best schemas and ERDs around, and we protect the continuity of your data projects with automatic schema migrations and incremental batch updates.
Source: Fivetran
