Skip to main content
ServiceAnalytics
Availability8.6.0 or later

​
Feature

Allows you to create your own custom Database Table within Germain data model, without having to deploy a new release of Germain. These Tables can be used to store data which does not fit the out-of-the-box data model. Some customers have used this mechanism to integrate Germain with other database and store data into Germain datamart.

​
How to dynamically create a new custom database table

  1. Open GermainUX’s Config Console
    Open the Germain config console and navigate to germain.apm.monitoringConfig.systemConfig.datamart.dynamicTypes
  2. Add new dynamic type
  3. Next, define the fields that should be available on your new model class. By default, all model types have the following properties: A few examples of custom fields:
  4. Once you have defined the custom fields on your model, you must choose which of these should be included for aggregation. Any fields that are not included will only be available as long as there is raw data. Once the raw data has been purged, only aggregated fields will remain. To configure the aggregated fields, navigate back to the custom type and click on the aggregateFields collection. Then add any field names that you want to include – as before, you do not need to specify the build-in fields id, type, and timestamp.
  5. At this point your model is complete. In order to make the Germain system aware of the new model, a restart of the Germain services is necessary.
  6. Once the services have been restarted, you can now retrieve the schema for your database implementation by navigating to the following URL on your browser:https://<path to your Germain>/query/schema/<database flavor>/<type name>For example, to get the schema for a type named “CustomFact” on Oracle, use the following URL:https://<path to your Germain>/query/schema/ORACLE/CustomFactOnce you create the tables in your datamart schema, you are ready to reference the new model type in monitoring rules and KPIs.
Dynamic Database Table Creation: How to dynamically create a new custom database table
Dynamic Database Table Creation: How to dynamically create a new custom database table, image 2
Dynamic Database Table Creation: How to dynamically create a new custom database table, image 3
Dynamic Database Table Creation: How to dynamically create a new custom database table, image 4
Dynamic Database Table Creation: How to dynamically create a new custom database table, image 5
Dynamic Database Table Creation: How to dynamically create a new custom database table, image 6
Important reminder: indexes (and other tuning options) aren’t automatically generated to new custom database table. please have your DBA implement them to ensure optimal performance.

​
Get Help

Contact GermainUX Support

The Germain Team can help you set this up.

Can't find what you need?

Search all GermainUX docs with Ctrl + K, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE.