===== HANA connector =====
==== Purpose ====
  * With the HANA DB connector, you can collect information directly from the database itself:
  * All statistics data (service status, CPU, disk, memory, threads, connections, etc…),HANA alerts, Performance statistics and more
  * Unlike other systems, **HANA connectors will be created automatically** based on system settings
  * This connector uses a direct SQL connection in the database
  * To create HANA connector, there are two steps:
    - Create a DB user and register it in Pro.Monitor
    - Edit the HANA system and register connection 

  * **Note:** You must install HANA **ngdbc.jar** driver if you want to connect to a HANA database

==== Create user profile ====
  * User profiles can be reached via  Systems->SAP users
  * Create a new profile using the “Add” button
  * Once created, the user profile can be selected in the connector form
  * Note: A user profile is by default associated with a company . You can explicitly set a profile to be cross companies. The effect is that it will be selectable from connectors of any companies.
  * The corresponding user must be created in the database and must be granted with MONITORING role

==== Create connector ====
  * Edit the system and fill common parameters: System ID, instance number and description
  * In the Nodes section: Define the hostnames of the nodes of the system (can be multiple in case of scaleout system)
  * In the Databases section you can define the tenants that you want to monitor:
    * Title: the display name of the tenant
    * Tenant: the tenant name in the DB
    * Default port: If active, will compute the tenant’s port based on its system number
    * SQL port: The custom port if default port if disabled.
    * User: The user profile to use for the connection
    * Secure: To enable if secure connection is going to be used
    * Primary: To enable if the system is replicated and is a primary node.
    * Press Save & Test to save the profile and check the connection is working
One connector per tenant will be created

{{:products:promonitor:6.5:userguide:systemsconnectors:pasted:20180316-114744.png}}
{{:products:promonitor:6.5:userguide:systemsconnectors:pasted:20180316-114758.png}}