SAP HANA Database - Database Detail Pattern
Pattern goal
The current pattern allows to discover and model databases, tables and schemas for SAP HANA Database instances as Detail nodes:
DB Detail has been linked to DB SI:
DB Detail:
Schema:
Table:
Setup
Setting of Database Credentials
Add the Database credentials, including Username and Password.
Configuration Options
There are several configuration options available for this product:
Option | Default value | Commentary |
|---|---|---|
skip_default_schemas | true | Skip system defined Schemas |
retrieve_tables | true | Retrieve Tables |
Setting the port
The core TKU SAP HANA Database Pattern discovers the listening port, this is the port that will be used.
Queries Run
The pattern runs the following database queries. When setting up the SAP HANA credential, ensure that it has SELECT access to the relevant databases.
Query | Reason |
|---|---|
SELECT * FROM "SYS"."M_DATABASES" | Get database list |
SELECT * FROM "SYS"."SCHEMAS" | Get list of schemas |
SELECT * FROM SYS.M_TABLES WHERE SCHEMA_NAME = "<schema_name>" | Get list of tables |
Platforms Supported by the Pattern
The pattern identifies databases, tables and tables of SAP HANA Database Server running on Windows and UNIX platforms.
Identification
Software Instance Triggers
Pattern | Trigger Node | Attribute | Condition | Argument |
|---|---|---|---|---|
Database | SoftwareInstance created, confirmed | type | = | "SAP HANA Database" |
Detail keys
The detail key consists of the key of the parent SAP HANA Database instance and the original database, schema or table name.
Testing
The pattern has been tested against live installations of the SAP HANA Database product on Windows and Linux.