Integrating with SAP HANA

As a tenant administrator, it's important that you can monitor the connected systems and quickly identify and resolve any issues. The BMC Helix Intelligent Integrations SAP HANA connector collects alerts data from SAP HANA.

You can view the collected data in various BMC Helix applications and derive the following benefits:

BMC Helix application

Type of data collected or viewed

Benefits

BMC Helix Operations Management

Events (alerts received as events)

Use a centralized event view to monitor, filter, and manage events, and perform event operations in one place. 

Process events to help identify actionable events quickly from a large volume of event data.

For more information, see Monitoring events and reducing event noise.

BMC Helix AIOps

Situations (created from events)

Improve the mean time to resolve (MTTR) based on the situation-driven workflow.

Lower the mean time to detect or discover (MTTD) and the time required for investigating tickets.

For more information, see Monitoring situations.

BMC Helix Dashboards

Events

Create dashboards to get a consolidated view of data collected from third-party products across your environment. 

For more information, see Creating custom dashboards

Related topics

Supported-out-of-the-box-integrations-for-BMC-Helix-Intelligent-Integrations

Editing-and-deleting-integrations

Event-deduplication-and-suppression-for-reducing-event-noise


As a tenant administrator, perform the following steps to configure a connection with SAP HANA , verify the connection, and view the collected data in various BMC Helix applications.

Connector steps.png

Supported versions

This connector supports version 1.1.0.0 of  SAP HANA for data collection.

Planning for the connection

Review the following prerequisites to help you plan and configure a connection with SAP HANA.

SAP HANA prerequisites

Ensure that the SAP HANA user you plan to use for connecting to the SAP HANA database has the read-only permissions to the following entities:

  • _SYS_STATISTICS schema
  • STATISTICS_ALERTS_BASE, STATISTICS_CURRENT_ALERTS and STATISTICS_ALERT_INFORMATION views

BMC Helix Intelligent Integrations prerequisites

  • Depending on the location (SaaS, on-premises) of the third-party product, choose one or more BMC Helix Intelligent Integrations deployment modes and review the corresponding port requirements. For information about various deployment modes and port requirements, see Deployment-scenarios.
  • Based on the deployment modes, use the BMC Helix Intelligent Integrations SaaS deployment or the BMC Helix Intelligent Integrations on-premises gateway or both. For more information about the gateway, see Deploying-the-BMC-Helix-Intelligent-Integrations-on-premises-gateway.
  • The on-premises gateway must be able to reach the third-party product on the required port (default is 30015).

In the preceding list, third-party product refers to SAP HANA.

Configuring the connection with SAP HANA

  1. Failed to execute the [excerpt-include] macro. Cause: [Error number 2 in 0: No wiki with id [confluencePage:page] could be found]. Click on this message for details.
  2. On the CONNECTORS tab, clickadd_icon.png in the SOURCES panel.

  3. Click the 

    SAP HANA

     tile.

  4. Specify the following details for the source connection:

    1. Specify a unique instance name.

      Best practice
      We recommend that you specify the instance name in the following format: 

      <sourceType>_<sourceControllerServerName>_<InstanceQualifier>

      The instance qualifier helps you to distinguish the multiple instances configured from the same source server. For example, you can name your instances as SAP_Host_PROD, SAP_Host_TEST, and so on.

    2. Specify the SAP HANA database host name and the port number. The default port number is 30015.
    3. Enter the database user name and password for the SAP HANA database host.
    4. Specify the schema name.
    5. (Optional) Select the TLS Encryption option and specify the following details if the SAP HANA instance supports Transport Layer Security (TLS) protocol:
      • Specify a host name to verify the identity of the server, instead of the host name, if the connection is established from a client on the same host as the server. In a single-host system, a mismatch might arise between the host named in the certificate (actual host name) and the host used to establish the connection (localhost).
      • Select the Validate Certificate option to specify that the server’s certificate is validated.
      • Specify the path to the Trust Store file that contains server’s public certificates with the file format and the password to access the Trust Store file.

      • Specify the the location of the Java Key Store (JKS) with file format and the password to access the private key from the key store file.
        For more information about TLS protocol related parameters, see client-side TLS/SSL connection properties (JDBC) in the SAP HANA documentation.

    6. Specify the time, in seconds, after which no attempt should be made to establish the connection (default value is 30 seconds) .
    7. Specify the maximum amount of time allowed for a collection task to be completed.
  5. Click VALIDATE AND CREATE.
    The specified connection details are validated and the corresponding source connection is created in the Source Connection list.

  6. Select the source connection that you created from the list if it is not selected already.

    Important

    The destination host connection is created and configured automatically for each tenant when the source connection is created.

  7. Ensure that the options for the datatypes for which you want to collect data are selected.

  8. Configure the collectors for the selected data types by clicking the respective data type in the Collectors section. Specify the parameters for the selected data type, as explained in the following table:

  9. Click CREATE COLLECTORS to create the required collector streams for the selected data types.
  10. Configure the distributors for the selected data types by clicking the respective data type in the Distributors section and specify the parameters for the selected data type, as explained in the following table:
  1. Click CREATE DISTRIBUTORS to create the required distributor streams for the selected data types.
  2. Click one of the following buttons:
    • SAVE STREAM : Click this button if you want to edit the integration details before creating the instance. After you save the stream, the connector that you just created is listed in the SOURCES panel. Move the slider to the right to start the data stream.
    • SAVE AND START STREAM : Click this button if you want to save the integration details and start receiving data immediately.

          For more information about the data streams, see Starting-or-stopping-data-streams.


Verifying the connection

From BMC Helix Intelligent Integrations , on the SOURCES panel, confirm that the data streams for the connection you created are running. Data streaming is indicated by different colored moving arrows.

sap_hana_23_1_02.png

A moving blue arrow (EventsStream_Icon.png ) indicates that the alert stream is running. Event data will be pushed according to the configured Collection Schedule interval.

Viewing data in BMC Helix applications

View data collected from SAP HANA in multiple BMC Helix applications.

Failed to execute the [excerpt-include] macro. Cause: [Error number 2 in 0: No wiki with id [confluencePage:page] could be found]. Click on this message for details.

To view events in BMC Helix Operations Management

  1. In BMC Helix Operations Management, select Monitoring > Events.
  2. Filter the alerts by the SAPHanaAlert class.
    SAPEvents_BHOM_232.png

Incoming alerts from SAP HANA are processed in BMC Helix Operations Management through a set of deduplication rules to determine whether the incoming alert is a duplicate alert or a new alert. For more information, see Event-deduplication-and-suppression-for-reducing-event-noise.

For more information about events, see Monitoring and managing events.

Viewing Situations in BMC Helix AIOps

Before you view situations in BMC Helix AIOps, ensure that the following prerequisites are met: 

  1. CIs are present in BMC Helix Discovery or BMC Helix AIOps for the events that are being collected from SAP HANA .
  2. Create a Business Service model in one of the following applications:
  3. Perform one of the following tasks:

To view Situations

  1. In BMC Helix AIOps , go to the Situations page.
    This page shows the Situations created from the events that are ingested into BMC Helix Operations Management . 

  2. Click the required Situation to view the messages contained in the Situation and other details such as priority and severity of the message. 
    For information about Situations, see Monitoring situations.

Mapping between SAP HANA and BMC Helix Operations Management

The following table shows the mapping between SAP HANA and BMC Helix Operations Management:

Event attribute

SAP HANA

BMC Helix Operations Management

Event severity

Error

Critical

High

Major

Information

Information

Low

Warning

Medium

Minor

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*