Multi_Tenant reference

Markfre1

I'm not sure how to do this.

I have the main company (tenant) ID. I'm not sure how each file should be handled.

Do I add a reference from the tenant to every file?
Or do I just add a Tenant Id to each file and on create modify, update it with the main company tenant Id?

With number 2, I can filter out based on the loggedinuser.tenantid.

I'm weak on references, and not sure if there is a way OR should use a REFERENCE approach for multi-tenancy. I want to use the best method. Not sure how I would do this using a query or protect to filter all matching records to the main company that is logged into with a Reference method?

I don't want to add the tenant Id to every file and add a rule if it is not necessary. No big deal, just want to do it correctly.

This is my last piece on setting up multi-tenancy within one BSV so your help is greatly appreciated.

Thanks,

Mark

Markfre1

I'm kind of going the Tenant ID update in each file and it seems to work well. Please advise if I should be doing it with references and how. Thanks Mark

hpl123

Hi Mark,
I also use the second approach and works in/for many scenarios and complex operations/filtering etc..

Markfre1

It seems approach 2 works. Could you confirm I am doing this correctly

What I am doing is creating a reference from Main Tenant File to each individual file and adding the TenantId to each file.

So MainCompany to Customer, MainCompany to Stores, MainCompany to User. The MainCompany has an auto increment TenantI when created. So when I am doing a query say on the customer its Customer.tenantid= LoggedInMainCompany.TenantId

The thing I was not sure about is if I just references the file, was there a way to do it without having the tenantid? But I think using the tenantid is easy and you could see it in the file.

I have one other issue. A user could be tied to multiple tenants. So Tenant is multiple and user is multiple. When a user logs in, if they are tied to multiple tenants, they have to select the tenant they want to work in. My thought on this was when selecting a tenant, to change the tenantId in the user for that session so all the queries work. Does that make sense?

This would complete an email type login system, allowing one user to work in multiple tenants which is real world possibility. In my case, an accountant might have access to the books of multiple clients running the system.

Appreciate the feedback if this whole approach makes sense, is not flawed, so I may move forward with the proper foundation.

Thanks,

Mark

hpl123

Sure, here are my thoughts. You are well on your way and seem to know a bit about Aware IM. It´s a lof of trial and error, testing different solutions and seeing if the whole thing works (i.e. the application).

Regarding the TenantId solution, I use this extensively and works very well and I THINK it offers better, more complex (and more secure) options than the references solution (I have not used the references solution to any extent though, anyone more experienced with it can maybe share some thoughts?).
The references solution does works for your purposes as well and you would basically create relationships from Mainompany to the various BO´s e.g. User and then use rules etc. e.g. default add from form, INSERT etc. to link e.g. MainCompany and User.

Regarding the multiple tenants solution you mention, this should work but I haven´t had a scenario like the one you describe so can´t tell you if it´s the best solution. Have a look at the sample applications and see how Awaresoft has done various related things (don´t know if it applies fully but you can always learn something)

Markfre1

Henrik,

Thank you for your feedback.

Yes the tenant solution seems to be the easiest.

I may have one misunderstanding. I thought I had to create a reference to each file, to find my way to the main company to get the tenant id. But as I look at it, I don't really need a reference back, because I am really just looking at the TenantId of the loggedin user which is always available?

So I think the references can go out the window? Makes sense?

I'm juggling a lot because I have storeadmin users, employees, outside users, etc and have to get my mind wrapped around it all.

Mark

PS: I'll remove the references and see if things still work.

Markfre1

Actually I probably need the references anyway because the main company has all these other files as peers.

Mark

hpl123

References are still useful in addition to using a TenantId and can in many cases simplify when doing operations, rule execution etc.. I saw another post you posted about how to work with references so won´t write more here.

Markfre1

Yes, thank you. Its all worked out. Just once last issue which I posted. Thanks for your help.

Mark