Connectors

/

Stripe

Data replication

Sync Stripe data anywhere.

Stripe is a technology company focused on helping businesses of all sizes accept web and mobile payments. Stripe software is intended to build a solid economic infrastructure for the internet at global scale. Well-known companies like Salesforce and Facebook accept online payments through Stripe software. Stripe’s innovative applications combined with their solid economic infrastructure support modern business models like crowdfunding and marketplaces. Stripe continues to innovate, partnering with tech-dominant enterprises such as Apple, Google, and Facebook to launch new capabilities.

  • Certified
  • Generally available
  • 47 streams
  • 18 entities
  • Read & write
Stripe

Everything Stripe can do in Airbyte

  • Sync to your warehouse

    Land 47 Stripe tables in 50+ destinations on a schedule you control.

  • Live entity actions

    Read, create, update and delete Stripe records at runtime through typed entity actions.

  • Context store search

    Query synced Stripe data with filters, sorting and semantic search, without spending Stripe API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

What to know before you sync Stripe

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version6.0.15
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 10 steps

  1. First, you need to create a Stripe account and log in to your dashboard.
  2. Navigate to the Developers section and click on API keys.
  3. Copy the Secret Key and Publishable Key.
  4. Go to Airbyte and click on Sources in the left-hand menu.
  5. Click on the Stripe source connector and then click on Create New Connection.
  6. Enter a name for your connection and paste the Secret Key and Publishable Key in the respective fields.
  7. Click on Test Connection to ensure that the credentials are correct.
  8. If the test is successful, click on Save to save the connection.
  9. You can now configure the sync settings for your Stripe source connector, such as selecting the data you want to sync and setting up a schedule for the sync to run automatically.
  10. Once you have configured the sync settings, click on Save and Run to start syncing your Stripe data with Airbyte.

Every table you can sync from Stripe

  • Accounts

  • Application Fees

  • Application Fee Refunds

  • Authorizations

  • Balance Transactions

  • Bank accounts

  • Cardholders

  • Cards

  • Charges

  • Checkout Sessions

  • Checkout Sessions Line Items

  • Coupons

  • Credit Notes

  • Customer Balance Transactions

  • Customers

  • Disputes

  • Early Fraud Warnings

  • Events

  • External Account Bank Accounts

  • External Account Cards

  • File Links

  • Files

  • Invoice Items

  • Invoice Line Items

  • Invoices

  • Payment Intents

  • Payment Methods

  • Payouts

  • Payout Balance Transactions

  • Promotion Codes

  • Persons

  • Plans

  • Prices

  • Products

  • Refunds

  • Reviews

  • Setup Attempts

  • Setup Intents

  • Shipping Rates

  • Subscription Items

  • Subscription Schedule

  • Subscriptions

  • Top Ups

  • Transactions

  • Transfers

  • Transfer Reversals

  • Usage Records

Supported Stripe actions

  • List

    Read live records straight from the Stripe API.

  • Create

    Write a new record back into Stripe.

  • Get

    Fetch a single record by ID.

  • Update

    Patch fields on an existing record.

  • Delete

    Remove a record.

  • API Search

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

Full parameter-level details live in the Stripe entity reference.

Authenticate Stripe once

  • Secret Key

    Stripe API key (usually starts with 'sk_live_'; find yours here).

What teams build with Stripe

List customers created in the last 7 days

Show me details for a recent customer

List recent charges

Show me details for a recent charge

List recent invoices

List active subscriptions

Create a payment intent for $50.00 USD

Create a new invoice for customer cus_123

Create a subscription for customer cus_123 with price price_456

Create a price of $29.99/month for product prod_789

Create a checkout session for price price_456

Cancel payment intent pi_123

Finalize invoice inv_123

Show me my top 10 customers by total revenue this month

List all customers who have spent over $5,000 in the last quarter

Analyze payment trends for my Stripe customers

Identify which customers have the most consistent subscription payments

Give me insights into my customer retention rates

Summarize the payment history for customer

Compare customer spending patterns from last month to this month

Show me details about my highest-value Stripe customers

What are the key financial insights from my customer base?

Break down my customers by their average transaction value

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

No. One Stripe authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

No. Entity actions read and write through the Stripe API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Stripe's API provides access to a wide range of data related to payment processing and management. The following are the categories of data that can be accessed through Stripe's API:

1. Payment data: This includes information about payments made through Stripe, such as the amount, currency, and status of the payment.

2. Customer data: This includes information about customers who have made payments through Stripe, such as their name, email address, and payment history.

3. Subscription data: This includes information about subscriptions made through Stripe, such as the subscription plan, billing cycle, and status of the subscription.

4. Dispute data: This includes information about disputes raised by customers, such as the reason for the dispute and the status of the dispute resolution process.

5. Balance data: This includes information about the balance of the Stripe account, such as the available balance, pending balance, and currency.

6. Transfer data: This includes information about transfers made from the Stripe account to a bank account, such as the amount, currency, and status of the transfer.

7. Refund data: This includes information about refunds made through Stripe, such as the amount, currency, and status of the refund.

Overall, Stripe's API provides access to a comprehensive set of data related to payment processing and management, enabling businesses to effectively manage their payment operations.

1. First, you need to create a Stripe account and log in to your dashboard.

2. Navigate to the Developers section and click on API keys.

3. Copy the Secret Key and Publishable Key.

4. Go to Airbyte and click on Sources in the left-hand menu.

5. Click on the Stripe source connector and then click on Create New Connection.

6. Enter a name for your connection and paste the Secret Key and Publishable Key in the respective fields.

7. Click on Test Connection to ensure that the credentials are correct.

8. If the test is successful, click on Save to save the connection.

9. You can now configure the sync settings for your Stripe source connector, such as selecting the data you want to sync and setting up a schedule for the sync to run automatically.

10. Once you have configured the sync settings, click on Save and Run to start syncing your Stripe data with Airbyte.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Stripe data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Stripe actions.