topic Re: Shared DB Multitenancy in Alfresco Archive

Shared DB Multitenancy

hari — Wed, 20 Jan 2016 09:59:16 GMT

Hi, We would like to implement shared db multi-tenancy and would need some inputs from you to proceed on this. We have already delivered some part of the application to our client and he wants to implement the same for the entire group of companies that they own. Below are some of my questions that

Re: Shared DB Multitenancy

jbarrez — Thu, 21 Jan 2016 09:08:06 GMT

1) The engine is multi tenant enabled out of the box, but Explorer is not (that would be manual coding, as we don't have plans to add that)

2) No, if you use the multi tenant engine option, the process would need to be duplicated for each tenant. It's a nice feature though … but we don't have it yet where you can have a process for all tenants

3) Add taskTenantId() option

Re: Shared DB Multitenancy

hari — Thu, 21 Jan 2016 09:30:40 GMT

Thanks for your reply Barrez. Appreciate your help.
I have one more query. We already have deployed 5 BPM's for the client. Now my question is how should I associate them to a tenant ?

Re: Shared DB Multitenancy

jbarrez — Fri, 22 Jan 2016 14:52:06 GMT

That's going to be hard - that would mean you manually would have to set the tenant id on the different tables.
You'd also need to update your logic, the API calls should become 'tenant-aware'

Re: Shared DB Multitenancy

hari — Fri, 22 Jan 2016 15:31:00 GMT

After reading your blog on multi-tenancy and the complexities involved with this(shared db multi tenancy) approach in our present scenario, I am thinking of multi-engine multi-schema multi tenancy for now as we have very limited time to deliver. But I believe with this approach we should be able to implement single engine multi schema multi-tenancy in future. What are your thoughts ?

Re: Shared DB Multitenancy

jbarrez — Mon, 25 Jan 2016 08:52:59 GMT

Yes, indeed, that's a correct assumption, but I don't know if someone has actually tested it out before.
But in theory, yes, you are correct.

Re: Shared DB Multitenancy

hari — Tue, 16 Feb 2016 06:59:50 GMT

I am just wondering how can I do the multi schema, multi engine, multi tenancy using activiti-rest ?
Do I need to build my wrapper and expose my own REST services or does activiti-rest support this out of the box ?

Re: Shared DB Multitenancy

jbarrez — Tue, 16 Feb 2016 12:17:31 GMT

yeah, you'd have to proxy that yourself and do the switching yourself.
Activiti-rest doesn't have anything there that could do this.

Re: Shared DB Multitenancy

ak1801 — Mon, 26 Sep 2016 14:31:13 GMT

Hi jbarrez,

Referring to your blog - http://www.jorambarrez.be/blog/2015/10/06/multi-tenancy-separate-database-schemas-in-activiti/
I want to implement multi-engine multi tenancy in my application. Is there any way, I can configure it directly or do I have to implement myself?

Thanks in advance.