SAP Hana Database monitoring configuration

After you define the scope of your configuration, you need to identify the following:

• Databases from which to collect data
• ActiveGates to execute the extension and connect to your devices

Example payload

Example payload to activate the SAP Hana extension:

jsoncopydownload
[
  {
    "value": {
      "enabled": true,
      "description": "My SAP Hana extension",
      "version": "0.1.1",
      "featureSets": [
        "io",
        "cpu",
      ],
      "sqlHanaRemote": {
        "endpoints": [
          {
            "host": "hanahost",
            "port": 1521,
            "authentication": {
              "username": "user",
              "password": "password"
            }
          }
        ]
      }
    },
    "scope": "ag_group-default"
  }
]

Parameters

Enabled

If set to true, the configuration is active and Dynatrace starts monitoring immediately.

Description

Human-readable description of the specifics of this monitoring configuration.

Version

Version of this monitoring configuration. Note that a single extension can run multiple monitoring configurations.

Feature sets

Add a list of feature sets you want to monitor. To report all feature sets, add all.

jsoncopydownload
"featureSets": [
  "cpu",
  "io"
  ]

Endpoints

You can define up to 100 endpoints in a single monitoring configuration in the sqlHanaRemote section.

jsoncopydownload
"sqlHanaRemote": {
    "endpoints": [
      {
        "host": "hanahost",
        "port": 1521,
        "authentication": {
          "username": "user",
          "password": "password"
        }
      }
    ]
  }

Authentication

Authentication details passed to the Dynatrace API when activating monitoring configuration are obfuscated and it's impossible to retrieve them.

Credential vault

The credential vault authentication type provides a more secure approach to using extensions by securely storing and managing user credentials. You need a credential vault that satisfies the following requirements:

• Credential type—User and password
• Credential scope—Synthetic (in case of external vault usage) and Extension authentication scopes enabled
• Owner access only is disabled

jsoncopydownload
"authentication": {
   "scheme": "basic",
   "useCredentialVault": "true",
   "skipVerifyHttps": false,
   "credentialVaultId": "some-credential-vault-id"
}

Scope

Note that each ActiveGate host running your extension needs the root certificate to verify the authenticity of your extension. For more information, see Sign extension.

The scope is an ActiveGate group that will execute the extension. Only one ActiveGate from the group will run this monitoring configuration. If you plan to use a single ActiveGate, assign it to a dedicated group. You can assign an ActiveGate to a group during or after installation. For more information, see ActiveGate group.

Use the following format when defining the ActiveGate group:

jsoncopydownload
"scope": "ag_group-<ActiveGate-group-name>",

Replace <ActiveGate-group-name> with the actual name.

SAP Hana JDBC Driver

The SAP Hana data source requires to put SAP Hana JDBC driver version 2.14.x in Dynatrace Extension Framework 2.0.

To define the SAP Hana Database server, put ngdbc.jar file in the following location on the ActiveGate host:

Windows: C:\ProgramData\dynatrace\remotepluginmodule\agent\conf\userdata\libs
Linux: /var/lib/dynatrace/remotepluginmodule/agent/conf/userdata/libs/