Hi @OOlashyn
I don't want to deal with synchronization, if I do what you suggest and connect my on prem with CDS I'll need to have a sync process in place, When working with Canvas Apss and Model Driven Apps you can use Data Gateway to connect them directly with the onprem data source.
I'd like to know if we can achieve this behavior with portals as well.