How to Setup Stripe Integration

This integration will allow you to connect with Stripe and start collecting your data. It is a matter of minutes to send your billing and payments data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Stripe
  2. Set the Replication Frequency
  3. Load your Stripe data into your data warehouse
  4. Stripe expected Data Model and schema

Getting Started – Setup Stripe integration at Blendo

1. To add this integration, go to Blendo dashboard. Click “Add a Source”

Setup Stripe integration

2. In the new “Setup your Stripe source” screen click on Connect with Stripe.

Setup Stripe integration

3. If you’re not already logged into your Stripe account, you will be prompted to connect to your Stripe credentials.

Setup Stripe integration

4. Click Sign in with Stripe to connect.

5. In the next page you may add your Stripe credentials to sign in and click Sign in to your account.

Setup Stripe integration

6. At the next page see if everything is OK and click Validate & Save.

Setup Stripe integration

7. Then you will return back to the home dashboard. Click on your new Stripe data source.

Setup Stripe integration

Set the Replication Frequency

8. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

AfterShip integration

9. In the next pop-up select one of the options available and click Apply.
AfterShip integration

Load your Stripe data into your data warehouse

Blendo will start automatically to pull your data from Stripe.

If you want to start the import process on your own just click Import now.

Load your STripe data into a data warehouse

Stripe Data Model & Schema Information

Blendo will now connect to your Stripe data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs Stripe data
  2. The tables with Stripe data that we create in your destination data warehouse

How Blendo syncs Stripe data

Historical Data

When Blendo first connects to Stripe Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Stripe data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Stripe data performs a full replication. Then your Stripe data is replicated incrementally. Note that Blendo will only read your data.

After you finish the integration with Stripe, you might see its status as Importing from sourceExporting to the destination, or Completed.

What Stripe data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

Stripe Resource Blendo Table Name Description
Balance History balance_history Table with Balance History
Balance History Fees balance_history_fees Table with Balance History Fees
Balance Snapshot balance_snapshot Table with Balance Snapshot
Charges charges Table with Stripe charges
Coupons coupons Table with Stripe Coupons
Customers customers Table with Customers
Customers customers Table with Customers
Customer Sources customer_sources Table with Customer Sources
Disputes disputes Table with Disputes
Disputes Fees disputes_fees Table with Disputes Fees
Customers customers Table with Customers
Events events Table with Events
File Uploads file_uploads Table with File Uploads
Invoice Discounts invoice_discounts Table with Invoice Discounts
Invoice Items invoice_items Table with Invoice Items
Invoice Lines invoice_lines Table with Invoice Lines
Invoices invoices Table with Invoices
Order Items order_items Table with Order Items
Orders orders Table with Orders
Plans plans Table with Plans
Products products Table with Products
Refunds refunds Table with Refunds
Return Order Items return_order_items Table with Return Order Items
Returns returns Table with Returns
Skus skus Table with SKUs
Subscription Discounts subscription_discounts Table with Subscription Discounts
Subscription Items subscription_items Table with Subscription Items
Subscriptions subscriptions Table with Subscriptions
Tiers tiers Table with Tiers
Transfer Reversals transfer_reversals Table with Transfer Reversals
Transfers transfers Table with Transfers

Custom Fields

Blendo will create a column for any of your custom fields and will sync it accordingly.

Expected Stripe Data Model & Schema Information >>

Questions? Contact us!

in Connecting SaaS Data Sources