topic Re: How to implement multi-schema, multi-tenancy in alfresco process services? in Alfresco Forum

How to implement multi-schema, multi-tenancy in alfresco process services?

KarekMedAM — Tue, 04 Apr 2023 10:35:47 GMT

Hello All,

I'm using Alfresco process services, I need to connect it to different schemas (two or more). Meaning, the same APS connected to different databases diff rent LDAP, AD, Mailing... So different subsidiary companies can use the same APS of the mother company. Is it possible? If so how to implement it and if not what is the alternative?

Thank you in advance

Re: How to implement multi-schema, multi-tenancy in alfresco process services?

openpj — Wed, 12 Apr 2023 10:04:58 GMT

You can enable Multi-Tenancy in two different ways:

Using a unique database with all the capabilities supported
Multi-Schema: configuring a different schema for each tenant with some limitations such as LDAP (auth & synchronization)

Take a look at the official documentation here:

https://docs.alfresco.com/process-services/latest/config/multi-tenancy/

Hope this helps

Re: How to implement multi-schema, multi-tenancy in alfresco process services?

KarekMedAM — Thu, 13 Apr 2023 15:43:25 GMT

Thanks for your help.

I followed the documentation, but the problem is that I can't find the "create new tenant" button

Re: How to implement multi-schema, multi-tenancy in alfresco process services?

openpj — Fri, 28 Apr 2023 06:36:52 GMT

There is no "Create New Tenant" button because you have to invoke an HTTP POST request to create a new tenant as described in the documentation. If your tenant name is acme then the HTTP call should be executed in the following way:

POST http://your-domain:your-port/activiti-app/api/enterprise/admin/tenants

with the following JSON body:

{
    "name" : "acme",
    "configuration" : "tenant.admin.email=admin@acme.com\n
    com.mysql.cj.jdbc.Driver\n
    datasource.url=jdbc:mysql://127.0.0.1:3306/tenant-acme?characterEncoding=UTF-8\n
    datasource.username=acme\n
    datasource.password=acme"
}