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.
Smartscape node name: db.database.name
Smartscape node type: DB_DATABASE_HANA
A SAP HANA database entity.
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)
The ID is calculated based on the following fields in the defined order: host.name, db.database.name, db.connection_details.port
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA 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. |
|
| string | deprecatedThe 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 |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides 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. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
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.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_DATABASE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database. |
|
Specific attributes for all SAP HANA entities
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalCustom host name configured for the SAP HANA instance. |
|
| string | experimentalHost name of the SAP HANA instance. |
|
| string | resource experimentalHost name of the SAP HANA instance.Tags: |
|
Specific attributes of SAP HANA database entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalMaximum number of sessions allowed on the database. |
|
| string | experimentalMaximum number of transactions allowed on the database. |
|
| string | experimentalSecondary host name for system replication. |
|
| string | experimentalStatus of the system replication. |
|
| string | experimentalMode of the system replication. |
|
| string | experimentalIndicates whether full synchronization is enabled. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines 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. |
Smartscape node name: host.name
Smartscape node type: DB_INSTANCE_HANA
A SAP HANA instance entity. Represents a SAP HANA database host.
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 }
The ID is calculated based on the following fields in the defined order: host.name
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA 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. |
|
| string | deprecatedThe 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 |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides 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. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
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.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_INSTANCE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database instance. |
|
| string | experimentalVersion of the database instance as reported by the database vendor. |
|
Specific attributes for all SAP HANA entities
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalCustom host name configured for the SAP HANA instance. |
|
| string | experimentalHost name of the SAP HANA instance. |
|
| string | resource experimentalHost name of the SAP HANA instance.Tags: |
|
Specific attributes of SAP HANA instance entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalIP addresses of the SAP HANA instance. |
|
| string | experimentalLicensed memory limit of the SAP HANA instance. |
|
| string | experimentalLicense system identifier of the SAP HANA instance. |
|
| string | experimentalLicense expiration date of the SAP HANA instance. |
|
| string | experimentalIndicates whether the SAP HANA license is valid. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines 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. |
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.
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)
The ID is calculated based on the following fields in the defined order: host.name, service_name, port
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA 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. |
|
| string | deprecatedThe 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 |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides 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. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
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.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Specific attributes for all SAP HANA entities
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalCustom host name configured for the SAP HANA instance. |
|
| string | experimentalHost name of the SAP HANA instance. |
|
| string | resource experimentalHost name of the SAP HANA instance.Tags: |
|
Specific attributes of SAP HANA service entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the SAP HANA service. |
|
| string | experimentalPort of the SAP HANA service. |
|
| string | experimentalSQL port of the SAP HANA service. |
|
| string | experimentalStatus of the SAP HANA service. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines 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. |
|
| static | stableThis 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). |
|
| static | experimentalDefines an equivalence relationship. Examples: A database instance is the same as a host process. |