SAP Datasphere JDBC, ODBC, or other method for reading and writing data

[KarlHakanNordgr]

What methods exist for reading and writing data to SAP Datasphere?

I'm aware of the catalog and consumption OData APIs which allow reading metadata and data. I've just learned that there is a Python package `hdbcli` which allows reading and writing data.

I would very much like a Java-friendly approach to reading and writing data.

[JulianJuraske]

Hello,

as far as I'm aware there are two ways to write Data to Datasphere:

1. Integrating Data via Database Users/Open SQL Schemas
   https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/3de55a78a4614deda589633bae...
2. Unsing an HDI Container
   This is case when the Data is written from a SAP BAP(Business Application Studio)
   https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/1aec7ca95af24208a61c1a444b...

However I would rather use another approach using the SAP "Standard" and read the data instead of pushing(write) it into the Datasphere.
There are a LOT of supported Connecionts, just search for your's: 
https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/1aec7ca95af24208a61c1a444b...