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 ResourceBlendo Table NameDescription
Balance Historybalance_historyTable with Balance History
Balance History Feesbalance_history_feesTable with Balance History Fees
Balance Snapshotbalance_snapshotTable with Balance Snapshot
ChargeschargesTable with Stripe charges
CouponscouponsTable with Stripe Coupons
CustomerscustomersTable with Customers
CustomerscustomersTable with Customers
Customer Sourcescustomer_sourcesTable with Customer Sources
DisputesdisputesTable with Disputes
Disputes Feesdisputes_feesTable with Disputes Fees
CustomerscustomersTable with Customers
EventseventsTable with Events
File Uploadsfile_uploadsTable with File Uploads
Invoice Discountsinvoice_discountsTable with Invoice Discounts
Invoice Itemsinvoice_itemsTable with Invoice Items
Invoice Linesinvoice_linesTable with Invoice Lines
InvoicesinvoicesTable with Invoices
Order Itemsorder_itemsTable with Order Items
OrdersordersTable with Orders
PlansplansTable with Plans
ProductsproductsTable with Products
RefundsrefundsTable with Refunds
Return Order Itemsreturn_order_itemsTable with Return Order Items
ReturnsreturnsTable with Returns
SkusskusTable with SKUs
Subscription Discountssubscription_discountsTable with Subscription Discounts
Subscription Itemssubscription_itemsTable with Subscription Items
SubscriptionssubscriptionsTable with Subscriptions
TierstiersTable with Tiers
Transfer Reversalstransfer_reversalsTable with Transfer Reversals
TransferstransfersTable 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