products:promonitor:6.8:userguide:configuration:systemsconnectors:maxdb

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.

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.