3 ms·

@yogi - will retool work for non-multi-tenant environments to aggregrate & create tools for the same data from XXX+ databases? or more simply - can you connect

• dvdhsu 7y ago
  You can! If you watch the demo video (https://cdn.tryretool.com/videos/4_minute_demo_4827ae.mp4 https://cdn.tryretool.com/videos/4_minute_demo_4827ae.mp4), you'll see that every query could potentially come from a different datasource. So for example in our GDPR data export tool, we pull in data from Stripe, Salesforce, and a postgres database: https://retool.com/templates/gdpr-data-export/ https://retool.com/templates/gdpr-data-export/ Also — probably our coolest feature (IMO): you can query anything via SQL, including APIs. So you could query Stripe, Salesforce, etc. via SQL, since all data in Retool is in JSON. AND you can actually join across them too. Imagine joining a Google Sheet with Stripe data with data from your database. It's great fun! https://docs.tryretool.com/docs/querying-via-sql https://docs.tryretool.com/docs/querying-via-sql For example, here's how you query a JSON blob via SQL: select * from {{ [{ id: 1, apples: 3 }, { id: 3, apples: 20 }] }} where apples > 5 And here's how you join data from two separate APIs (that return JSON): select users.*, payments.* from {{ usersApi.data }} as users, {{ paymentsApi.data }} as payments where users.id = payments.user_id