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:
- Connecting Stripe
- Set the Replication Frequency
- Load your Stripe data into your data warehouse
- 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”
2. In the new “Setup your Stripe source” screen click on Connect with Stripe.
3. If you’re not already logged into your Stripe account, you will be prompted to connect to your Stripe credentials.
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.
6. At the next page see if everything is OK and click Validate & Save.
7. Then you will return back to the home dashboard. Click on your new Stripe data source.
Set the Replication Frequency
8. If you want to change the replication schedule go to the Schedule section and click on Reschedule.
9. In the next pop-up select one of the options available and click Apply.
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.
Stripe Data Model & Schema Information
| 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.
