7. MaxDB Connector

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

• Redpeaks 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

• The connector requires a database SQLCLI user and a database operator DBMCLI user.
• Both users need to have the same username and password
• Please Note the password requirements for these users:
  • It must be in all CAPS.
  • It must be 8 characters or less.
  • Warning: Some symbols may cause problems when used in passwords, we know “$” works, however, be careful when using other symbols.
  • In some versions of MAXDB, you will need to use double quotes around <USER> and <PASSWORD>. (Double quotes not needed in the examples below)

• Open SAP MaxDB Command Prompt as Administrator
• Execute the following commands:

sqlcli -u SUPERDBA,<superdbapassword> -d <SID>
create user <monitoring_user> password <PASSWORD>
grant select on superdba.monitor_lock to <monitoring_user>  
grant select on sysinfo.datavolumes to <monitoring_user>  
grant select on sysinfo.datastatistics to <monitoring_user>  
grant select on sysinfo.logstatistics to <monitoring_user>  
grant select on sysinfo.cachestatistics to <monitoring_user>  
grant select on sysinfo.instance to <monitoring_user>

• Open SAP MaxDB Command Prompt as Administrator
• Execute the following commands:

dbmcli -u SUPERDBA,<superdbapassword> -d <SID>
user_getall
user_create <monitoring_user>,<PASSWORD>
user_put <monitoring_user> SERVERRIGHTS=+DBInfoRead
user_get <monitoring_user>

• See MaxDb driver properties