Line item level detail
Invoice line items and subscription items, not just parent records.
Stripe
Polytomic connects Stripe to your data warehouse, databases, and SaaS tools for billing ETL and reverse ETL. Replicate customers, invoices, subscriptions, and balance transactions into your data warehouse and other systems, and write customer and invoice data back, without writing code.
Change capture via events
Incremental runs poll Stripe's events API, catching deletes too.
Match on metadata
Write to customers matched on a Stripe metadata key such as a CRM ID.
Example workflows
Replicate Stripe billing data into your data warehouse
What you can sync
Move data between Stripe and your data warehouse, databases, and SaaS tools, reading billing data out and writing customer and invoice data back in.
From Stripe
Customers, payment methods, and balance transactions
Invoices, invoice line items, invoice items, and credit notes
Subscriptions, subscription items, and schedules
Charges, payment intents, refunds, disputes, and payouts
Products, prices, plans, coupons, tax rates, and billing meters
To Stripe
Customers, with create, update, and create or update
Invoices, with a mapped customer required
Subscriptions, update only
Custom fields written as Stripe metadata
How it works
Connect Stripe and sync in both directions. Pull the full billing model into your data warehouse, from customers and subscriptions down to invoice line items and balance transactions, and write customer and invoice data back.
After the first load, incremental runs poll Stripe's events API rather than rescanning lists. That is what allows deletes to be captured, since Stripe emits deletion events for customers, invoices, products, prices, and similar objects.
- Connect Stripe with a secret API key
- Read customers, subscriptions, invoices, and their line items
- Read charges, payment intents, refunds, disputes, and payouts
- Read products, prices, plans, coupons, and billing meters
- Incremental runs poll the events API and capture deletes
- Write customers and invoices, matched on ID, email, or metadata
How to set up
Authentication is a secret API key. The connection health check reads your balance, so the key needs that permission plus access to every object you intend to sync. Only key based authentication is supported, with no OAuth flow.
How to get connected
- 1In Stripe, create a secret API key with access to the objects you need
- 2In Polytomic, navigate to Connections, then Add Connection, then Stripe
- 3Paste the key and test the connection
- 4For reads, select the objects you want and choose a destination
- 5For writes, build a model and map to customers or invoices
- 6Choose your identity field, set a schedule, and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Stripe in minutes
No credit card required. Free trial available.