Topics: 5 min readtime

Why Fivetran and not another tool?

Written by Bram Van Hooydonck
Wednesday 7 April, 2021

Fivetran is the smartest way to load data into a warehouse. It offers seamless connectivity to applications, databases, files and events. They provide you (and your team) more time for analyzing your data, instead of connecting your data. 

What's in it for me?



Prebuilt connectors?

MARKETING CRM E-commerce Database
Mailchimp Salesforce WooCommerce (Wordpress) SQL Server
Facebook Ads Zendesk Magento Amazon
LinkedIn Ads Hubspot Shopify Oracle
... ... ... ...



Is it really that simple?

I'll be honest, before this blog post I had no experience with Fivetran.
Within 1 hour all my dummy Salesforce data, Mailchimp data and WooCommerce data were transferred into Snowflake without writing a single line of code.


Do it yourself!

1. Free trial

Sign up for your enterprise platform trial:

  • 14 days

  • Free, no payment details are requested

2. Data warehouse

no destination

What if you don't have a data warehouse or data environment? Fivetran provides you with a free BigQuery warehouse. The Fivetran-managed destination is a BigQuery data warehouse. The warehouse is free to use for your account trial period of 14 days. When your free trial has ended, Fivetran's sales team will contact you to see if you want to continue using the warehouse. If you do, Fivetran makes you the billing owner.

If wanted you can also create a free Snowflake Trial , or you can simply use your own data warehouse if you have one.

 

3. DATA

Ok, we covered our Fivetran account and we have an environment to store our data. 
What if you don't have access to your business environment, or you aren't admin of the existing accounts. You can generate some free dummy data via:

4. Select your Connector

With each connector, Fivetran will provide you guided step-by-step instructions on how to configure the connector. This may require you to visit other apps and websites belonging to your source system.

5. Start initial sync

This action will start the entire process. Each connector has his own status page where you can manage the settings, an overview of the sync history, alerts, user actions and stats.

6. Take a look in your data warehouse

Now your data should be available in your data warehouse.
You can always look at their documentation for more information or check their YouTube channel.


Did you know

If you already have a Snowflake environment, the Partner Connect allows you to set up Fivetran through Snowflake Partner Connect.

Let's get in touch, we'll gladly show you how Fivetran will save you time and resources, make your data engineer's life easier and finally provide a stable and scalable solution to data pipelining.

You can always start a free trial, just get in touch with us and we'll hook you up!

Let's Talk!