This is the proposed layout or configuration of servers we are planning to use for finally installing and using Atlas. We have the OMOP data tables already loaded in an Oracle DB.
Could you please let me know if this configuration works:
WebAPI - Source & source_daimon configuration for Postgresql
Your server 2 looks like it has 2 schemas on it, but it should only have 1 schema: the webapi schema.
Serve 3 should have 2 schemas: your cdm schema, and your results schema.
Thanks a lot for your response Chris.
We will create a new Results schema on server 3. Where I can find details of the this schema, like what tables should be created etc.
When you have webapi running you can go to to /WebAPI/ddl/results?schema=YourSchemaName&dialect=oracle