Most software-as-a-service products keep every customer’s data in the same tables, separated by a customer identifier on each row. It is efficient, and it works until a single missing filter in one query shows one customer another’s records. Simson Desk separates customers a level lower.
Two ways to build it
| Shared tables | A database per customer | |
|---|---|---|
| Separation | A column on every row | A separate database |
| What a query bug can expose | Another customer’s rows | Nothing outside that database |
| Backup and restore | All customers together | One customer at a time |
| Deleting a customer | Row by row, across every table | Remove the database |
| Cost to operate | Lower | Higher |
How it works in Simson Desk
Each customer has a workspace at its own address and a database dedicated to it. A request arriving at that address is connected to that database and no other. There is no query that can cross from one customer to another, because the other customer’s data is not in the database being queried.
What it means for you
- Due diligence: “is our data logically separated from other customers’?” has a short answer.
- Restore: your data can be restored without touching anyone else’s.
- Exit: when you leave, your database is removed as a unit.
- Residency: your data sits in India, in a database you can point to.
Around the database
- Data in transit is encrypted with TLS 1.2 or later.
- Sensitive fields, backups and session recordings are encrypted with AES-256.
- Backups are taken nightly and encrypted.
- A warm standby runs in a second zone.
- Security assessments of code and network are carried out regularly, with findings tracked to closure.
What it does not do
Isolation between customers says nothing about access inside your own workspace. That is governed by roles and module access, two-factor sign-in and the audit trail — which are yours to configure.
- Does each customer really have a separate database?
- Yes. It is a dedicated database, not a shared table with a customer column.
- Where is the data hosted?
- In India, with a warm standby in a second zone.
- Can our data be restored on its own?
- Yes. Each customer’s database is backed up and restored separately.