Skip to content
Home » Blog » How to Pipe Iterable Data to a Data Warehouse Using Stitch

How to Pipe Iterable Data to a Data Warehouse Using Stitch

  • by

As you already know, Iterable is the expansion advertising and marketing platform that allows manufacturers to create, execute, and optimize campaigns to energy world-class buyer engagement throughout email, push, SMS, in-app and extra with unparalleled knowledge flexibility. Many Iterable customers additionally use different SaaS instruments for issues like analytics, billing, CRM, and help.

Since entrepreneurs are data-driven, likelihood is they’ll need to mix knowledge from all of their cloud platforms and inside databases to floor insights and enhance their efficiency—however how?

The finest tactic is to create a knowledge warehouse that consolidates your entire knowledge in a single location. Most companies these days use cloud knowledge warehouses for that function.

To populate the info warehouse, you’ll be able to extract the info you might have in SaaS functions and on-premises databases and cargo it utilizing an ETL (extract, rework, load) instrument. Once the info is offered, analysts can use it to create studies.

Iterable + Stitch diagram

In this put up, we’ll stroll by the method of connecting Iterable, a knowledge warehouse, and a enterprise intelligence (BI) instrument to create studies.

Three Tiers of the Data Analytics Architecture

Data sources like Iterable kind a basis for a knowledge analytics stack that includes three tiers: ETL software program, knowledge warehouse, and enterprise intelligence (BI) software program.

Stitch supplies a simple, powerful ETL service for companies of all sizes. Signup is straightforward—you may be shifting knowledge from a number of sources to a knowledge warehouse in 5 minutes.

The previous few years have seen the emergence of cloud-native knowledge warehouses like Amazon Redshift, Google BigQuery, and Snowflake. Because they run on cloud infrastructure that scales shortly and cost-effectively to meet efficiency calls for, they will deal with transformation utilizing the identical {hardware} on which the info warehouse runs.

Finally, to unlock the worth of your knowledge, you’ll be able to join a BI or knowledge visualization instrument to your knowledge warehouse and create studies that analyze knowledge from a number of sources, which you’ll share by way of browser-based dashboards.

Setting Up a Data Warehouse

Let’s arrange a three-tiered knowledge analytics stack, beginning with the info warehouse. If you don’t have already got a knowledge warehouse, choose one that meets your needs.

If you select Redshift, BigQuery, Snowflake, or one of many different locations Stitch helps, it’s also possible to follow the setup steps for your data warehouse within the Stitch documentation.

Setting Up Stitch for ETL

The subsequent step is establishing an ETL pipeline to transfer knowledge out of your sources to the info warehouse. Stitch makes extracting knowledge from a supply and loading it into a knowledge warehouse simple.

To get began, visit the signup page, enter your email handle, then enter your identify and a password.

Signup for a Stitch account

Add an integration

Next, add Iterable as an integration inside Stitch. Click on the Iterable icon to get began:

Add Iterable as an integration within Stitch

Enter a identify for the mixing. This is the identify that may show on the Stitch Dashboard for the mixing; it’ll even be used to create the schema in your vacation spot.

Configure your Iterable + Stitch integration

When you click on Save, Stitch will generate a webhook token URL.

Stitch webhook token

Click the Copy button to copy it, then swap again to your Iterable account. Click Integrations > Webhooks. In the Endpoint subject, paste the webhook URL, then click on Create Webhook.

After the webhook is saved, click on the Edit button to the far proper to choose the occasions you need to monitor.

Your adjustments can be saved routinely, and all future occasions of the kinds you’ve chosen can be replicated to your knowledge warehouse—however first, you might have to join the info warehouse you arrange to Stitch as a vacation spot.

Add a vacation spot

Select a destination for your data

Suppose you’ve chosen an Amazon Redshift knowledge warehouse.

Clicking on the Redshift icon brings you to a display the place you’ll be able to enter your credentials.

Connect to Amazon Redshift

Now all of the items are in place, and the info is prepared to stream.

Success! Your data pipeline has been created

When you go to your Stitch dashboard, you’ll see that your integration is marked, “Active, Continuously Replicated.”

From the dashboard, it’s also possible to do issues like including integrations from different knowledge sources. The Stitch documentation walks through the process for each one.  

Connect BI software program to your knowledge warehouse

The ultimate stage of the method is connecting an analytics platform to your knowledge warehouse.

If you don’t already use BI software program, you might have dozens to choose from, together with such well-liked choices as Looker, Tableau, Microsoft Power BI, and Google Data Studio.

You’re Set With Stitch

That’s all there’s to it. Using an ETL instrument like Stitch to transfer knowledge from Iterable and different sources into a knowledge warehouse enables you to leverage the facility of BI instruments to correlate and report on your entire worthwhile knowledge.

To be taught extra about Iterable’s development advertising and marketing platform, take a product tour.

Leave a Reply

Your email address will not be published. Required fields are marked *