Hi,
I'm trying to create a SAAS project with thinkwise. My request is to store the data of all customers in a single datadase.
I did read the Tenants (https://docs.thinkwisesoftware.com/docs/iam_dev/tenants) documentation and I think, that I need to create a "Multi-tenant IAM & Multi-tenant product" solution. Is there any documentation of best practices on how to create a Multi-tenant product?
Thank you in advance
+4
I don't think there is a more functional description.. But basically you need to a tenant identifier to all your tables and use for example dynamic procedures to automatically filter all tables based on the tenant logged in. You can use a session variable for this.
But I am also interested in best practices on this subject.
+19
Not much to add
Data is separated from other tenants by utilizing an On hidden prefilter (or data authorization prefilter - in Roles) that filters all data based on the Tenant. This could be obtained via session variables or by creating a table in your end product where all users are stored inside a tenant.
Session variables would have my preference as you can then more easily switch between tenants; for example when your an administrator.
First of all, make sure you have a clear plan of how you want to separate Tenants in your end product. Also ensure that Tenants cannot see any data of other Tenants; via main screens, details, look-ups, API and so on, it has to be hidden for others.
I wouldn't recommend just starting to build the application and then Agile your way to Production. It has to be fundamentally strong to ensure integrity and security of the data. Using Indicium will help a lot as you then do not have to give any users rights to the database itself.
Hope this helps! Any more questions, just post them here 😁
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.