My customer informed me today, that the original database will be split in multiple databases, so for example an extra customer.db which will be used by BI / Microservices (have no more details yet).
My question: Is it possible to “unify” multiple db / multiple schemas in one DA server and if yes how?
Thanks in advance!
yes, it is possible.
You can pass from client what schema should be used.
DAServer sample - it emulates Relativity and can work with two different schemas. Name of default schema is stored inside session.
also you can use the OnValidateDatasetAccess event for changing active schema (i.e. ServiceSchema) in run-time. Enumerate your schemas and detect what schema contains required table.
Great, will work on it!
Should check samples more carefully …