Use SAP Datasphere for S/4HANA Data Migration Staging Tables (2Q2)

[tarrandurham]

Hello all

as per the usual method of using the HANA Cloud DB as Staging Tables in the S/4 - is it possible to use the HANA Space from the Datasphere in the same manner?

I have tried adding the Space Admin User as per the SAP_COM_0678 Communication Arrangement, but in the S/4 I only get connection errors. Whitelisting the IP might be the issue?

Best regards

Tarran

[michael_eaton3]

Hello

Yes, it is possible to use the HANA Cloud database that powers SAP Datasphere with Migration Cockpit. I would recommend creating a dedicated Database User in a Space, as this creates a new HANA database user with their own schema, which has full read/write access, you can then register this user with SAP_COM_0678.

Michael 

[tarrandurham]

-

[tarrandurham]

Hey Michael, appreciate your answer. Currently, I have a dedicated admin user with all authorisations in the space for this. But if I add all the credentials and hostname as per SAP_COM_0678, the migration cockpit gives me a connection error. And I have whitelisted S/4 IP's: 130.214.228.32/27 130.214.242.32/27. There is no way for me to debug the connection issue more. Have you done this before?

[michael_eaton3]

You have to use a database user, not a space user - "Create database users to connect external tools to SAP Datasphere."

[michael_eaton3]

https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/3de55a78a4614deda589633bae...

[tarrandurham]

See the issue in the migration cockpit: