Blog

All Posts
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Best of 2021: Fivetran’s Year in Review

Best of 2021: Fivetran’s Year in Review

Dozens of new connectors, partner integrations, security and compliance enhancements — and the Fivetran data models you love.

Best of 2021: Fivetran’s Year in Review

Best of 2021: Fivetran’s Year in Review

Dozens of new connectors, partner integrations, security and compliance enhancements — and the Fivetran data models you love.

Read Post →
Protecting Sensitive Data Across Every Fivetran Connector

Protecting Sensitive Data Across Every Fivetran Connector

Column masking for PII and other sensitive data is now universally available — including for SaaS apps, files, events and more.

Read Post →
Simplify Brand Awareness Analysis With Fivetran Data Models

Simplify Brand Awareness Analysis With Fivetran Data Models

Easily combine engagement metrics from Facebook, Instagram, Twitter and LinkedIn.

Read Post →
New Levels of Automation for Your Data Transformation

New Levels of Automation for Your Data Transformation

New Fivetran features help data teams jointly orchestrate Fivetran connectors and transformations using dbt Labs’ open-sourced dbt Core*.

Read Post →
What All Successful Mergers Share: Modern Data Integration

What All Successful Mergers Share: Modern Data Integration

In today’s M&A environment, success requires integrating data stacks and business systems as quickly and seamlessly as possible.

Read Post →
What Is Data Integration?

What Is Data Integration?

Learn how data integration is the key to a mature analytics practice and more.

Read Post →
How to Gain Faster Insights From Your Shopify and Klaviyo Data

How to Gain Faster Insights From Your Shopify and Klaviyo Data

The Fivetran data models for Shopify Holistic Reporting easily combines Shopify and Klaviyo data into analytic-ready models, helping analysts create a rich portrait of customer personas for marketing and much more.

Read Post →
The Prefect Way to Automate Your Data Pipelines With Fivetran

The Prefect Way to Automate Your Data Pipelines With Fivetran

Dataflow automation platform Prefect brings Fivetran connectors to its open-source orchestration project.

Read Post →
New and Upcoming Data Connectors and dbt Packages

New and Upcoming Data Connectors and dbt Packages

Keep track of our data connector and dbt package releases with monthly updates.

Read Post →
Leverage the Power of Fivetran Business Critical on Microsoft Azure

Leverage the Power of Fivetran Business Critical on Microsoft Azure

Enterprises using Microsoft Azure can now deliver secure, automated data pipelines while boosting compliance with privacy and industry mandates using Fivetran Business Critical.

Read Post →
The Data Integration Revolution: A Solution Architect’s Perspective

The Data Integration Revolution: A Solution Architect’s Perspective

Life for data professionals keeps getting better — and more interesting.

Read Post →
Launch Fivetran Through Databricks Partner Connect

Launch Fivetran Through Databricks Partner Connect

You can now set up Fivetran data pipelines via Databricks Partner Connect. Here’s how to do it.

Read Post →
New Report: Enterprises Should Avoid DIY Pipelines

New Report: Enterprises Should Avoid DIY Pipelines

A recent survey from Wakefield Research finds that when enterprises build their own data pipelines, decision-making and revenue suffer.

Read Post →
10 Database Schema Best Practices

10 Database Schema Best Practices

Follow these tips to ensure that your database schema delivers maximum utility for data warehouse users, data analysts, and data scientists.

Read Post →
11 Database Schema Mistakes to Avoid

11 Database Schema Mistakes to Avoid

A good database schema is indispensable for making data warehouses work. Get it wrong, and you’ll be in a world of hurt.

Read Post →
Supporting Employee Philanthropy at Fivetran

Supporting Employee Philanthropy at Fivetran

When Fivetranners are moved to give back — to their own communities or the global community — Fivetran helps increase their impact.

Read Post →
How to Change Minds When Data Alone Isn't Enough

How to Change Minds When Data Alone Isn't Enough

A leading researcher explains how emotion, intuition and storytelling can be more powerful than data.

Read Post →
The Future of Fivetran and HVR

The Future of Fivetran and HVR

Our priority is improving the experience of every customer — without compromising the features you rely on.

Read Post →
Data Egress Cost Analysis

Data Egress Cost Analysis

Understand the impact of data transfer and egress costs across Microsoft Azure, Amazon Web Services and Google Cloud Platform.

Read Post →
Ensuring That Fivetran Parents Have a Voice

Ensuring That Fivetran Parents Have a Voice

A new employee resource group helps parents and guardians feel comfortable asking for what they need.

Read Post →
How Fivetran Uses the Looker API

How Fivetran Uses the Looker API

The Looker API allows you to programmatically manage your Looker environment. Learn how to do it here!

Read Post →
Managed ELT Over DIY: How to Maximize the Value of Enterprise Data

Managed ELT Over DIY: How to Maximize the Value of Enterprise Data

Managed data integration is the best way for enterprises to get maximum value from their data — and their data engineering teams.

Read Post →
An Introduction to Digital Marketing Analytics

An Introduction to Digital Marketing Analytics

What is marketing analytics? Learn why it’s important to measure and optimize your marketing activities, and how to get started.

Read Post →
Enterprise Data Warehouses: Definition and Guide

Enterprise Data Warehouses: Definition and Guide

An enterprise data warehouse is critical to the long-term viability of your business.

Read Post →
Unlocking 360-Degree Customer Data for Retailer johnnie-O

Unlocking 360-Degree Customer Data for Retailer johnnie-O

Here's how to build an enterprise-class retail customer data warehouse.

Read Post →
Fivetran in 2022 and Beyond

Fivetran in 2022 and Beyond

Our VP of Product previews the next stage in the evolution of Fivetran.

Read Post →
Fivetran Integrations Highlighted at Google Cloud Next '21

Fivetran Integrations Highlighted at Google Cloud Next '21

Fivetran integrates seamlessly with multiple Google Cloud services, and the addition of HVR technology will improve the experience.

Read Post →
Imagining the Future of Analytics and the Modern Data Stack

Imagining the Future of Analytics and the Modern Data Stack

Three tech leaders discuss the future of analytics and data architecture — and how to get the most value from them.

Read Post →
Data Lakes vs. Data Warehouses

Data Lakes vs. Data Warehouses

Successful analytics depends on choosing the right approach to storing your enterprise data.

Read Post →
What Is the Modern Data Stack?

What Is the Modern Data Stack?

A radically new approach to data integration saves engineering time, allowing engineers and analysts to pursue higher-value activities.

Read Post →
ETL vs. ELT: Choose the Right Approach for Data Integration

ETL vs. ELT: Choose the Right Approach for Data Integration

Learn about ETL and ELT so you can decide which method works for you.

Read Post →
It’s Official: Fivetran and HVR Are Now One

It’s Official: Fivetran and HVR Are Now One

Fivetran has closed its acquisition of HVR. CEOs George Fraser and Anthony Brooks-Williams explain how it happened and what it means for customers.

Read Post →
Fivetran Goes Multi-Cloud With Business Critical Plan

Fivetran Goes Multi-Cloud With Business Critical Plan

Run Fivetran on different clouds to gain flexibility and control while reducing costs.

Read Post →
Announcing the Winners of the 2021 Modern Data Stack Awards

Announcing the Winners of the 2021 Modern Data Stack Awards

We're celebrating the data professionals who are transforming their businesses and communities, one data-driven decision at a time.

Read Post →
Fivetran Now Deploys on Microsoft Azure

Fivetran Now Deploys on Microsoft Azure

Our joint customers can remain within Azure for all their cloud services, facilitating compliance and minimizing data movement costs.

Read Post →
Modern Data Stack Conference 2021: Don’t Miss These Sessions

Modern Data Stack Conference 2021: Don’t Miss These Sessions

You should attend every single session at this year’s conference — but if life forces you to make cruel choices, consider these first.

Read Post →
How to Build an Effective Enterprise Data Catalog

How to Build an Effective Enterprise Data Catalog

Learn how you can keep track of all your organization’s data assets.

Read Post →
And the Winners of the 2021 Fivetran Partner Awards Are ...

And the Winners of the 2021 Fivetran Partner Awards Are ...

At Fivetran, our partners are essential to our success. We launched our inaugural Partner Awards to show them the love they deserve.

Read Post →
Fivetran Agrees to Acquire HVR, Raises Series D

Fivetran Agrees to Acquire HVR, Raises Series D

Fivetran plans to acquire HVR, the leader in enterprise database replication, and raises $565 million in Series D funding.

Read Post →
Product Managers! Join Us at #mdscon 2021

Product Managers! Join Us at #mdscon 2021

This year's Modern Data Stack Conference features speakers and sessions for data professionals of all kinds.

Read Post →
Fivetran Achieves PCI DSS Level I Validation

Fivetran Achieves PCI DSS Level I Validation

Ecommerce customers can now connect Fivetran to PCI-validated data sources and transmit cardholder data to a PCI-validated destination.

Read Post →
Fivetran, SOC2 Type 2 and You

Fivetran, SOC2 Type 2 and You

An in-depth discussion of Fivetran’s SOC 2 Type 2 compliance and Powered By Fivetran (PBF).

Read Post →
Team Leads! Join Us at #mdscon 2021

Team Leads! Join Us at #mdscon 2021

This year's Modern Data Stack Conference features speakers and sessions for data professionals of all kinds.

Read Post →
Introducing the Fivetran Terraform Provider

Introducing the Fivetran Terraform Provider

Integrate Fivetran into your infrastructure-as-code development.

Read Post →
Announcing the First Fivetran SDK

Announcing the First Fivetran SDK

Our new software-development tools offer improved usability over the REST API for developers in Go.

Read Post →
Applying the Scientific Method to Improve Business Intelligence

Applying the Scientific Method to Improve Business Intelligence

The scientific method is a proven route to successful, tested and verified improvement. Here’s how to combine it with BI.

Read Post →
What Is a Database Schema?

What Is a Database Schema?

Use schemas to make life easier for your analysts and engineers.

Read Post →
Data Analysts! Join Us at #mdscon 2021

Data Analysts! Join Us at #mdscon 2021

This year's conference features speakers and sessions for data professionals of all kinds.

Read Post →
Fivetran AWS Customers Can Now Manage Credential Encryption

Fivetran AWS Customers Can Now Manage Credential Encryption

With customer-managed keys, Fivetran Business Critical users running AWS gain full control over credential encryption.

Read Post →
Build Your Own Agenda for the Modern Data Stack Conference

Build Your Own Agenda for the Modern Data Stack Conference

With a quick scroll and a few clicks, you can cue up the speakers and sessions you’re most excited about.

Read Post →
How to (Re)Use dbt: Guiding Rapid MDS Deployments

How to (Re)Use dbt: Guiding Rapid MDS Deployments

Learn how off-the-shelf, open-source dbt packages make data modeling frictionless.

Read Post →
Data Engineers and Data Architects! Join Us at #mdscon 2021

Data Engineers and Data Architects! Join Us at #mdscon 2021

This year's Modern Data Stack Conference features speakers and sessions for data professionals of all kinds.

Read Post →
Fivetran Adds Private Networking Support for AWS Customers

Fivetran Adds Private Networking Support for AWS Customers

Fivetran Business Critical secures data traffic with AWS PrivateLink.

Read Post →
 What Is a Data Pipeline?

What Is a Data Pipeline?

A data pipeline is a series of actions that combine data from multiple sources for analysis or visualization.

Read Post →
Understanding the Differences Between OLTP and OLAP

Understanding the Differences Between OLTP and OLAP

In the data analytics world, OLTP systems generate source data and OLAP systems analyze it.

Read Post →
PostgreSQL vs. MySQL: What You Need to Know

PostgreSQL vs. MySQL: What You Need to Know

Here’s how to choose the right relational database for your next project.

Read Post →
How Digital Transformation Accelerates Finance Analytics

How Digital Transformation Accelerates Finance Analytics

Integrating digital technologies into every area of your business can vastly improve your finance analytics.

Read Post →
Industry Leaders: Build a Multi-Cloud Modern Data Stack

Industry Leaders: Build a Multi-Cloud Modern Data Stack

Four technology leaders discuss the modern data stack — and agree that multi-cloud is the best option.

Read Post →
Introducing the Industry’s Most Secure Cloud Data Integration Platform

Introducing the Industry’s Most Secure Cloud Data Integration Platform

Fivetran Business Critical meets the needs of enterprises with extremely sensitive data and strict compliance requirements.

Read Post →
Agenda Released for the Modern Data Stack Conference 2021

Agenda Released for the Modern Data Stack Conference 2021

This year’s conference includes 40+ sessions across four virtual stages and features some of the brightest minds in the data community.

Read Post →
Fivetran Named in 2021 Gartner Magic Quadrant for Data Integration Tools

Fivetran Named in 2021 Gartner Magic Quadrant for Data Integration Tools

Our rapid growth trajectory continues as Fivetran is recognized for completeness of vision and ability to execute.

Read Post →
Database Schema Design: Best Practices for Integration and Analysis

Database Schema Design: Best Practices for Integration and Analysis

Learn how to design normalized schemas that make life easier for analysts and data engineers.

Read Post →
How to Handle HIPAA Concerns With Cloud Data Warehouses

How to Handle HIPAA Concerns With Cloud Data Warehouses

Achieve HIPAA compliance and reduce risk while offloading some of your operational burden.

Read Post →
Keynote Speakers Revealed for the Modern Data Stack Conference 2021

Keynote Speakers Revealed for the Modern Data Stack Conference 2021

Hear from data leaders from Fivetran, Databricks, and more at our second annual community event.

Read Post →
Transformation Pitfalls and Best Practices

Transformation Pitfalls and Best Practices

Want to get the most out of data transformation? Here are the pitfalls and best practices to keep in mind.

Read Post →
Three Months Under the Bodhi Tree: The Fivetran Research Rotation

Three Months Under the Bodhi Tree: The Fivetran Research Rotation

A unique program allows any Fivetran engineer, anywhere in the world, to spend months pondering one interesting technical problem.

Read Post →
How to Use Fivetran dbt Packages to Accelerate Analytics

How to Use Fivetran dbt Packages to Accelerate Analytics

Fivetran dbt packages accelerate analytics with off-the-shelf SQL for data modeling.

Read Post →
Data Analytics vs. Business Intelligence

Data Analytics vs. Business Intelligence

Should your data team focus on business problems and use cases, or expand into more complex areas like predictive analytics?

Read Post →
Transformations for the Modern Data Stack: SQL vs. GUI

Transformations for the Modern Data Stack: SQL vs. GUI

Not sure whether SQL or GUI transformations are better for your business? Here are the pros and cons of each approach.

Read Post →
Calling All Software Engineers: Come Thrive With Us at Fivetran

Calling All Software Engineers: Come Thrive With Us at Fivetran

A collaborative culture, healthy work-life balance and plenty of technical challenges make Fivetran a great place for engineers.

Read Post →
Survey: You're Not Getting the Most Out of Your Data Analysts  

Survey: You're Not Getting the Most Out of Your Data Analysts  

Data analysts are a critical resource, but often face challenges and blockers to timelines.

Read Post →
Change Data Capture: An Increasingly Critical Mechanism for Organizations

Change Data Capture: An Increasingly Critical Mechanism for Organizations

Change data capture helps your business stay competitive by keeping data up to date.

Read Post →
Fivetran Automated Cloud Data Integration Now Deploys on AWS

Fivetran Automated Cloud Data Integration Now Deploys on AWS

Joint customers can now stay within AWS for all cloud services and minimize data movement costs.

Read Post →
Business Intelligence: What You Need to Know

Business Intelligence: What You Need to Know

Business intelligence is the art of extracting actionable insights from your data. There’s a whole stack of technologies under the hood.

Read Post →
Fivetran Partners With Hightouch to Help Activate Your Data

Fivetran Partners With Hightouch to Help Activate Your Data

Hightouch and Fivetran turn your data warehouse into your customer data platform.

Read Post →
Submit Your Nomination for the Modern Data Stack Awards

Submit Your Nomination for the Modern Data Stack Awards

Winners in seven categories — including Data Hero and Transformation for Good — will be announced at the Modern Data Stack Conference.

Read Post →
Analysis: Fivetran Is the Fastest-Growing Cloud ELT Provider

Analysis: Fivetran Is the Fastest-Growing Cloud ELT Provider

Gartner recognizes Fivetran as the “vendor of choice” for enterprises looking to modernize their data infrastructure.

Read Post →
Data Warehouse vs. Database

Data Warehouse vs. Database

Data warehouses are a particular kind of database. Learn how they are uniquely suited to analytics.

Read Post →
Use HubSpot Data to Build a Holistic View of Your Customers

Use HubSpot Data to Build a Holistic View of Your Customers

HubSpot data becomes vastly more valuable when you can use it to build a comprehensive view of customer behavior.

Read Post →
Join Us at the Modern Data Stack Conference 2021

Join Us at the Modern Data Stack Conference 2021

Hear from over 50 data industry leaders, practitioners and visionaries as they share how they’re transforming their businesses.

Read Post →
The Importance of ETL Security

The Importance of ETL Security

ETL security is essential for safeguarding your customer's data and complying with regulations. Learn about the Fivetran approach.

Read Post →
In-Warehouse Machine Learning and the Modern Data Stack

In-Warehouse Machine Learning and the Modern Data Stack

We evaluate various in-data warehouse machine learning services, and discuss each of their benefits and requirements.

Read Post →
Why Does My Business Need to Transform Data?

Why Does My Business Need to Transform Data?

Data transformations are essential to connecting the dots between and making the most of your data.

Read Post →
Using Analytics to Disrupt the Home Insurance Industry

Using Analytics to Disrupt the Home Insurance Industry

A French startup is leveraging its modern data stack to overturn a longstanding business model.

Read Post →
Automatically Sync Formula Field Values in Salesforce

Automatically Sync Formula Field Values in Salesforce

You no longer need to coordinate with your administrator and manually translate formulas from Salesforce SQL to Standard SQL.

Read Post →
dbt Explained

dbt Explained

Learn how dbt adds data modeling and transformation to the modern data stack.

Read Post →
Introducing the Fivetran Protocol

Introducing the Fivetran Protocol

Here's how SaaS providers can build bulletproof data replication APIs.

Read Post →
What Is Data Transformation?

What Is Data Transformation?

Learn why you need data transformation tools and how to apply them in your data strategy.

Read Post →
How to Build a Modern Data Stack From the Ground Up

How to Build a Modern Data Stack From the Ground Up

A data architecture expert gives a crash course on moving analytics to the cloud — including a step-by-step plan to ensure success.

Read Post →
How to Launch Fivetran Through the Amazon Redshift Console

How to Launch Fivetran Through the Amazon Redshift Console

Amazon Redshift supports native integration with Fivetran. Here’s how to set it up.

Read Post →
Data Transformation Fundamentals, Uses and Tools

Data Transformation Fundamentals, Uses and Tools

Data can transform a struggling business into a successful one, but first, you need to transform the data. Here’s how.

Read Post →
Key Considerations for Pipeline Performance

Key Considerations for Pipeline Performance

Data pipeline performance hinges on several important techniques, including algorithmic optimization and parallelization.

Read Post →
Growing Revenue With a 360-Degree Customer View

Growing Revenue With a 360-Degree Customer View

Two data experts share their journeys toward better customer engagement, fueled by faster access to more data.

Read Post →
Fivetran Introduces Breakthrough for Database Replication

Fivetran Introduces Breakthrough for Database Replication

Best-in-class database replication now combines the benefits of snapshots and log-based systems — while avoiding the drawbacks.

Read Post →
How We Build and Scale a Healthy Workplace Culture

How We Build and Scale a Healthy Workplace Culture

To ensure a supportive workplace culture on four continents, we start with a set of non-negotiable principles.

Read Post →
Video Analytics at Scale: Challenges and Best Practices

Video Analytics at Scale: Challenges and Best Practices

Data integration enables machine learning. Learn how you can use video analytics to automatically detect patterns in video.

Read Post →
How to Modernize Your Analytics Department

How to Modernize Your Analytics Department

Three leading data practitioners share advice on building a modern analytics practice — including how to avoid costly missteps.

Read Post →
What Is a Data Lakehouse?

What Is a Data Lakehouse?

The data lakehouse is a promising new technology that combines aspects of data warehouses and data lakes.

Read Post →
Pride Month Spotlight: Travis Hatfield

Pride Month Spotlight: Travis Hatfield

Our teammate Travis shares what Pride means to him and shouts out unsung heroes in the LGBTQ+ community.

Read Post →
Centralizing Your Data With Fivetran and  Salesforce Customer 360

Centralizing Your Data With Fivetran and Salesforce Customer 360

Build a comprehensive picture of how customers interact with your company.

Read Post →

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.