Automating Data Integration with Fivetran: Implement managed pipelines from source to destination and enable scalable analytics for your whole team

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

Key FeaturesDiscover typical use cases for Fivetran and how it worksUse Fivetran's native functionalities such as transformations, history mode, dbt packages, and the native dbt integrationFind out how to use Fivetran for managing pipelines and where Fivetran fits in your analytics tech stackBook 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 learnUnderstand how data pipelines are managed and what goes on under the hood for Fivetran connectorsInstall various Fivetran connectors and learn how to troubleshoot issues that may come up in the setup processCreate, manage, and schedule transformations from within the Fivetran applicationSet up and manage history mode and dbt jobs in FivetranKeep your data safe while connecting, replicating, and loading data using FivetranFind out how Fivetran can be used by different teamsCover best practices for data governance, data modeling, and transformationsWho 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.