How to get data from HANA in different sub-accounts(Neo) with CAP service

[kaori_oiwa]

Hello Experts,

Currently, as shown in the figure below, I would like to create a mechanism to acquire data from HANA in a sub-account that is different from the sub-account where the application is placed and issue OData with the CAP service.

However, I don't know where and how to write connection information to access DBs in different subaccounts.

Is such a thing possible?

Best Regurds.

[gregorw]

Maybe the best way to realize this is to follow this documentation Connecting SAP HANA Cloud, SAP HANA database to Remote Data Sources. That way you can still use the normal service keys for the HDI Container in BTP Cloud Foundry.

[kaori_oiwa]

Thank you for your reply.

In the case of the procedure you taught, isn't it necessary to have a database on the CloudFoundry side as well?

This time, I would like to create an application as a utilization sample of the CAP service.

However, the existing HANA exists in another subaccount (Neo).

Therefore, I would like to acquire data directly from HANA in the Neo environment and finally publish it as OData using functions such as the CDS view of the CAP service.

Is such a thing possible?