Try it free

SAP HANA

  • Latest Dynatrace
  • Reference
  • Published Jun 15, 2026

Contains entity definitions for SAP HANA database entities stored in Smartscape on Grail. All HANA entity types are prefixed with DB_* and end in _HANA.

SAP HANA database

Smartscape node name: db.database.name

Smartscape node type: DB_DATABASE_HANA

A SAP HANA database entity.

Query

Fetch all SAP HANA database entities.

smartscapeNodes DB_DATABASE_HANA

Get databases and corresponding instances.

smartscapeEdges "runs_on"
| filter matchesValue(source_type, "DB_DATABASE_HANA") and matchesValue(target_type, "DB_INSTANCE_HANA")
| fields database_name=getNodeName(source_id), instance_name=getNodeName(target_id)

ID input

The ID is calculated based on the following fields in the defined order: host.name, db.database.name, db.connection_details.port

Base entity fields

The following base fields are used for all entities.

AttributeTypeDescriptionExamples
idsmartscapeIdstable
Display name: ID
A Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs.
<type>-017198AD253CBD63
id_classicstringdeprecated
Display name: Classic ID
The entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the id field instead, which is the Smartscape ID.
<type>-017198AD253CBD63
namestringstable
Display name: Name
The entity name.
localhost; easyTravel; product-catalog
typestringstable
Display name: Type
The entity type. UPPER_SNAKE_CASE string that represents the type of the entity.
Tags: permission
TYPE_A
tagsrecordstable
Display name: Tags
A consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, release or name). The value of each nested field is the tag value from one or multiple contexts. Tags for specific context can be queried via tags:context field. Note that rule-based tags do not exist in the new model.
tags[tag_key-1] = [context_A_tag_val-1, context_B_tag_val-1]; tags[tag_key-2] = context_C_tag_val-1; tags:context_A[tag_key-1] = context_A_tag_val-1
lifetimetimeframestable
Display name: Lifetime
The lifetime of the entity. This is a record with two nested fields: start and end, which represent the time when the entity was first and last observed, respectively. Each time an entity is updated, the end time is updated to the current time.
{ start: 2022-07-06T13:36:00.808Z, end: 2024-04-11T06:56:01.204Z }
referencesrecordstable
Display name: References
Provides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target Smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command.
{ references[runs_on.host] : [HOST-C251A1173C2B4B39,HOST-0E9038C7C4409D69], references[runs_on.container] : [CONTAINER-68A08967EF4F675B] }
dt.security_contextstring[]resource stable
Display name: DT security context
The security contexts associated with the entity. For Smartscape entities, this field is always an array.
Tags: permission
[]

Database entity fields

Fields common to all entities within the databases model.

AttributeTypeDescriptionExamples
db.connection_details.ipipAddressexperimental
IP address of the listener to which Dynatrace is connected.
10.100.10.10
db.connection_details.hostnamestringexperimental
Hostname of the listener Dynatrace is connected to.
my-database-server.myorg.org
db.connection_details.portstringexperimental
Port of the listener Dynatrace is connected to.
5432
db.connection_detailsstringexperimental
Listener connection details in the form <hostname>:<port>/<database>.
my-database-server.myorg.org:5432/testdb
db.systemstringexperimental
Display name: Database system
An identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers.
mongodb; mysql

db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.

ValueDescriptionDisplay name
adabasAdabas (Adaptable Database System)Adabas
amazon-documentdbAmazon DocumentDBDocumentDB
aurora-mysqlAmazon Aurora MySQLAurora MySQL
aurora-postgresqlAmazon Aurora PostgreSQLAurora PostgreSQL
cacheInterSystems CachéInterSystems Caché
cassandraApache CassandraCassandra
clickhouseClickHouseClickHouse
cloudscapeCloudscapeCloudscape
cockroachdbCockroachDBCockroachDB
coldfusionColdFusion IMQColdFusion IMQ
cosmosdbMicrosoft Azure Cosmos DBCosmos DB
couchbaseCouchbaseCouchbase
couchdbCouchDBCouchDB
databricksDatabricks Data PlatformDatabricks Data Platform
db2IBM Db2IBM Db2
derbyApache DerbyDerby
dl/iIBM DL/IIBM DL/I
dynamodbAmazon DynamoDBDynamoDB
edbEnterpriseDBEnterpriseDB
elasticsearchElasticsearchElasticsearch
filemakerFileMakerFileMaker
firebirdFirebirdFirebird
firstsqlFirstSQLFirstSQL
geodeApache GeodeGeode
h2H2H2
hanadbSAP HANASAP HANA
hbaseApache HBaseHBase
hiveApache HiveHive
hsqldbHyperSQL DataBaseHSQLDB
informixInformixInformix
ingresIngresIngres
instantdbInstantDBInstantDB
interbaseInterBaseInterBase
keyspaces-cassandraAmazon Keyspaces for Apache CassandraKeyspaces
mariadbMariaDBMariaDB
maxdbSAP MaxDBSAP MaxDB
memcachedMemcachedMemcached
mongodbMongoDBMongoDB
mssqlMicrosoft SQL ServerSQL Server
mssqlcompactMicrosoft SQL Server CompactSQL Server Compact
mysqlMySQLMySQL
neo4jNeo4jNeo4j
neptuneAmazon NeptuneNeptune
netezzaNetezzaNetezza
opensearchOpenSearchOpenSearch
oracleOracle DatabaseOracle
other_sqlSome other SQL database. Fallback only. See notes.Other SQL
pervasivePervasive PSQLPervasive PSQL
phoenixApache PhoenixApache Phoenix
pointbasePointBasePointBase
postgresqlPostgreSQLPostgreSQL
progressProgress DatabaseProgress
redisRedisRedis
redshiftAmazon RedshiftRedshift
snowflakeSnowflake Data PlatformSnowflake Data Platform
spannerCloud SpannerCloud Spanner
sqliteSQLiteSQLite
sybaseSybaseSybase
teradataTeradataTeradata
valkeyValkeyValkey
verticaVerticaVertica

Database fields

Fields that are common across all DB_DATABASE_* type nodes.

AttributeTypeDescriptionExamples
db.database.namestringexperimental
Name of the database.
testdb; PDB1

SAP HANA entity fields

Specific attributes for all SAP HANA entities

AttributeTypeDescriptionExamples
custom_hoststringexperimental
Custom host name configured for the SAP HANA instance.
my-hana-host
hoststringexperimental
Host name of the SAP HANA instance.
hana-server-01
host.namestringresource experimental
Display name: Host name
Host name of the SAP HANA instance.
Tags: permission
hana-server-01; my-hana-host

SAP HANA database fields

Specific attributes of SAP HANA database entity.

AttributeTypeDescriptionExamples
max_sessionsstringexperimental
Maximum number of sessions allowed on the database.
1024
max_transactionsstringexperimental
Maximum number of transactions allowed on the database.
512
replication_hoststringexperimental
Secondary host name for system replication.
hana-standby-01
replication_statusstringexperimental
Status of the system replication.
ACTIVE; SYNCING; ERROR
replication_modestringexperimental
Mode of the system replication.
sync; syncmem; async
full_syncstringexperimental
Indicates whether full synchronization is enabled.
true; false

SAP HANA database relationships

TypeTarget typeKindDescription
runs_onDB_INSTANCE_HANAstaticstable
Defines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST.

SAP HANA instance

Smartscape node name: host.name

Smartscape node type: DB_INSTANCE_HANA

A SAP HANA instance entity. Represents a SAP HANA database host.

Query

Fetch all SAP HANA instance entities.

smartscapeNodes DB_INSTANCE_HANA

Count instances by their version.

smartscapeNodes DB_INSTANCE_HANA
| summarize count(), by: { db.instance.version }

ID input

The ID is calculated based on the following fields in the defined order: host.name

Base entity fields

The following base fields are used for all entities.

AttributeTypeDescriptionExamples
idsmartscapeIdstable
Display name: ID
A Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs.
<type>-017198AD253CBD63
id_classicstringdeprecated
Display name: Classic ID
The entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the id field instead, which is the Smartscape ID.
<type>-017198AD253CBD63
namestringstable
Display name: Name
The entity name.
localhost; easyTravel; product-catalog
typestringstable
Display name: Type
The entity type. UPPER_SNAKE_CASE string that represents the type of the entity.
Tags: permission
TYPE_A
tagsrecordstable
Display name: Tags
A consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, release or name). The value of each nested field is the tag value from one or multiple contexts. Tags for specific context can be queried via tags:context field. Note that rule-based tags do not exist in the new model.
tags[tag_key-1] = [context_A_tag_val-1, context_B_tag_val-1]; tags[tag_key-2] = context_C_tag_val-1; tags:context_A[tag_key-1] = context_A_tag_val-1
lifetimetimeframestable
Display name: Lifetime
The lifetime of the entity. This is a record with two nested fields: start and end, which represent the time when the entity was first and last observed, respectively. Each time an entity is updated, the end time is updated to the current time.
{ start: 2022-07-06T13:36:00.808Z, end: 2024-04-11T06:56:01.204Z }
referencesrecordstable
Display name: References
Provides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target Smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command.
{ references[runs_on.host] : [HOST-C251A1173C2B4B39,HOST-0E9038C7C4409D69], references[runs_on.container] : [CONTAINER-68A08967EF4F675B] }
dt.security_contextstring[]resource stable
Display name: DT security context
The security contexts associated with the entity. For Smartscape entities, this field is always an array.
Tags: permission
[]

Database entity fields

Fields common to all entities within the databases model.

AttributeTypeDescriptionExamples
db.connection_details.ipipAddressexperimental
IP address of the listener to which Dynatrace is connected.
10.100.10.10
db.connection_details.hostnamestringexperimental
Hostname of the listener Dynatrace is connected to.
my-database-server.myorg.org
db.connection_details.portstringexperimental
Port of the listener Dynatrace is connected to.
5432
db.connection_detailsstringexperimental
Listener connection details in the form <hostname>:<port>/<database>.
my-database-server.myorg.org:5432/testdb
db.systemstringexperimental
Display name: Database system
An identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers.
mongodb; mysql

db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.

ValueDescriptionDisplay name
adabasAdabas (Adaptable Database System)Adabas
amazon-documentdbAmazon DocumentDBDocumentDB
aurora-mysqlAmazon Aurora MySQLAurora MySQL
aurora-postgresqlAmazon Aurora PostgreSQLAurora PostgreSQL
cacheInterSystems CachéInterSystems Caché
cassandraApache CassandraCassandra
clickhouseClickHouseClickHouse
cloudscapeCloudscapeCloudscape
cockroachdbCockroachDBCockroachDB
coldfusionColdFusion IMQColdFusion IMQ
cosmosdbMicrosoft Azure Cosmos DBCosmos DB
couchbaseCouchbaseCouchbase
couchdbCouchDBCouchDB
databricksDatabricks Data PlatformDatabricks Data Platform
db2IBM Db2IBM Db2
derbyApache DerbyDerby
dl/iIBM DL/IIBM DL/I
dynamodbAmazon DynamoDBDynamoDB
edbEnterpriseDBEnterpriseDB
elasticsearchElasticsearchElasticsearch
filemakerFileMakerFileMaker
firebirdFirebirdFirebird
firstsqlFirstSQLFirstSQL
geodeApache GeodeGeode
h2H2H2
hanadbSAP HANASAP HANA
hbaseApache HBaseHBase
hiveApache HiveHive
hsqldbHyperSQL DataBaseHSQLDB
informixInformixInformix
ingresIngresIngres
instantdbInstantDBInstantDB
interbaseInterBaseInterBase
keyspaces-cassandraAmazon Keyspaces for Apache CassandraKeyspaces
mariadbMariaDBMariaDB
maxdbSAP MaxDBSAP MaxDB
memcachedMemcachedMemcached
mongodbMongoDBMongoDB
mssqlMicrosoft SQL ServerSQL Server
mssqlcompactMicrosoft SQL Server CompactSQL Server Compact
mysqlMySQLMySQL
neo4jNeo4jNeo4j
neptuneAmazon NeptuneNeptune
netezzaNetezzaNetezza
opensearchOpenSearchOpenSearch
oracleOracle DatabaseOracle
other_sqlSome other SQL database. Fallback only. See notes.Other SQL
pervasivePervasive PSQLPervasive PSQL
phoenixApache PhoenixApache Phoenix
pointbasePointBasePointBase
postgresqlPostgreSQLPostgreSQL
progressProgress DatabaseProgress
redisRedisRedis
redshiftAmazon RedshiftRedshift
snowflakeSnowflake Data PlatformSnowflake Data Platform
spannerCloud SpannerCloud Spanner
sqliteSQLiteSQLite
sybaseSybaseSybase
teradataTeradataTeradata
valkeyValkeyValkey
verticaVerticaVertica

Database instance fields

Fields that are common across all DB_INSTANCE_* type nodes.

AttributeTypeDescriptionExamples
db.instance.namestringexperimental
Name of the database instance.
my-database-server.myorg.org:5432; ORCLCDB1; MSSQLSERVER@EC2AMAZ-EV24GE8
db.instance.versionstringexperimental
Version of the database instance as reported by the database vendor.
21.0.0.0.0; 16.10 (Debian 16.10-1.pgdg13+1); 14.15

SAP HANA entity fields

Specific attributes for all SAP HANA entities

AttributeTypeDescriptionExamples
custom_hoststringexperimental
Custom host name configured for the SAP HANA instance.
my-hana-host
hoststringexperimental
Host name of the SAP HANA instance.
hana-server-01
host.namestringresource experimental
Display name: Host name
Host name of the SAP HANA instance.
Tags: permission
hana-server-01; my-hana-host

SAP HANA instance fields

Specific attributes of SAP HANA instance entity.

AttributeTypeDescriptionExamples
ip_addressesstringexperimental
IP addresses of the SAP HANA instance.
10.0.0.1
license_limitstringexperimental
Licensed memory limit of the SAP HANA instance.
128
license_idstringexperimental
License system identifier of the SAP HANA instance.
HDB
license_exp_datestringexperimental
License expiration date of the SAP HANA instance.
2026-12-31
license_validstringexperimental
Indicates whether the SAP HANA license is valid.
true; false

SAP HANA instance relationships

TypeTarget typeKindDescription
runs_onHOSTstaticstable
Defines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST.

SAP HANA service

Smartscape node name: service_name

Smartscape node type: DB_SERVICE_HANA

A SAP HANA service entity. Represents a service running on a SAP HANA instance.

Query

Fetch all SAP HANA service entities.

smartscapeNodes DB_SERVICE_HANA

Get services and corresponding instances.

smartscapeEdges "runs_on"
| filter matchesValue(source_type, "DB_SERVICE_HANA") and matchesValue(target_type, "DB_INSTANCE_HANA")
| fields service_name=getNodeName(source_id), instance_name=getNodeName(target_id)

ID input

The ID is calculated based on the following fields in the defined order: host.name, service_name, port

Base entity fields

The following base fields are used for all entities.

AttributeTypeDescriptionExamples
idsmartscapeIdstable
Display name: ID
A Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs.
<type>-017198AD253CBD63
id_classicstringdeprecated
Display name: Classic ID
The entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the id field instead, which is the Smartscape ID.
<type>-017198AD253CBD63
namestringstable
Display name: Name
The entity name.
localhost; easyTravel; product-catalog
typestringstable
Display name: Type
The entity type. UPPER_SNAKE_CASE string that represents the type of the entity.
Tags: permission
TYPE_A
tagsrecordstable
Display name: Tags
A consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, release or name). The value of each nested field is the tag value from one or multiple contexts. Tags for specific context can be queried via tags:context field. Note that rule-based tags do not exist in the new model.
tags[tag_key-1] = [context_A_tag_val-1, context_B_tag_val-1]; tags[tag_key-2] = context_C_tag_val-1; tags:context_A[tag_key-1] = context_A_tag_val-1
lifetimetimeframestable
Display name: Lifetime
The lifetime of the entity. This is a record with two nested fields: start and end, which represent the time when the entity was first and last observed, respectively. Each time an entity is updated, the end time is updated to the current time.
{ start: 2022-07-06T13:36:00.808Z, end: 2024-04-11T06:56:01.204Z }
referencesrecordstable
Display name: References
Provides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target Smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command.
{ references[runs_on.host] : [HOST-C251A1173C2B4B39,HOST-0E9038C7C4409D69], references[runs_on.container] : [CONTAINER-68A08967EF4F675B] }
dt.security_contextstring[]resource stable
Display name: DT security context
The security contexts associated with the entity. For Smartscape entities, this field is always an array.
Tags: permission
[]

Database entity fields

Fields common to all entities within the databases model.

AttributeTypeDescriptionExamples
db.connection_details.ipipAddressexperimental
IP address of the listener to which Dynatrace is connected.
10.100.10.10
db.connection_details.hostnamestringexperimental
Hostname of the listener Dynatrace is connected to.
my-database-server.myorg.org
db.connection_details.portstringexperimental
Port of the listener Dynatrace is connected to.
5432
db.connection_detailsstringexperimental
Listener connection details in the form <hostname>:<port>/<database>.
my-database-server.myorg.org:5432/testdb
db.systemstringexperimental
Display name: Database system
An identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers.
mongodb; mysql

db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.

ValueDescriptionDisplay name
adabasAdabas (Adaptable Database System)Adabas
amazon-documentdbAmazon DocumentDBDocumentDB
aurora-mysqlAmazon Aurora MySQLAurora MySQL
aurora-postgresqlAmazon Aurora PostgreSQLAurora PostgreSQL
cacheInterSystems CachéInterSystems Caché
cassandraApache CassandraCassandra
clickhouseClickHouseClickHouse
cloudscapeCloudscapeCloudscape
cockroachdbCockroachDBCockroachDB
coldfusionColdFusion IMQColdFusion IMQ
cosmosdbMicrosoft Azure Cosmos DBCosmos DB
couchbaseCouchbaseCouchbase
couchdbCouchDBCouchDB
databricksDatabricks Data PlatformDatabricks Data Platform
db2IBM Db2IBM Db2
derbyApache DerbyDerby
dl/iIBM DL/IIBM DL/I
dynamodbAmazon DynamoDBDynamoDB
edbEnterpriseDBEnterpriseDB
elasticsearchElasticsearchElasticsearch
filemakerFileMakerFileMaker
firebirdFirebirdFirebird
firstsqlFirstSQLFirstSQL
geodeApache GeodeGeode
h2H2H2
hanadbSAP HANASAP HANA
hbaseApache HBaseHBase
hiveApache HiveHive
hsqldbHyperSQL DataBaseHSQLDB
informixInformixInformix
ingresIngresIngres
instantdbInstantDBInstantDB
interbaseInterBaseInterBase
keyspaces-cassandraAmazon Keyspaces for Apache CassandraKeyspaces
mariadbMariaDBMariaDB
maxdbSAP MaxDBSAP MaxDB
memcachedMemcachedMemcached
mongodbMongoDBMongoDB
mssqlMicrosoft SQL ServerSQL Server
mssqlcompactMicrosoft SQL Server CompactSQL Server Compact
mysqlMySQLMySQL
neo4jNeo4jNeo4j
neptuneAmazon NeptuneNeptune
netezzaNetezzaNetezza
opensearchOpenSearchOpenSearch
oracleOracle DatabaseOracle
other_sqlSome other SQL database. Fallback only. See notes.Other SQL
pervasivePervasive PSQLPervasive PSQL
phoenixApache PhoenixApache Phoenix
pointbasePointBasePointBase
postgresqlPostgreSQLPostgreSQL
progressProgress DatabaseProgress
redisRedisRedis
redshiftAmazon RedshiftRedshift
snowflakeSnowflake Data PlatformSnowflake Data Platform
spannerCloud SpannerCloud Spanner
sqliteSQLiteSQLite
sybaseSybaseSybase
teradataTeradataTeradata
valkeyValkeyValkey
verticaVerticaVertica

SAP HANA entity fields

Specific attributes for all SAP HANA entities

AttributeTypeDescriptionExamples
custom_hoststringexperimental
Custom host name configured for the SAP HANA instance.
my-hana-host
hoststringexperimental
Host name of the SAP HANA instance.
hana-server-01
host.namestringresource experimental
Display name: Host name
Host name of the SAP HANA instance.
Tags: permission
hana-server-01; my-hana-host

SAP HANA service fields

Specific attributes of SAP HANA service entity.

AttributeTypeDescriptionExamples
service_namestringexperimental
Name of the SAP HANA service.
indexserver; nameserver; xsengine
portstringexperimental
Port of the SAP HANA service.
30003
sql_portstringexperimental
SQL port of the SAP HANA service.
30015
statusstringexperimental
Status of the SAP HANA service.
yes; no

SAP HANA service relationships

TypeTarget typeKindDescription
runs_onDB_INSTANCE_HANAstaticstable
Defines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST.
belongs_toDB_DATABASE_HANAstaticstable
This is similar to an aggregation in UML. It is a many-to-many relationship without existential properties (the destination is not composed of the sources).
same_asPROCESSstaticexperimental
Defines an equivalence relationship. Examples: A database instance is the same as a host process.