Hi Cuba team,
As I came from ERP background (Compiere, Adempiere, iDempiere, Navision, Dynamics etc)
I wish to ask whether below are easy to implement using CUBA studio
Note : Only 1 database for this project.
-
A user with a client id will only see his client data after login. (i have read the saas example in github). Is is possible to have 1 user access multiple client data? So that we do not need to create 1 user per client for the same physical user.
-
Each entity (table) should have 2 columns called company and organization. Organization belongs to Company belongs to Client. Said the login user has
client = 111
company = 222
organization = 333
all list and read or any operation must be upon unique rows of 111,222,333.
(optional) if company = 222,444 and organization = 333,555,666. Then all list and read or any operation will be upon rows of 111, 222 and 444, 333 and 555 and 666.
We are used to this pattern and our customers base also accept that. I understand that and read all your documentation that CUBA doesn’t seem to have this currently. What I need to know are ways to implement that.
There is a database issue.
The current project are using Postgres-XL. We will have 3 coordinators. 192.168.1.101:5432, 192.168.1.102:5432 and 192.168.1.103:5432. Said I will 3 middleware clusters host 3, host 4 and host 5 and wish to connect coordinator similar to normal postgresql connection
host 3 > 192.168.1.101:5432
host 4 > 192.168.1.102:5432
host 5 > 192.168.1.103:5432
host 3, 4 and 5 is from the same source code but the connection string will be different. i guess i can’t fix the connection string inside studio. do i need to modify property file for that inside each tomcat instance? where is the file location? My plan for development inside studio will be using either postgresql or postgres-xl (single coordinator) inside my laptop. When I finish war creation, after i deploy to each tomcat. Will it override my previous connection property file on each tomcat instance?
Thank you for helping.