Datasphere: Issues creating data federation connection between datasphere and S/4hana on-prem

[cassio_peia]

Hi guys,

we´re currently in the process of connecting our datasphere to S/4HANA on-Prem using ABAP SQL services for data federation. We´re struggling to establish the connection with S/4HANA

During setup we followed the official documentation:

• Cloud Connector: https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/f289920243a34127b0c8b13012...
• ABAP SQL Services: https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/4d7474595a5b41bb986616262f...

We get the following error message when trying to import remote tables in datasphere.

According to SAP Note 3076454 we have to install the ODBC driver on S4. However S4 team informed us no ODBC is required on S4 side but the pre-installed in datasphere is sufficient. Hence I´m a bit confused whether ODBC is needed on S4 for our scenario, any thoughts from your side?

In addition we have already checked Note 3586001 (https://userapps.support.sap.com/sap/support/knowledge/en/3586001), but haven´t been able to resolve this matter.

We´ve already double checked:

• Cloud connector settings
• Firewall (hanacloud.ondemand.com / k8s-hana.ondemand.com) and whitelisting all necessary IPs

Everything seems fine.

The S4 connection is validated reachable in cloud connector.

We looked into the cloud connector logs and see a failing handshake request and terminated connection due to SSL/TLS communication. Any advice how to approach this matter further? Looks to me we might have some certificate issues between cloud connector – BTP – Datapshere - S4, but that´s not really my area of expertise.

Any help appreciated!