Hi,

We're trying to implement a new module to a customer. We need to have a model which needs to be filled from an external oracle database. Normally we should create a scheduled job to read and import / update the data from external database to odoo's database. But this time we've nearly 20 million records and increasing every day so this is going to be a bit hard to manage creating new records or updating existing changed records. Is it possible to show data that we get from an external database without importing it to odoo's database. For example when a user navigates to a search / list view we should query the external database and prepare the data to be shown on the view and directly return it to that view.

Any guidance or example is very much appreciated.