I ran into a similar hurdle with the new e-commerce project. The project is the interface for complete store management software (CMS + ERP + CRM). He should use a database of major products, but has his own records for product reviews, ratings, etc.
The initial thought was to make a cached copy of the main database. The website will benefit from fast loading times for cached items, but the implementation is not trivial.
After some considerations, the approach chosen updated the website database from the management program. Thus, a copy of the website will always be correct, and most of the implementation does not need to worry about REST services (it will still be used to register users, track shipment, etc.).
In your case, when you cannot remotely update your own database, you need to create a mechanism that allows you to reference REST resources, such as regular models, and cache them in the background.
Important note: research to ensure that the cache is always correct (not dirty) ...
Dor
source share