More apps with Fivetran
Bring in Salesforce, HubSpot, Stripe, Google Ads and hundreds more through Fivetran, with a monthly allowance and table-by-table control.
For everything Orcabase doesn’t connect to itself, there’s Fivetran: hundreds of connectors for apps like Salesforce, HubSpot, Stripe and Google Ads, plus many more databases and file stores. Orcabase sets Fivetran up for you and keeps the synced data in a Postgres server it hosts, so it’s ready to query like everything else.
Before you start
- A hosted Postgres server connected as a data source. Fivetran writes into it.
- The Admin role in your organization.
- A login for the app you’re connecting. You sign in on Fivetran’s page, never in Orcabase.
You don’t need a Fivetran account: Orcabase uses its own.
Connect an app
Pick the app
Go to Sync data then Add source and search for the app. Fivetran’s connectors are marked via Fivetran.
Choose where it goes
Pick the Postgres data source to sync into and a Schema name for this app’s tables, like
stripe. The first time, Orcabase sets Fivetran up on that database: it creates a separate user that can only add new schemas, and can’t touch your existing ones.Sign in on Fivetran
Click Continue to Fivetran. Fivetran’s page asks you to sign in to the app, or for its API key. Your login goes to Fivetran directly; Orcabase never sees it.
Pick tables, then start
Back in Orcabase, choose which tables to sync and click Save and start syncing. Only the tables you pick are synced, and only they count toward your allowance.
If you leave Fivetran’s page before finishing, the source waits with the status Finish setup. Click it to pick up where you left off.
Your monthly allowance
Fivetran charges by monthly active rows: each distinct row added, changed or deleted in a calendar month counts once, however often it changes. The first full load of a source and any re-syncs are free. Your organization gets a monthly allowance of these rows, and a few other limits:
| Limit | Standard | What happens at the limit |
|---|---|---|
| Monthly active rows | 500,000 a month | Syncing pauses until the next month, or until the limit is raised |
| Sources | 5 | You can’t add another until you remove one |
| How often each source syncs | Every 6 hours at most | Faster options aren’t offered |
These are the standard limits; yours may differ with your plan. The Sync data page shows a bar with this month’s usage against the allowance, turning amber at 80%, and each source’s rows this month.
Usage updates every so often
Fivetran reports usage in batches, and Orcabase checks every 15 minutes, so a busy source can go a little over the allowance before it pauses. Syncing resumes by itself at the start of the next month (in UTC), or as soon as the limit is raised.
To use less of the allowance:
- Sync fewer tables. A table that isn’t synced costs nothing, so this matters most. Use Choose tables on any source.
- New tables that appear in the app later stay off until someone turns them on, while new columns in tables you already sync come through.
- Syncing less often helps less than you’d think: a row that changes 20 times in a month still counts once.
Manage a Fivetran source
- Sync now, Pause and Resume work as for built-in sources. Resuming and syncing now aren’t possible while the allowance is used up.
- Reconnect appears when Fivetran can no longer sign in to the app, for example after a password change. It reopens Fivetran’s sign-in page.
- Remove stops syncing and deletes the source from Fivetran. The tables already synced stay in your Postgres server.
Synced tables show up in their own schema, like stripe.charges, everywhere in Orcabase. Orcabase also adds a free Fivetran usage schema (fivetran_metadata) to the database, which it reads to count your rows.
Something unclear or missing? Troubleshooting covers the common errors, or message us.