Products documentation

• Use this connector to connect directly to a MAXDB Database.
• It will give access to all components that can be monitored through Pro.Monitor MAXDB monitors
• To create a MAXDB connector, there are two steps:
  • Create a user profile in the database and register it in Pro.Monitor (Pro.Monitor SAP User)
  • Create and set connector parameters

• Pro.Monitor MAXDB connector uses JDBC to connect to the Database and SQL queries to inquire the database

• SAP 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 SAP User is by default associated with only one Group (Company). You can explicitly set a SAP User to be cross companies.

The effect is that it will be selectable from connectors of any company.

• The corresponding user must be created in SAP along with the appropriate authorizations.

• You must install MaxDB JDBC driver to connect to a MaxDB database
• Driver can be downloaded from maven repository
• Navigate to Setting→Updload/Download, and select upload other driver

• Select the system in the Systems tree and select “Add connector” in its contextual menu, then select “MAXDB” type.
• MAXDB connector input form will allow you configure it (see image below)
  • Title : This label will help you to identify the connector
  • Database host: the hostname or IP address of the System Database server
  • Database Port: the database port (Default 7200)
  • Database Name: Database to connect to
  • User: the SAP user profile to use for the connection
  • For specific settings “Use SSH tunnel” and “Custom timeout” see below section “Setting specific configuration”
• Press Save & Test to save the profile and check the connection is working

• In case you must connect to a database through an SSH tunnel, you can enable the SSH option and fill the parameters:
  • Host: The host where the entrance of the tunnel is created.
  • Port: The local port of the SSH tunnel
  • User: The user to authenticate on the SSH end point.

• See Custom timeouts

• SYSDBA.MONITOR_LOCK
• SYSINFO.DATAVOLUMES
• SYSINFO.DATASTATISTICS
• SYSINFO.LOGSTATISTICS
• SYSINFO.CACHESTATISTICS
• SYSINFO.INSTANCE