Important note : The 2.8 line of WebAPI will be the last release to support Oracle and MS Sql as the WebAPI database platform. (Note CDM databases are not impacted by this). So, for future major/minor releases, you will need to install a Postgres instance. We can look into community driven support for other platforms, but going forward official support will be limited to Postgresql for WebAPI.
This is clear. However, I’m unsure about the
results schema referenced by the documentation for CDM Configuration for use with WebAPI.
If I have my CDM database on SQL Server and my OHDSI database on PostgreSQL, then which one should (or can) contain this read-write
Must it be in my OHDSI database on PostgreSQL?
Or do I have the flexibility – even under WebAPI v2.9+ – to situate my
results schema on SQL Server alongside my CDM schema?