Show TOC

Procedure documentationEditing JDBC System Properties Locate this document in the navigation structure

 

The template for a JDBC system defines the specific parameters needed to connect to a database application, and contains a reference to the JDBC connector. The JDBC system inherits these properties, some with default values, others that require the setting of values. You edit the system by inserting needed property values and by modifying default values, if necessary.

The template contains many properties, not all of which can be edited, and not all of which are necessary to establish a connection to the back-end system.

The table below lists the properties needed to define connectivity to a JDBC application. Each has an explanation of the value that should be set.

Procedure

  1. From the top-level navigation bar, choose   System Administration   System Configuration  .

  2. From Detailed Navigation, choose System Landscape.

  3. In the Portal Catalog, right-click the system whose properties you want to edit, and from the drop-down list choose   Open   Object  . This opens the System Landscape Editor.

  4. Set your JDBC system properties according to the details in the table below.

    Property

    Value

    Category: User Management

    User Mapping Type

    • Defines the type of user mapping needed for connection; who can perform user mapping

    • Valid values: user/admin/admin,user

    For more information, see System Properties for User Mapping.

    Category: Connection Properties

    Connection Timeout

    • The maximum time the portal waits for a connection

    Connection URL

    • Defines the JDBC connection URL to the system.

    • Along with the Driver Class Name property and the User/Password values supplied by the User Mapping Service, this property enables connection to the external application.

    Driver Class Name

    • This value defines the JDBC driver used to connect to the system.

    • Along with the Connection URL property and the User/Password values supplied by the User Mapping Service, this property enables connection to the external application.

    Validate Connection

    Confirms the physical connection to the back-end system; for information, see SAP Note 754281

    Category: Information

    The property values in this category are assigned during the running of the System wizard.

    Description

    • An optional description of the system, if one was not inserted during the running of the System wizard

    System Name

    • The name assigned to the system when running the System wizard

    • Mandatory, exists for each system

    Object Type

    • Defines the type of the component; for example, system, page, iView, and so on. When importing components, the search could be based on this property

    • Exists for each system; assigned automatically when you launch the System wizard

    Category: Show all

    Connection Factory Class

    • The connection factory class name for the connector through which the system connects

    • Mandatory when working with a connector

  5. Save your settings and close the System Landscape Editor.