Connecting to a Database
Use
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.
· If you set the “Do not ask me again” indicator, the next time you start the Config Tool, it will automatically connect to the default database.
To connect to a different database, remove the config.properties file from the configtool directory and restart the Config Tool.
· If you want the Connection settings dialog box to appear again on startup, select View → Startup options. Then, in the dialog window, set the Show connection dialog indicator.
The other way to reset the startup options is when you delete the visual.propertiesfile. Then, start the Config Tool.
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.
Connection 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 for the user of this database connection. |
<Instalation SAP NetWeaver AS Java password> |
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 |
4. 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:
i. Choose Save Connection As.
ii. Enter a file name with the extension “properties”, for example user.properties.
iii. Choose Save.
· Open a previously saved “.properties” file to connect to a particular database. Choose Load Connection Settings.