Quickstart Guide

Now that we saw what is Blendo let’s see how to get started with it!

Table of Contents

What will you need?

You need a few minutes to start working with Blendo. Here is what you will need to start with a simple pipeline.

Blendo will load, sync your Input Source data and keep it updated into your favorite data warehouse as Destination. You will always have your data fresh and available to you.

Step 1: Sign In

Create an account with Blendo (it is free for the first 14-days, no credit card required). Sign into your Blendo account.

Step 2: Connect your Data warehouse or Database (Destination)

Blendo needs to save your data somewhere. This is where you need to provide a data warehouse or a database.

Note: Blendo is not a data warehouse provider. Please let us know if you need help to choose one. We would be happy to give you tips.

Blendo currently supports output to the following data warehouses (Destinations):

Connect to a data warehouse

Step 3: Sync your data

Let’s connect a sample data source to our data warehouse.

1. Click on Add Source.

Add a data source

2. Click Add on the data source you want. For our example this will be MailChimp.

ETL Mailchimp data

2. Follow the instructions to connect with MailChimp.

ETL Mailchimp data

2. Click on Validate & Save.

ETL Mailchimp data

3. The first time click on Import. Then Blendo will do everything for you. We will pull data from MailChimp and start loading into your data warehouse.

ETL Mailchimp data

 

Step 4: Access your data

In a few minutes you should be ready to access your raw MailChimp data into your data warehouse. You may use SQL or any other visualization tool that you are comfortable with.

Lets see an example with Google BigQuery as a data warehouse. Google Console provides a great preview of your data. This is what you will see.

ETL to Google BigQuery

 

What’s Next?

The above process will take around 3 minutes to complete if you have all your credentials with you. This is how you can setup a full data pipeline infrastructure without worrying on the time and the resources you need.

Next Steps:

In the next section we will see our Data sources Integrations.

READ NEXT: Input Data Source (Integrations)

Questions? Contact us!

in Getting Started