Creating a Secondary HANA Connection

CrystalBridge® Monitoring runs on the SAP ABAP system. Therefore, it needs a secondary database connection to the native HANA database to enable the monitoring.

Proceed as follows to enable the connection to the HANA database:

  1. Start transaction DBCO. Alternatively, you can start transaction SM30, enter the DBCON in the Table/View field and click Maintain.

  2. Click New Entries.

  3. In the DB Connection column, enter a database connection name, e.g. NATIVE_HANA.

  4. In the DBMS column, enter HDB.

  5. Enter a valid username and DB password.

NOTE The required user is a HANA database connect user that is created in the monitored HANA database. It must have administrator privileges for the monitoring to work correctly. You must also ensure that the roles AFL_SYS_AFL_ERPA_EXECUTE and DBA_COCKPIT are assigned to this user. We always recommend creating a dedicated database connect user for monitoring purposes instead of reusing any existing database users used for other applications. For security and compliance reasons, avoid using system users or SAP application connect users.
  1. In the Conn. info column, enter the hostname and the communication port.

  2. Click Save.

  • The connection has been enabled.

NOTE Once the connection is created and saved, you can test it by executing the report ADBC_TEST_CONNECTION.