Automating Data Integration with Fivetran

Automating Data Integration with Fivetran will help you to centralize all of your data sources so you can quickly model your data and gain meaningful insights. With the help of hands-on examples, you'll be able to put your knowledge to work and get the highest possible return on your data infrastructure investments using Fivetran.

---

Explore the capabilities of Fivetran that allow data professionals to centralize data automatically and unlock useful insights

Key Features

Discover typical use cases for Fivetran and how it works
Use Fivetran's native functionalities such as transformations, history mode, dbt packages, and the native dbt integration
Find out how to use Fivetran for managing pipelines and where Fivetran fits in your analytics tech stack

Book DescriptionFivetran enables organizations to centralize key data sources to quickly model and obtain meaningful insights from data. As the first book written about Fivetran, Automating Data Integration with Fivetran, will take you through its capabilities that allow you to collect and analyze data any time and maximize ROI on your analytics initiatives. The book will demonstrate how a productionalized analytics infrastructure can be set up in less than 1 hour.

You'll start by exploring managed data pipelines and setting up Fivetran connectors and learn how to create scheduled transformations using dbt. As you advance, you'll configure Fivetran connectors and seamlessly load data into your data warehouse, manage sync frequencies, and troubleshoot disruptions in your data pipelines. You'll then discover how to build custom transformations and deploy pre-built transform packages through Fivetran's native integration with dbt. Throughout the book, you'll learn to create scalable data pipelines to generate insights from production data and automatically integrate data from different applications with the help of practical examples.

By the end of this book, you'll be able to set up, deploy, and land source data in your data warehouse, schedule and execute custom transformations, and have a fully operational data infrastructure to power your analytics.

What you will learn

Understand how data pipelines are managed and what goes on under the hood for Fivetran connectors
Install various Fivetran connectors and learn how to troubleshoot issues that may come up in the setup process
Create, manage, and schedule transformations from within the Fivetran application
Set up and manage history mode and dbt jobs in Fivetran
Keep your data safe while connecting, replicating, and loading data using Fivetran
Find out how Fivetran can be used by different teams
Cover best practices for data governance, data modeling, and transformations

Who This Book Is ForThis book is for analytics leaders and data engineers responsible for managing ETL/ELT data pipelines, extracting data from source systems and landing them in a data warehouse, and creating the data infrastructure needed to run analytics for their organization. Business leaders who want to become data-driven or enhance their data analytics skills will also find this book useful. Basic knowledge of data analysis is assumed.