Adding a Database Connection  

...

       1.      Call the DBA Cockpit.

       2.      In the system landscape toolbar, choose DB Connections.

       3.      Choose Add.

The screen DB Connections – Add Connection Entry appears.

       4.      In the Connection Name field, specify the name of the connection.

This name is a unique ID that you can choose freely except for names that are reserved by SAP for generated connections. These can be, for example, administrator connections or connections that are used by systems from the system landscape directory (SLD).

       5.      Specify the database connection attributes as follows:

                            a.      In the Database System field, specify the name of the database platform.

                            b.      In the Connection Maximum field, enter an appropriate value. This value limits the number of database connections that are currently held by the SAP system. The SAP system does not let you exceed this limit.

                            c.      In the Connection Optimum field, enter an appropriate value. This value is a more flexible limit that can be exceeded.

                            d.      If you want the connection to be mandatory for the SAP system, select Permanent Connection. This parameter defines the availability of the database connection.

It is then handled like the local default connection, that is, if this database connection is not available for a work process, the work process of the SAP system cannot run.

You should set this parameter only if this connection is absolutely required to run your SAP system.

                            e.      In the User Name field, enter the name of the connect user. Make sure that you choose a user with the appropriate authorizations. For more information, see Maintenance Actions in the DBA Cockpit.

                              f.      In the Password field, enter a password for the connect user.

       6.      In the Connection Parameters table, specify the following additional database-specific attributes:

Attribute	Description
Database Name	Name of database
Service Name	Name or number of the service This value corresponds to the parameter SVCENAME of the database manager configuration (DBM) of the remote database.
Database Host	Name of the remote database server
Schema Name	Name of schema to be monitored If you omit this field, the name of the specified connect user is used as default schema.

To support new connection parameters and for support scenarios, you might have to add connection parameters in an unchecked raw format. To be able to do so, choose Guided Mode <-> Expert Mode and switch to the expert mode. In the expert mode, you can enter connection parameters as a string instead of using the guided mode. However, we do not recommend that you use the expert mode.

       7.      To confirm your entries, choose Save.

Result

As soon as the connection has been specified, the DBA Cockpit connects automatically to the newly added database system and displays data on the System Data tab page.