Blog

All Posts
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
7 essential database schema best practices

7 essential database schema best practices

Your database schema is the foundation for everything you do with data. Learn our essential best practices in our complete guide.

7 essential database schema best practices

7 essential database schema best practices

Your database schema is the foundation for everything you do with data. Learn our essential best practices in our complete guide.

Read post →
Governing data movement with the Fivetran Metadata API

Governing data movement with the Fivetran Metadata API

The Fivetran Metadata API allows you to track data “in flight” as it moves through Fivetran-managed pipelines — delivering complete visibility across systems, from source to destination.

Read post →
What is data integration? Definition, benefits and more

What is data integration? Definition, benefits and more

Data integration is vital for businesses that want to improve their processes and customer experience. Learn more about how it can help your business.

Read post →
Three ways analytics can accelerate your sales pipeline

Three ways analytics can accelerate your sales pipeline

Successful teams blend the art of sales with a data-driven pipeline strategy.

Read post →
Maximize Amazon Ads ROI with a data-driven campaign strategy

Maximize Amazon Ads ROI with a data-driven campaign strategy

Amazon Ads offers a tremendous opportunity to reach potential customers — especially when you use data to guide your campaigns.

Read post →
Fivetran named in 2022 Gartner Magic Quadrant and Market Share Analysis reports

Fivetran named in 2022 Gartner Magic Quadrant and Market Share Analysis reports

For the third year in a row, we were recognized for our "ability to execute" and "completeness of vision."

Read post →
Survey: Lack of data automation inhibits AI maturity

Survey: Lack of data automation inhibits AI maturity

Without automated data integration, broad trust in AI and the right expertise, organizations will struggle to mature their AI capabilities.

Read post →
Gain real-time insights on SAP data with Fivetran & Snowflake

Gain real-time insights on SAP data with Fivetran & Snowflake

Stale data costs businesses in poor outcomes and decision-making. With Fivetran and Snowflake, it’s simple to gain real-time access to your SAP ERP data and maximize its value.

Read post →
Empowering analysts with new data models for ad reporting

Empowering analysts with new data models for ad reporting

Our six new models are aggregated on the most common granularities for ad-related metrics, so marketing analysts can hit the ground running.

Read post →
Survey: Enterprise data leaders see value in modern infrastructure

Survey: Enterprise data leaders see value in modern infrastructure

IT decision-makers offer insights into their modernization plans, which include automating data integration and adopting lakehouse technology.

Read post →
New and upcoming connectors and data models

New and upcoming connectors and data models

Keep track of new releases for our data connectors and data models for dbt with this regularly updated list.

Read post →
How data teams can do more with fewer resources

How data teams can do more with fewer resources

New data tools and technologies can help your team get more done with less budget, headcount and risk.

Read post →
Fivetran extends private networking to support Databricks

Fivetran extends private networking to support Databricks

Fivetran Business Critical, our highest-security plan, can now send your data to Databricks while avoiding the public internet.

Read post →
Thriving after a career change: From nursing to tech sales

Thriving after a career change: From nursing to tech sales

Taking a non-traditional career path in tech sales can pay off. All you need is drive, determination and self-belief.

Read post →
Power your database replication with HVA for SQL Server

Power your database replication with HVA for SQL Server

Learn how Fivetran is addressing your high-volume database replication needs with our newest High Volume Agent connector for SQL Server.

Read post →
Must-have metrics for evaluating data professionals

Must-have metrics for evaluating data professionals

Learn how to evaluate the efforts of your data engineers, analytics engineers and data analysts.

Read post →
A new framework for evaluating data teams

A new framework for evaluating data teams

Data teams can deliver informational and operational value. Learn what they are and why they matter.

Read post →
I took Redshift Serverless for a spin — here’s what I found

I took Redshift Serverless for a spin — here’s what I found

Today’s cloud data platforms have to be simple to use and provide an intuitive user experience while not sacrificing key features and functionality.

Read post →
Manage data pipelines at scale with the Fivetran REST API

Manage data pipelines at scale with the Fivetran REST API

Learn how the Fivetran REST API allows you to programmatically manage users, groups and connectors to scale data workflows and improve your overall security posture.

Read post →
Iceberg in the modern data stack

Iceberg in the modern data stack

The future of the modern data stack is tightly coupled to how data warehouses evolve — and that’s where Iceberg comes in.

Read post →
Forbes exclusive: The $5.6 billion internet plumbers

Forbes exclusive: The $5.6 billion internet plumbers

Fivetran co-founders George Fraser and Taylor Brown became flush by piping data around the cloud.

Read post →
Six ways high-volume data replication reduces SAP data issues

Six ways high-volume data replication reduces SAP data issues

A high-volume data replication solution makes it easy to gain real-time access and easily integrate your SAP ERP data so you can maximize its value.

Read post →
How a modern data stack supports data maturity

How a modern data stack supports data maturity

Modern, cloud-based data infrastructure can serve as a bridge from the beginning of your data journey to the final stages of data maturity.

Read post →
Five benefits of real-time data warehousing

Five benefits of real-time data warehousing

Businesses aiming to deliver superior digital experiences, retain customers and innovate rapidly need to get value from data faster, which real-time data warehousing enables.

Read post →
Three trends shaping the modern data stack

Three trends shaping the modern data stack

Fivetran CEO George Fraser, Databricks CEO Ali Ghodsi and dbt Labs CEO Tristan Handy discuss what's next for the technologies powering data analytics and engineering.

Read post →
Closing the gender gap in tech sales

Closing the gender gap in tech sales

How we strive to create the best experience for the women we support and promote at Fivetran.

Read post →
Data challenges: From mainframes to the modern data stack

Data challenges: From mainframes to the modern data stack

The sheer quantity and diversity of data sources make today’s landscape strikingly different — which requires a new set of tools.

Read post →
Build vs. buy data pipelines: Costs to consider

Build vs. buy data pipelines: Costs to consider

A few simple calculations illustrate why it's ill-advised to build your own data pipeline.

Read post →
Unlock fast, log-free database replication

Unlock fast, log-free database replication

With Fivetran’s teleport sync, you can quickly replicate database changes with just a read-only user.

Read post →
If you’re not an engineer, sales is a gateway into tech

If you’re not an engineer, sales is a gateway into tech

Numerous careers that exist in tech don’t require coding skills. Working as an SDR is a way to tap into many of them.

Read post →
How to solve your biggest SAP ERP data integration challenges

How to solve your biggest SAP ERP data integration challenges

Stop struggling with SAP ERP data integration issues and easily connect and access your data in real-time using high-volume data replication.

Read post →
Orchestrating ELT in Airflow: Catching every sync with XCOM

Orchestrating ELT in Airflow: Catching every sync with XCOM

Eliminate hanging sensors with new Fivetran Airflow provider release.

Read post →
How to manage data integration with hybrid cloud

How to manage data integration with hybrid cloud

Bi-directional data movement and low latency are key to effectively integrating data between on-prem and cloud for real-time analysis.

Read post →
Fivetran wins three major Partner of the Year awards

Fivetran wins three major Partner of the Year awards

Google, Snowflake and Databricks recognize us for exceptional cloud data integration technology.

Read post →
Celebrating Pride Month at Fivetran

Celebrating Pride Month at Fivetran

We’re proud to support the LGBTQIA+ community this Pride Month and beyond.

Read post →
Three ways to transform your data analyst processes

Three ways to transform your data analyst processes

Learn how Fivetran Transformations for dbt Core can help your data analyst teams find efficiencies and optimize data pipelines.

Read post →
Up close with Fivetran board member Julie Richardson

Up close with Fivetran board member Julie Richardson

Our newest board member speaks about the company’s explosive growth and the “infectious enthusiasm” of its founders.

Read post →
How to comply with data residency requirements with Fivetran

How to comply with data residency requirements with Fivetran

Learn key considerations in establishing data residency requirements.

Read post →
Data integration and the data hierarchy of needs

Data integration and the data hierarchy of needs

Data integration plays a foundational role in the progression to data and analytics mastery.

Read post →
History mode for databases has arrived

History mode for databases has arrived

Our new feature helps you implement Type 2 slowly changing dimensions for your historical database analytics with no coding needed.

Read post →
How data-driven strategies can reverse the Great Resignation

How data-driven strategies can reverse the Great Resignation

People analytics can help you understand employee pain points and take steps to retain top talent.

Read post →
In uncertain markets, businesses invest in data

In uncertain markets, businesses invest in data

Fivetran and our modern data stack partners are poised to thrive.

Read post →
Fivetran supports mental health and wellness with Thrive+

Fivetran supports mental health and wellness with Thrive+

The mission of the Thrive+ ERG is to create a safe and supportive space that’s inclusive of the neurodiverse and neurotypical people of Fivetran.

Read post →
Perform rapid analysis of your app platform data

Perform rapid analysis of your app platform data

With Fivetran’s new App Reporting data model, you can easily roll your Apple App Store and Google Play data into a unified schema for seamless reporting.

Read post →
What is a database schema? Types and uses in data integration

What is a database schema? Types and uses in data integration

Database schemas help with data integration and database optimization to drive better analysis and faster results.

Read post →
Scalable data infrastructure in under an hour

Scalable data infrastructure in under an hour

In a new ebook and video, we show you how to rapidly launch infrastructure that can scale with your startup as it grows into an enterprise.

Read post →
Can ML be absorbed by the DBMS?

Can ML be absorbed by the DBMS?

When we think of the various people and teams making use of ML and DBMS, we can place them on a spectrum based on the composition of their work.

Read post →
High-volume replication for Oracle is here

High-volume replication for Oracle is here

With the launch of our High Volume Agent connectors for Oracle databases, you'll see faster setup times and easier access to all your data sources.

Read post →
Why the modern retailer needs a modern data stack

Why the modern retailer needs a modern data stack

A modern data stack, built on Fivetran and Google BigQuery, is fundamental to gaining the data visibility retailers need to deliver seamless personalized omnichannel experiences.

Read post →
Fast tracking your tech career from BDR to AE

Fast tracking your tech career from BDR to AE

Finding a company like Fivetran that invests in employee development and rewards hard work has been key to growing my career.

Read post →
How to set up Fivetran through Snowflake Partner Connect

How to set up Fivetran through Snowflake Partner Connect

Step-by-step instructions for setting up Fivetran data pipelines through Snowflake Partner Connect.

Read post →
Why your modern data stack needs data governance

Why your modern data stack needs data governance

Having a governance strategy gives you data control and visibility.

Read post →
Get real-time updates on your data pipelines with Fivetran webhooks

Get real-time updates on your data pipelines with Fivetran webhooks

With Fivetran webhooks, developers can use real-time messages to power user experiences, transform data, drive error alerting and more.

Read post →
New research: The high cost of stale ERP data

New research: The high cost of stale ERP data

Global research reveals that 77% of enterprises lack real-time access to ERP data, leading to poor business outcomes and lost revenue.

Read post →
Change data capture: What it is and how to use it

Change data capture: What it is and how to use it

Change data capture helps you make faster and more accurate decisions with real-time data movement.

Read post →
Fireside chat with industry pioneers: Bob Muglia and Ali Ghodsi

Fireside chat with industry pioneers: Bob Muglia and Ali Ghodsi

Tech leaders debate why SQL is the lingua franca of data analysis, the unbundling and rebundling of software and emerging trends in data governance within the modern data stack space.

Read post →
The plight of CDOs: Beating the transformation deadline

The plight of CDOs: Beating the transformation deadline

Why turnover among chief data officers is so high and what can be done about it.

Read post →
Fivetran gives analysts a new way to transform data

Fivetran gives analysts a new way to transform data

With integrated scheduling and data lineage, Fivetran now enables data orchestration from a single platform with minimal configuration and code.

Read post →
Automated ELT: A force multiplier for one-person data teams

Automated ELT: A force multiplier for one-person data teams

To be effective, solo data analysts or engineers need to focus on refining algorithms and analyzing data, not building data pipelines.

Read post →
What is ETL?

What is ETL?

Data integration continues to evolve.

Read post →
I’m a woman in tech sales, and here’s why I love my job

I’m a woman in tech sales, and here’s why I love my job

A culture of diversity and professional growth, along with the support of strong female leaders, make Fivetran a great place to build your career.

Read post →
What is data replication and why is it important?

What is data replication and why is it important?

Your company needs data replication for analytics, better performance and disaster recovery.

Read post →
Switching to an annual plan can really pay off

Switching to an annual plan can really pay off

Don’t take our word for it – hear what our customers have to say.

Read post →
What is data governance?

What is data governance?

Use policies, processes, roles and technology to ensure data integrity, data quality and access control.

Read post →
The value of integrating varied HR systems

The value of integrating varied HR systems

Better HR analytics bring benefits to every business, but data integration must come first.

Read post →
CEO-ing with Google Apps Script

CEO-ing with Google Apps Script

I recently discovered Google Apps Script, and I've used it to solve a big problem I have as the CEO of a growing company: the avalanche of email assaulting my inbox.

Read post →
Three questions to ask in your SDR interview

Three questions to ask in your SDR interview

If you’re venturing into the tech sales space for the first time, make sure potential employers are positioned to offer you a great career.

Read post →
What wasting data engineering talent really costs you

What wasting data engineering talent really costs you

Data engineers spend almost half their time maintaining data pipelines. The total average cost? $520,000 per year, according to new research.

Read post →
What is ELT?

What is ELT?

Extract, load and transform, or ELT, is a data integration process that moves data directly from source to destination for analysts to transform as needed.

Read post →
Automatically sync formula field values from Salesforce

Automatically sync formula field values from Salesforce

Learn how to use Fivetran’s transformation package for dbt Core* to automatically generate views in your destination of fresh, reliable formula field values from Salesforce.

Read post →
Data governance builds business value

Data governance builds business value

Create value by moving from a compliance-driven to a value-driven mindset.

Read post →
Simplify SAP analytics using Google Cloud Cortex Framework and HVR

Simplify SAP analytics using Google Cloud Cortex Framework and HVR

Use enterprise solution HVR to tap into the power of Google Cloud Cortex Framework and turn SAP data into faster insights.

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 →
Connect to your customers’ data using a Connect Card link

Connect to your customers’ data using a Connect Card link

Securely onboard data from your customers in six quick steps, without ever touching their login credentials.

Read post →
The real way to get more women into tech

The real way to get more women into tech

For Women’s History Month, let’s make history by increasing female participation in our industry.

Read post →
Uncovering the future of the modern data stack

Uncovering the future of the modern data stack

A modern data stack frees people to focus on what they do best — no matter which team they work on.

Read post →
What is HR analytics and why do you need it?

What is HR analytics and why do you need it?

You can use people data to drive success in hiring, retention, total rewards and employee satisfaction.

Read post →
Why your customer success strategy needs a data strategy

Why your customer success strategy needs a data strategy

Three best practices will help you anticipate customer needs at every step of the journey and boost customer success.

Read post →
Reliable data replication in the face of schema drift

Reliable data replication in the face of schema drift

Use these techniques to ensure that data replication remains robust, even as schemas change.

Read post →
Cookies are out, conversions APIs are in

Cookies are out, conversions APIs are in

You can improve ROI on social media ads even as regulations and technologies change.

Read post →
Fivetran makes big strides in India

Fivetran makes big strides in India

With 100+ staff and dedicated in-country GCP and AWS data centers, Fivetran is growing rapidly in the country.

Read post →
How to build data platforms using the modern data stack

How to build data platforms using the modern data stack

Data consultancy Untitled Firm uses Powered by Fivetran to effortlessly connect to its customer data and create powerful analytics applications.

Read post →
A visual guide to transformations: The Salesforce data model

A visual guide to transformations: The Salesforce data model

Analysis-ready data models are built using sequences of transformations. Here's how we create our data model for Salesforce.

Read post →
Trends that will dominate analytics & BI in 2022

Trends that will dominate analytics & BI in 2022

Fully managed ELT, DataOps and other trends will change the way we use data this year.

Read post →
Can SQL be a library language?

Can SQL be a library language?

The time has come for the open-source software revolution to reach SQL.

Read post →
What is a data mart?

What is a data mart?

Data marts are miniature, specialized data warehouses.

Read post →
Fivetran now available in Microsoft Azure Marketplace

Fivetran now available in Microsoft Azure Marketplace

Microsoft customers can discover, transact and deploy Fivetran’s fully managed and automated data pipelines in Azure and more.

Read post →
Why Fivetran is a great place to work

Why Fivetran is a great place to work

Eleven awards, the launch of the Fivetran Parents ERG and more made 2021 a year to remember.

Read post →
What is a data lake?

What is a data lake?

Data lakes serve as central destinations for business data and offer users a platform to guide business decisions.

Read post →
What is data transformation?

What is data transformation?

Learn why data transformation is essential to data modeling and bringing your organization to the forefront of data literacy.

Read post →
New Fivetran pricing delivers greater accessibility to customers

New Fivetran pricing delivers greater accessibility to customers

Unlimited resyncs, moving from credits to dollars, new pricing plan, and more.

Read post →
Terraform and the modern data stack as code

Terraform and the modern data stack as code

Create and maintain dev, test and prod modern data stack deployments with Fivetran’s Terraform provider.

Read post →
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 →
How to gain faster insights from your Shopify and Klaviyo data

How to gain faster insights from your Shopify and Klaviyo data

Use our data models to easily combine Shopify and Klaviyo data into analytics-ready models and create rich, granular customer personas.

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 →
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.

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.