Show TOC

Procedure documentationConnecting to a Database Locate this document in the navigation structure

 

This procedure enables you to connect to a remote database and display an installed AS Java configuration.

Procedure

  1. Start the Config Tool by double-clicking the configtool script file in <SAP_install_dir>/<system_name>/<instance_name>/j2ee/configtool directory.

  2. In the Connection settings dialog window, choose "Yes" if you want to connect to the default database, or "No" to connect to a different one.

    The default database connecting is via the Secure Store.

    Note Note

    If you check the "Do not ask me again" indicator, next time you start the Config Tool, it will automatically connect to the default database.

    To connect to a different database, you can remove the config.properties file from the configtool directory. Then, start the Config Tool.

    End of the note.

  3. In the Connect dialog window, choose whether to connect via secure store or via direct login and enter the required data in the relevant fields.

Connecting Settings

Secure Store Settings

Description

Example

Secure Store File

Contains the path to the secure store properties file. This file is encrypted for security reasons.

C:/usr/sap/CE1/SYS/global/security/data/SecStore.properties

Secure Store Key File

Contains the path to the secure store key file. The key file contains the password for the encrypted store file.

C:/usr/sap/CE1/SYS/global/security/data/SecStore.key

System Name

Displays the name of the system to which this data applies.

CE1

Secure Store Lib

Specifies the security directory. It contains IAIK JAR files you need to use to open the Secure Store.

C:/usr/sap/CE1/SYS/global/security/lib

RDBMS Connections

A property key, by which the value contains the DB connection settings.

jdbc/pool/CE1

Direct Login Settings

Description

Example

RDBMS URL

Specifies the URL for the database connection in the correct format for the corresponding driver.

jdbc:sapdb://sofD60163517A/CE1?timeout=0&spaceoption=true&unicode=true

Driver name

Specifies the class name of the JDBC driver to be used for database connections.

com.sap.dbtech.jdbc.DriverSapDB

RDBMS user

Specifies the user name for this database connection.

SAPCE1DB

RDBMS password

Specifies the password set during the installation of the relevant AS Java.

IAIK Library

Specifies the IAIK JAR files directory. It enables the encrypting and decrypting of the properties file.

;C:\usr\sap\CE1\SYS\global\security\lib\tools\iaik_jce.jar; C:\usr\sap\CE1\SYS\global\security\lib\tools\iaik_jsse.jar; C:\usr\sap\CE1\SYS\global\security\lib\tools\iaik_smime.jar; C:\usr\sap\CE1\SYS\global\security\lib\tools\iaik_ssl.jar

General Settings

Description

Example

RDBMS Driver Location

Contains the path to the RDBMS driver.

C://sapdb/programs/runtime/jar/sapdbc.jar

RDBMS Initial Connections

Specifies the number of database connections to be created initially in the connection pool.

1

RDBMS Maximum Connections

Specifies the maximum number of database connections to be kept in the connection pool.

10

After filling the connection fields, you have the following options:

  • Directly connect to the relevant database. Choose Connect to DB.

  • Save the connection properties you have just set as following:

    1. Choose Save Connection As.

    2. Enter a file name with the extension “properties”, for example user.properties.

    3. Choose Save.

  • Open a previously saved “.properties” file to connect to a particular database. Choose Load Connection Settings.

Result

You successfully connect to a database.

After opening the GUI Config Tool, you can proceed the following steps for better future use:

  • If you want the Connection settings dialog box to appear again on startup, choose   View   Startup Options.  . Then, in the dialog window, check Show connection dialog.

    The other way is to delete the visual.properties file. Then, start the Config Tool.

  • If you use a Linux operating system, choose   View   Startup Options  . Then, in the dialog box, check Use loading indicator.

    This is necessary for the system to provide a better performance of the GUI Config Tool when you work with instances.

    Note Note

    If you are not available to proceed this via the GUI tool, in the configtool folder, open for text editing the visual.properties file. Then, add the line: show.loading.indicator=YES.

    End of the note.