Connectors

/

Stripe

Stripe

Finance & Ops Analytics

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
Sync Stripe dataRead the docs
  • 47Streams
  • 18Entities
  • 7Actions
  • 50+Destinations
One connector

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.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version6.0.15

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.
47 streams

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

7 actions

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.

Authentication

Authenticate Stripe once

  • Secret Key

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

Use cases

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

Explore
All connectors
FAQ

Common questions

Do I need more than one Stripe connection?

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

Do Stripe entity actions need a sync to run first?

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.

What is ETL?

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.

What data can you extract from Stripe?

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.

How do I transfer data from Stripe?

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.

What are top ETL tools to transfer data from Stripe?

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.

What is ELT?

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.

Difference between ETL and ELT?

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.

Try it freeTalk to sales