Integrating ArcGIS Pro with Sap Hana

[KrishnaPothineni1]

Hi All, I am trying to Enable Geodatabase enterprise after making a database connection with Sap Hana cloud in ArcGIS Pro and the test connection of Host server is successful.

I am getting an error when I try to enable geodatabase enterprise in ArcGIS Pro and the error message is:

Geodatabase must be enabled as geodatabase admin user.

Failed to execute (EnableEnterpriseGeodatabase).

I am using default DBADMIN of SAP Hana Cloud. Also, if I try to activate the SYSTEM user, I am unable to do so in SAP Hana Cloud. Am I doing something wrong, please guide.

Any suggestions or ideas, all are welcome? Kind of performing R&D

[MathiasKemeter]

To my knowledge ArcGIS generally requires a separate SDE user to enable a geodatabase (see here for similar issue). It is not possible to use DBADMIN even if the privileges are sufficient.

The individual steps for creating a geodatabase in SAP HANA can be found as part of the ArcGIS documentation. In particular, you need to pay attention to minimum privileges for the SDE user.

In summary, this should boil down to creating an SDE user and granting CATALOG READ:

CREATE USER SDE PASSWORD <password>;
GRANT CATALOG READ TO SDE;