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_schemastrueSkip system defined Schemas
retrieve_tablestrueRetrieve 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

DatabaseSoftwareInstance created, confirmedtype="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.

Was this page helpful? Yes No Submitting... Thank you

Comments