(DI-2108) Create a Secondary HANA Connection

Owned by SNP
Last updated: Aug 05, 2021 by Marian Vidra
1 min read

Datavard Insights is running on the SAP ABAP system, therefore it needs a secondary database connection to the Native HANA database for its monitoring.

To enable the connection to the HANA database, create the connection as follows:

  1. Start the transaction DBCO (or start transaction SM30, enter the Table/View DBCON and click Maintain)

  2. Click New Entries.

  3. Enter DB Connection (e.g. NATIVE_HANA) and set DBMS to HDB.

  4. Enter a valid User Name and DB password.

This user is not SAP user, but must exist on the HANA database and needs to have administrator privileges for the monitoring to work correctly (make sure that this DB user has assigned roles AFL_SYS_AFL_ERPA_EXECUTE and DBA_COCKPIT).

5. Enter hostname and communication port in the Conn. info field.

6. Save the connection

When the Database connection is created and saved, you might test it via the report ADBC_TEST_CONNECTION in transaction SE38.