Access the HANA database attached to a S/4HANA on-cloud

[MelCalucin]

I know that we can access the HANA database attached to a S/4HANA on-premise, but is it possible to access the HANA database attached to a S/4HANA on-cloud?

Would there be a difference between the Private and Public Editions of S/4HANA on-cloud

We want to connect Datasphere to the HANA database on a S/4HANA on-cloud.

Thanks.

Regards,

Mel Calucin

[George_Yu · Accepted solution]

Hi @MelCalucin ,

It is not a good idea to connect to the Public CLoud's database directly. From operations' point of view, they won't allow you to do that. It is different from on-premise world, since your IT controls everything, including backdoor access to the database.

In the Public Cloud, we provide API's for accessing the data. That is a standard approach in the cloud world. 

Regards,

George

[MelCalucin · Accepted solution]

Hi @George_Yu,

Thanks for the response.

On S/4HANA on-premise, we sometimes couldn't find the APIs that we wanted.  Some tables or table columns were not accessible via APIs. Consequently, we created custom ABAP CDS views and enabled them as APIs.   I don't believe we can make our own custom CDS views/APIs in S/4HANA public cloud.  Correct?

Thanks.

Regards,

Mel Calucin

[n_gaertner · Accepted solution]

Hello,

it is possible to create custom CDS Views (based on C1 released objects) and expose them via SQL Service for consumption in Datasphere Replication Flows.
See the documentation for more information.https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/ef2b2238154f4cd78a08df3604...

Best Regards,

Nico

[MelCalucin · Accepted solution]

Hi @n_gaertner 

Very interesting! Thanks for the response!

In "Using ABAP SQL Services for Accessing Data from SAP S/4HANA Cloud" (https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/ef2b2238154f4cd78a08df3604...),

It says "You can use the service to replicate data with replication flows or to federate data with remote tables."  Would this allow us to push down a select query from Datasphere onto the S/4HANA cloud HANA database?

What are the limitations that S/4HANA public cloud would have when using "Using ABAP SQL Services for Accessing Data from SAP S/4HANA Cloud" versus S/4HANA on premise when using "Using ABAP SQL Services for Accessing Data from SAP S/4HANA Cloud"?

Thanks!

Regards,

Mel Calucin

[n_gaertner · Accepted solution]

Hello Mel,

in general a limitation in the public cloud is that you can only use ABAP artifacts that are exposed via a stability contract.
That means that you can build your custom extraction enabled CDS Views only based on other Views that have been released by SAP - it is not possible to directly read from tables which are not exposed.
In Private Cloud you are able to build CDS Views more flexibly...

Pushdown of selection criteria should be possible (to some extent) using federation as well as in replication flows in Datasphere.

Best Regards,

Nico