After the user account is deactivated / locked, the user cannot connect to the SAP HANA database. To re-activate / unlock user <user_name> a user with system privilege USER ADMIN has either to use the command ALTER USER <user_name> ACTIVATE USER NOW or, in case of a user with PASSWORD authentication mechanism, to reset the user's password with ...
As described above, Splunk DBconnect can provide a JDBC connection to SAP HANA for data extraction, etc. I posted a separate answer explaining the setup as it is a non standard connection. As well, if this is a SAP ERP environment, there is an app called PowerConnect for SAP. validated SAP HANA appliance and SAP HANA Tailored Datacenter Integration setup. Solution If you upgrade from a lower SAP HANA SPS, it is application servers to connect to the wrong host after a HANA master node restart or indexserver crash, leading to the error: Connect failed (no reachable...
Connecting MS Excel to SAP HANA Step 1: Select the connection type Open the MS Excel spreadsheet. Go to the Data tab. Then select From Other Sources... Step 2: Select the data provider type Select Other/Advanced option from the Data Connection Wizard dialog and click Next. Step 3: Select the data ... As described above, Splunk DBconnect can provide a JDBC connection to SAP HANA for data extraction, etc. I posted a separate answer explaining the setup as it is a non standard connection. As well, if this is a SAP ERP environment, there is an app called PowerConnect for SAP.