Build integrations using select, insert,

update, delete

insert into
salesforce.contact (first_name, last_name, email)
values (
'Andrea'
,
'Palladio'
,
'andrea@palladiodesigns.com'
)
returning id;
(
1
row
)
=> ['0038b00002iOFd9AAG']

Salesforce

New Contact ‘Andrea Palladio’ created just now

Build integrations using select, insert, update, delete

insert into
salesforce.contact (first_name, last_name, email)
values (
'Andrea'
,
'Palladio'
,
'andrea@palladiodesigns.com'
)
returning id;
(
1
row
)
=> ['0038b00002iOFd9AAG']

Salesforce

New Contact ‘Andrea Palladio’ created just now

Build integrations using select, insert, update, delete

insert into
salesforce.contact (first_name, last_name, email)
values (
'Andrea'
,
'Palladio'
,
'andrea@palladiodesigns.com'
)
returning id;
(
1
row
)
=> ['0038b00002iOFd9AAG']

Salesforce

New Contact ‘Andrea Palladio’ created just now

Watch Sequin in action

Demo (2 min)

Watch us work with our API

without touching http

Search collections

Sort by:

Date modified

Status

Collection

Destination

Latest Activity

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

All Syncs

Project Tracker

Sales CRM

Airtable

Sequin hosted

salesforce.com/aoinsdoin112

Status

Healthy

Destination

RDS Production

Database:

‘db1898sdf91’

Schema:

‘public’

Activity

Created Feb 21, 2019

Sync edited Mar 15, 2022

Latest activity Mar 29, 2022

Collections

Backfills

Mapping

Settings

Connection instructions

Syncs

Users

Databases

Docs

Faster (0:31-1:05)

Get a real-time, bidirectional sync between APIs and your database in a few clicks

Simpler (1:06-1:28)

Skip query params, rate limits, and pagination. Build using all the power of SQL instead

Easier (1:29-2:16)

Rapidly solve new problems and deploy new features instead of debugging an API

Watch Sequin in action

Demo (2 min)

Watch us work with our API

without touching http

Search collections

Sort by:

Date modified

Status

Collection

Destination

Latest Activity

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

All Syncs

Project Tracker

Sales CRM

Airtable

Sequin hosted

salesforce.com/aoinsdoin112

Status

Healthy

Destination

RDS Production

Database:

‘db1898sdf91’

Schema:

‘public’

Activity

Created Feb 21, 2019

Sync edited Mar 15, 2022

Latest activity Mar 29, 2022

Collections

Backfills

Mapping

Settings

Connection instructions

Syncs

Users

Databases

Docs

Faster (0:31-1:05)

Get a real-time, bidirectional sync between APIs and your database in a few clicks

Simpler (1:06-1:28)

Skip query params, rate limits, and pagination. Build using all the power of SQL instead

Easier (1:29-2:16)

Rapidly solve new problems and deploy new features instead of debugging an API

Watch Sequin in action

Demo (2 min)

Watch us work with our API

without touching http

Search collections

Sort by:

Date modified

Status

Collection

Destination

Latest Activity

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

All Syncs

Project Tracker

Sales CRM

Airtable

Sequin hosted

salesforce.com/aoinsdoin112

Status

Healthy

Destination

RDS Production

Database:

‘db1898sdf91’

Schema:

‘public’

Activity

Created Feb 21, 2019

Sync edited Mar 15, 2022

Latest activity Mar 29, 2022

Collections

Backfills

Mapping

Settings

Connection instructions

Syncs

Users

Databases

Docs

Faster (0:31-1:05)

Get a real-time, bidirectional sync between APIs and your database in a few clicks

Simpler (1:06-1:28)

Skip query params, rate limits, and pagination. Build using all the power of SQL instead

Easier (1:29-2:16)

Rapidly solve new problems and deploy new features instead of debugging an API

Trusted by engineering teams

Trusted by engineering teams

Trusted by engineering teams

Bob Lauer

Principal Engineer, Bloomtech

Sequin gave us the interface we always tried to build ourselves - a database. I only wish we found Sequin sooner. We waisted time on every developer tool offered by Salesforce: APEX triggers. SOQL. Salesforce events. The streaming API…but we always hit errors and limitations.

Just SQL.

Build using the database, query language, and tools you already know

Reads

Skip the API docs and query params. Just SELECT and JOIN data using SQL. Queries return 100X faster than the API and can be optimized with indexes.

Learn more about reads

select sum(total_price), product_id from airtable.order

where status = ‘pending_fulfillment’

group by product_id;

(7 rows)

=> [[857281, ‘prod_8sju’, ... ]]

Writes

INSERT, UPDATE, and DELETE work just as you’d expect. Mutations are validated with the data source at execution, guaranteeing consistency.

Learn more about writes

update salesforce.subscription_usage

set quantity = quantity + $1

where account_id = $2

returning quantity;

(1 row)

=> [34758]

Salesforce

Subscription usage updated

Errors

Errors return in a standard Postgres format so you can handle them in-line. No more digging through outdated forums to decipher cryptic responses.

Learn more about errors

insert into hubspot.company (name, industry)

values ('Palladio Designs', 'Scriptorium');

ERROR: [hubspot]: Property values were not valid: Industry `Scriptorium` is invalid.

Hubspot

Validation error — `industry` is invalid

Postgres

CREATE views, generated columns, and triggers. ADD pg extensions, and write functions to build your app.

create view salesforce.order_summary as

select order.id, order.account_id, order.status,

contact.email as contact_email

from salesforce.order order

inner join salesforce.company company

on order.account_id = company.id

inner join salesforce.contact contact

on company.primary_contact_id = contact.id;

Just SQL.

Build using the database, query language, and tools you already know

Reads

Skip the API docs and query params. Just SELECT and JOIN data using SQL. Queries return 100X faster than the API and can be optimized with indexes.

Learn more about reads

select sum(total_price), product_id from airtable.order

where status = ‘pending_fulfillment’

group by product_id;

(7 rows)

=> [[857281, ‘prod_8sju’, ... ]]

Writes

INSERT, UPDATE, and DELETE work just as you’d expect. Mutations are validated with the data source at execution, guaranteeing consistency.

Learn more about writes

update salesforce.subscription_usage

set quantity = quantity + $1

where account_id = $2

returning quantity;

(1 row)

=> [34758]

Salesforce

Subscription usage updated

Errors

Errors return in a standard Postgres format so you can handle them in-line. No more digging through outdated forums to decipher cryptic responses.

Learn more about errors

insert into hubspot.company (name, industry)

values ('Palladio Designs', 'Scriptorium');

ERROR: [hubspot]: Property values were not valid: Industry `Scriptorium` is invalid.

Hubspot

Validation error — `industry` is invalid

Postgres

CREATE views, generated columns, and triggers. ADD pg extensions, and write functions to build your app.

create view salesforce.order_summary as

select order.id, order.account_id, order.status,

contact.email as contact_email

from salesforce.order order

inner join salesforce.company company

on order.account_id = company.id

inner join salesforce.contact contact

on company.primary_contact_id = contact.id;

Just SQL.

Build using the database, query language, and tools you already know

Reads

Skip the API docs and query params. Just SELECT and JOIN data using SQL. Queries return 100X faster than the API and can be optimized with indexes.

Learn more about reads

select sum(total_price), product_id from airtable.order

where status = ‘pending_fulfillment’

group by product_id;

(7 rows)

=> [[857281, ‘prod_8sju’, ... ]]

Writes

INSERT, UPDATE, and DELETE work just as you’d expect. Mutations are validated with the data source at execution, guaranteeing consistency.

Learn more about writes

update salesforce.subscription_usage

set quantity = quantity + $1

where account_id = $2

returning quantity;

(1 row)

=> [34758]

Salesforce

Subscription usage updated

Errors

Errors return in a standard Postgres format so you can handle them in-line. No more digging through outdated forums to decipher cryptic responses.

Learn more about errors

insert into hubspot.company (name, industry)

values ('Palladio Designs', 'Scriptorium');

ERROR: [hubspot]: Property values were not valid: Industry `Scriptorium` is invalid.

Hubspot

Validation error — `industry` is invalid

Postgres

CREATE views, generated columns, and triggers. ADD pg extensions, and write functions to build your app.

create view salesforce.order_summary as

select order.id, order.account_id, order.status,

contact.email as contact_email

from salesforce.order order

inner join salesforce.company company

on order.account_id = company.id

inner join salesforce.contact contact

on company.primary_contact_id = contact.id;

Build with the tools you love

Integrate in minutes, not days

Whether you are scoping a fresh integration or in the trenches of 429s and missing data, it’s easy to set up or migrate to Sequin.

Map

Choose the collections you need for your integration. We even support the pesky ephemeral endpoints and calculated fields.

Contacts

SYNCING

Field

Database column

First name

first_name

Last name

last_name

E-mail

email

Subscription ID

subscription_id

Subscription Status

subscription_status

Sync

Sequin will backfill all of your historical data from the data source, then spin up workers to sync changes in real time.

Syncing

Contacts

Backfiling 0k of 10k rows...

Leads

Last record updated <5s ago

Accounts

Backfiling 0k of 4k rows...

Sales

Backfiling 0k of 4k rows...

Build

Build using SQL or your favorite ORM. Ship your app, internal tool, script, or feature today.

(irb:001)> Salesforce::Contact.create(first_name: 'Andrea',

last_name: 'Palladio', email: 'andrea@palladiodesigns.com')

=> #<Salesforce::Contact id: “'0038b00002iOFd9AAG”,

firstname: "Andrea", lastname: "Palladio",

lastname: "Palladio", email: "andrea@palladiodesigns.com",

accout_owner__c: “01I5i000002W4Y7”,

trial_started_at__c: “2023-06-16 12:34:56”,

created_at: “2023-06-16 12:34:56”,

updated_at: “2023-06-16 12:34:56”,

Integrate in minutes, not days

Whether you are scoping a fresh integration or in the trenches of 429s and missing data, it’s easy to set up or migrate to Sequin.

Map

Choose the collections you need for your integration. We even support the pesky ephemeral endpoints and calculated fields.

Contacts

SYNCING

Field

Database column

First name

first_name

Last name

last_name

E-mail

email

Subscription ID

subscription_id

Subscription Status

subscription_status

Sync

Sequin will backfill all of your historical data from the data source, then spin up workers to sync changes in real time.

Syncing

Contacts

Backfiling 0k of 10k rows...

Leads

Last record updated <5s ago

Accounts

Backfiling 0k of 4k rows...

Sales

Backfiling 0k of 4k rows...

Build

Build using SQL or your favorite ORM. Ship your app, internal tool, script, or feature today.

(irb:001)> Salesforce::Contact.create(first_name: 'Andrea',

last_name: 'Palladio', email: 'andrea@palladiodesigns.com')

=> #<Salesforce::Contact id: “'0038b00002iOFd9AAG”,

firstname: "Andrea", lastname: "Palladio",

lastname: "Palladio", email: "andrea@palladiodesigns.com",

accout_owner__c: “01I5i000002W4Y7”,

trial_started_at__c: “2023-06-16 12:34:56”,

created_at: “2023-06-16 12:34:56”,

updated_at: “2023-06-16 12:34:56”,

Integrate in minutes, not days

Whether you are scoping a fresh integration or in the trenches of 429s and missing data, it’s easy to set up or migrate to Sequin.

Map

Choose the collections you need for your integration. We even support the pesky ephemeral endpoints and calculated fields.

Contacts

SYNCING

Field

Database column

First name

first_name

Last name

last_name

E-mail

email

Subscription ID

subscription_id

Subscription Status

subscription_status

Sync

Sequin will backfill all of your historical data from the data source, then spin up workers to sync changes in real time.

Syncing

Contacts

Backfiling 0k of 10k rows...

Leads

Last record updated <5s ago

Accounts

Backfiling 0k of 4k rows...

Sales

Backfiling 0k of 4k rows...

Build

Build using SQL or your favorite ORM. Ship your app, internal tool, script, or feature today.

(irb:001)> Salesforce::Contact.create(first_name: 'Andrea',

last_name: 'Palladio', email: 'andrea@palladiodesigns.com')

=> #<Salesforce::Contact id: “'0038b00002iOFd9AAG”,

firstname: "Andrea", lastname: "Palladio",