Hey everyone,
We’re excited to share that Sequin now supports Salesforce. Now you can build Retool apps with your contacts, accounts, and opportunities using SQL.
How Sequin works with Retool
With a couple of clicks, you'll map your Salesforce data to a Postgres database. Then, we'll keep your database in sync in real-time. All you have to do is connect your database to Retool using the standard Postgres connector.
Here is a 2-minute video of me showing how to set up a sync.
Benefits of building Retool apps with SQL:
With Sequin, you’ll use SQL to work with your Salesforce data. You don’t need to learn Salesforce Object Query Language (a.k.a SOQL), APEX REST queries, or get caught up in token and IP management.
For instance, if you want to get all the contacts associated with your Apple account you’ll use a classic SELECT and JOIN:
select * from contact join account on contact.account_id = account.id where account."name" ilike '%Apple%';
Out of the box, Retool has fantastic Postgres schema search, autocomplete, syntax highlighting, and error messaging so you can build quickly using the full tool stack.
If you are already using a Postgres database for your application data, we can sync to a schema in your existing database - so you can query across all your Salesforce and application data. No need for transforms or additional javascript to tie data together.
When should you use Sequin?
If you connect Salesforce to Retool, we’re a great option for you.
You can try it out totally free: https://sequin.io
If you’re curious about how it all works, check out our docs: Reference | Sequin
We’re looking forward to hearing feedback and answering any questions.