Show TOC Entering content frame

Procedure documentation Editing JDBC System Properties Locate the document in its SAP Library structure

Use

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 Structure linkSystem 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: Distributed Query Engine

 

Admin Password (DQE)

·        Administrator password to back-end system for using DQE

Admin User ID (DQE)

·        Administrator ID to back-end system for using DQE

Category: Information

The property values in this category are assigned during the running of the System wizard and, except for Name and Description, are not for editing.

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 name of the connector on which the system is based, or through which it connects

·        Mandatory when working with a connector

 

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

 

 

Leaving content frame