I am looking at a couple of SaaS Policy Solutions and want to integrate those with an On Prem Policy System.
I am listing some goals below and approach I am considering. I am looking for any input on this approach / suggestions.
Create REST Apis that will return data from any of these 3 systems
The data returned from the Api should handle data from any of the 3 systems (so that the consumer does not have to call multiple Apis - hide the fact there are 3 systems)
To the consumer of the Api they have No Idea the data is from one or more systems.
Replicate the SaaS data (real-time) to the on prem system
Process that data through a transformation layer and populate a set of tables (a model we define to combine the 3 systems)
REST Apis obtain the data from #2 (transformed data). (meaning no transformation in the Apis, just interfaces/mapping/returned data.
This would be challenging to "fit" the model to three systems. But at the same time this transformation would seem to have to be at the database level to provide the Api with decent performance.