Persistence of CDS view created on S4HANA into a separate HANA Database

[SANA11]

Dear All,

Is there an option to persist CDS view data in the HANA database when HANA DB is being used as a middleware or data warehouse?

In my scenario, I have legacy data stored in HANA DB and OLTP data in S/4HANA. I would like to create a combined view of both datasets and expose it to SAC. My objective is to establish a mechanism that allows us to create CDS views in S/4HANA and transfer them to another HANA database, which will function as a middleware layer.

In my case, a custom SQL view (ZSQL) has been created in S/4HANA using CDS. How can this view be accessed or persisted in a separate HANA database that is acting as a middleware or data warehouse?
I have two HANA databases: one serving OLAP purposes (data warehouse/middleware) and the other being the S/4HANA OLTP system.

[HakanHaslaman]

CDS views in S/4HANA are not persisted physically by default; they are virtual and executed on-demand via SQL. To persist CDS view data in a separate HANA database, you have several architectural options, like SDI, SDA...