- Source
- Finance & Ops Analytics
- Alpha
Move Ramp data anywhere it matters.
Replicate Ramp cards, transactions and reimbursements to the warehouse or AI app you use.
Source
Ramp
Snowflake
BigQuery
Postgres
Databricks
Claude
- Streams
- 18
- Destinations
- 50+
- Standard support
- 1.1.1
Overview
What is the Airbyte Ramp connector?
The Airbyte Ramp connector extracts data from Ramp and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 18 streams you can select per connection.
- 01
Sync to your warehouse
Land 18 Ramp tables in 50+ destinations on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
One authorization
Authenticate Ramp once and Airbyte keeps every scheduled sync running on it.
- 04
Cloud or self-hosted
Run the Ramp connector on Cloud, OSS, Hybrid.
18 streams
Every table you can sync from Ramp
cards Primary key id Sync modes FullIncr. transactions Primary key id Sync modes FullIncr. reimbursements Primary key id Sync modes FullIncr. users Primary key id Sync modes FullIncr. departments Primary key id Sync modes FullIncr. locations Primary key id Sync modes FullIncr.
Setup
Live in seven steps
Log into your Airbyte Cloud account or open your self-managed Airbyte instance.
Click Sources and then click + New source.
On the Set up the source page, select Ramp from the Source type dropdown.
Enter a name for the Ramp connector.
Enter the Ramp Client ID and Ramp Client Secret from your developer app.
Optionally, set Start Date. See Start Date.
Click Set up source.
Configuration fields
| Field | Type | Description |
|---|---|---|
| client_id* | string | Client ID of the Ramp developer app (Ramp > Company > Developer). The app needs the Client Credentials grant and the scopes transactions:read, cards:read and reimbursements:read. Every other stream needs its own read scope, such as users:read or bills:read, granted only if you sync it. |
| client_secret* | string | Your Ramp API client secret. |
| api_url | string | Ramp API base URL. All production Ramp accounts use the default. Set to https://demo-api.ramp.com only when testing against a Ramp sandbox app. |
| start_date | string | Only transactions and reimbursements changed on or after this date, and receipts created on or after it, are synced on the first sync. Use UTC, for example 2024-01-01T00:00:00Z. |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
Related connectors
FAQ
Ramp connector questions
What data can I sync from Ramp with Airbyte?
18 streams, including cards, transactions, reimbursements, users, departments, locations, entities, business and more.
Does the Ramp connector support incremental sync?
Yes. The Ramp connector supports incremental sync on selected streams, and full refresh on every stream.
Where can I run the Ramp connector?
Run the Ramp connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start syncing Ramp in minutes.
Free 14-day trial. No credit card needed.